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.