Business Solution Architect

EXL Talent Acquisition Team; Pune District; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

EXL Talent Acquisition Team is seeking a Power BI Engineer in Pune with 10–12 years of BI experience, focused on analytics, data visualization, and enterprise reporting. The role emphasizes building scalable dashboards, data models, and governance aligned with Power BI and Fabric environments.

The candidate will design dashboards, craft DAX measures, and manage data pipelines using SQL, Power Query, and cloud services.

Qualifications

• Bachelor's degree in a related field.
• Strong analytical and problem-solving skills.
• Experience with BI platforms and reporting.
• Ability to translate requirements into visuals and KPIs.
• Knowledge of governance and data quality practices.

Responsibilities

• Design, develop, and deploy Power BI dashboards and reports.
• Build scalable data models (star/snowflake schemas) and complex DAX measures.
• Manage Power BI service workspaces, datasets, gateways, and refreshes.
• Collaborate with stakeholders to define KPIs and reporting requirements.
• Deliver actionable insights through storytelling and visualization best practices.

Skills

Power BI

DAX

SQL

Data Modeling

Data Visualization

KPI Development

Analytics

Governance

Education

Bachelor's Degree in CS/Engineering/Math

Tools

Power BI Desktop

Power BI Service

Power Query

Azure Data Services

Microsoft Fabric

SharePoint

GitHub

Azure DevOps

Job description

We are looking for a skilled Power BI Engineer with 10–12 years of experience in business intelligence, data visualization, and analytics. The candidate should have strong expertise in Power BI, DAX, Power Query, SQL, and data modeling, with experience building scalable dashboards and enterprise reporting solutions. Knowledge of Microsoft Fabric and Azure analytics services will be an added advantage. This JD aligns with internal BI platform and reporting capabilities documented for Power BI and Fabric environments.

Key Responsibilities

Dashboard & Report Development

• Design, develop, and deploy interactive Power BI dashboards and reports.
• Translate business requirements into impactful visualizations and KPIs.
• Create executive, operational, and analytical reporting solutions.
• Develop drill-through, drill-down, and self-service BI capabilities.

Data Modeling & Transformation

• Build scalable star and snowflake schema data models.
• Develop complex DAX measures, calculated columns, and KPIs.
• Perform data transformation using Power Query (M Language).
• Integrate data from SQL databases, cloud platforms, APIs, and flat files.

Power BI Administration

• Manage Power BI Service workspaces, datasets, gateways, and refresh schedules.
• Implement row-level security (RLS) and governance standards.
• Monitor report performance and optimize dataset refreshes.
• Support deployment pipelines and release management.

Analytics & Business Insights

• Collaborate with stakeholders to define KPIs and reporting requirements.
• Deliver actionable insights through data storytelling and visualization best practices.
• Perform data validation and quality assurance across reporting solutions.

Required Technical Skills

Visualization & Reporting

• Power BI Desktop
• Power BI Service
• Power Query
• Dashboard Development
• Data Storytelling
• Report Optimization

Data & Analytics

• Advanced DAX
• SQL
• Data Modeling
• Data Warehousing Concepts
• KPI Development
• Data Validation

Microsoft & Cloud Ecosystem

• Microsoft Fabric (Preferred)
• Azure Data Services
• Power Automate (Good to Have)
• SharePoint Integration

Development & Collaboration

• Git/GitHub
• Azure DevOps
• Agile/Scrum Methodology

Desired Experience

• 3–5 years of experience in Power BI development and analytics.
• Strong expertise in DAX, Power Query, and SQL.
• Experience creating enterprise-scale dashboards and semantic models.
• Exposure to Microsoft Fabric, Lakehouse, and Warehouse concepts.
• Experience working with business stakeholders and translating requirements into BI solutions.

Qualifications

• Bachelor's Degree in Computer Science, Engineering, Statistics, Mathematics, or related field.
• Strong analytical and problem-solving skills.

Preferred Certifications

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
• Microsoft Azure Fundamentals (AZ-900)

Key Competencies

• Power BI Development
• DAX & Data Modeling
• Data Visualization
• Business Intelligence
• Stakeholder Management
• Analytical Thinking
• Communication Skills