Job Details:
Report Development & Data Visualization:
• Design, develop, and maintain SSRS reports and dashboards based on business requirements.
• Optimize SQL queries and stored procedures for efficient data retrieval.
• Create parameterized, drill-through, and paginated reports.
• Ensure reports are responsive, user-friendly, and meet performance standards.
Database & Data Integration:
• Develop and maintain SQL Server databases for reporting and analytics.
• Work with ETL processes (SSIS, Azure Data Factory) to integrate data from multiple sources.
• Ensure data integrity, accuracy, and consistency across reports.
Azure & Cloud Integration:
• Utilize Azure SQL, Data Factory, and Data Lake for cloud-based reporting solutions.
• Deploy reports to Power BI Service or Azure Synapse Analytics when required.
• Implement security and access control for cloud-based reports.
Collaboration & Continuous Improvement:
• Work with business analysts and stakeholders to gather reporting requirements.
• Document report designs, queries, and database structures.
• Stay up to date with Azure reporting technologies and best practices.