Job Description

We are looking for a skilled Power BI Developer / Data Analyst with 5–8 years of experience to design, develop, and maintain scalable data models and dashboards. The role involves working closely with business stakeholders to translate requirements into insightful analytics solutions that support decision-making.

Key Responsibilities:

- Design, develop, and deploy interactive dashboards and reports using Power BI
- Build robust data models using star schema / dimensional modeling principles
- Develop and optimize DAX calculations and measures for performance and scalability
- Extract, transform, and load (ETL) data from multiple sources including SAP, databases, and other data sources
- Collaborate with business users to gather requirements and translate them into analytical solutions
- Ensure data accuracy, consistency, and governance across reporting layers
- Optimize report performance, including query tuning and dataset management
- Work with large datasets using SQL and Python (preferred)




- Support deployment pipelines and version control practices
- Troubleshoot data and reporting issues, ensuring timely resolution
- Ensure data accuracy and consistency by implementing robust data validation, cleansing, and reconciliation processes across multiple data sources
- Maintain and enhance existing Power BI assets by optimizing performance, updating data models, and ensuring alignment with evolving business requirements
- Establish data quality checks and monitoring mechanisms to proactively identify anomalies and ensure reliability of reporting outputs
- Advanced Excel expertise including complex formulas, Power Query, and data modeling, enabling effective data transformation and analysis.
- Proven experience in building scalable Excel-based solutions for reporting, automation, and data validation.

📌 Data Analyst (Pune)
🏢 Smiths Group
📍 Pune