Job Title: Reporting Engineer
Experience: 5–8 Years Employment Type: Full-Time
Position Summary
We are seeking a skilled Reporting Engineer to design, develop, and optimize enterprise reporting and business intelligence solutions. The ideal candidate will have expertise in Power BI (Dashboards & Paginated Reports), SQL Server, T-SQL, Snowflake, Databricks, Data Warehousing, ETL processes, and SQL performance tuning. This role involves building scalable reporting solutions, developing data models, and delivering actionable insights that support business decision-making.
Key Responsibilities
- Design, develop, and maintain interactive dashboards using Power BI.
- Create and optimize Power BI Paginated Reports for operational and enterprise reporting.
- Develop complex SQL queries, stored procedures, views, and functions using T-SQL.
- Design and maintain semantic data models to support reporting and analytics.
- Develop and optimize ETL/ELT processes for integrating data from multiple sources.
- Build reporting solutions using data stored in SQL Server, Snowflake, and Databricks.
- Perform SQL query optimization and database performance tuning to improve reporting efficiency.
- Collaborate with business stakeholders to gather reporting requirements and translate them into technical solutions.
- Implement data validation, reconciliation, and quality checks to ensure reporting accuracy.
- Support enterprise data warehouse initiatives and reporting architecture improvements.
- Automate recurring reports and dashboard refresh processes.
- Monitor report performance and troubleshoot production issues.
- Document reporting solutions, data models, and technical specifications.
- Participate in Agile development, code reviews, and continuous improvement initiatives.
Required Skills
Technical Skills (Must Have)
- Microsoft Power BI (Dashboards)
- Power BI Paginated Reports
- SQL Server
- T-SQL
- SQL Query Optimization
- Stored Procedures
- Views and Functions
- Snowflake
- Databricks
- Data Warehousing
- ETL/ELT Development
- Data Modeling
- Git
Business Intelligence Skills
- Dashboard Development
- Report Automation
- KPI Development
- Data Visualization
- Business Reporting
- Performance Metrics
- Data Validation
Good to Have
- Azure Data Factory (ADF)
- Azure Synapse Analytics
- SSIS
- DAX
- Power Query (M Language)
- Python
- Azure Databricks
- CI/CD Pipelines
- Azure DevOps
- Microsoft Fabric
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.