Power BI Developer — Dashboards, Data Models & SQL

EXL; New York (NY); On-site; USD 95,000 - 130,000; Full time

Job summary

EXL Analytics is seeking a Power BI BI developer with 4+ years of experience to build and optimize semantic models and business dashboards. You will transform data using SQL and Databricks, design robust data models, and collaborate with stakeholders to deliver high-impact analytics.

You will work on scalable data pipelines, advanced DAX calculations, and performance tuning to support KPI reporting for insurance analytics. This role emphasizes collaboration and data-driven decision making.

Qualifications

• 4+ years of experience building Power BI semantic models and business-facing reports/dashboards.
• Strong hands-on experience transforming large/complex datasets with SQL and Databricks.
• Understanding how source data should be transformed and structured to support reporting and analytics.
• Experience with insurance analytics domain is a plus (Life Insurance preferred).

Responsibilities

• Build and maintain Power BI reports and dashboards for business users.
• Extract, transform, cleanse, and integrate data from multiple sources using SQL and Databricks.
• Design and implement semantic models with fact/dimension structures, relationships, and measures; develop DAX calculations.
• Develop scalable data transformation pipelines in Databricks to prepare analytics datasets.
• Write complex SQL queries for data extraction, transformation, aggregation, and quality validation.
• Collaborate with stakeholders and BI developers to translate requirements into data and semantic-model specs.
• Optimize SQL, Databricks transformations, and semantic models for performance and scalability.
• Support deployment, maintenance, and improvement of Power BI datasets and pipelines.

Skills

Power BI

SQL

Databricks

DAX

Data Modeling

ETL

Python/PySpark

Data Visualization

Performance Tuning

Education

Bachelor's or Master's degree in data science, economics, mathematics, CS/engineering or operations research

Tools

Databricks

Git

CI/CD

Power BI Deployment

Job description

EXL Analytics is seeking a Power BI BI developer with 4+ years of experience to build and optimize semantic models and business dashboards. You will transform data using SQL and Databricks, design robust data models, and collaborate with stakeholders to deliver high-impact analytics.

You will work on scalable data pipelines, advanced DAX calculations, and performance tuning to support KPI reporting for insurance analytics. This role emphasizes collaboration and data-driven decision making.