BI Developer (Power BI + Tableau)

EXL Talent Acquisition Team; Gurugram District; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

EXL Talent Acquisition Team is seeking a BI Developer with 5+ years of experience in designing, developing, and supporting BI and analytics solutions. Strong skills in Power BI, Tableau, and Excel are required to transform data into actionable insights in an insurance-leaning data context.

The role focuses on building dashboards, semantic models, KPI frameworks, and governance over reporting assets. You will collaborate with data engineers and participate in deployments across cloud platforms.

Qualifications

• 5+ years of experience in design, development, and support of BI and analytics solutions.
• Strong expertise in Power BI and Tableau for dashboards, reports, and scorecards.
• Proficiency in data modeling, DAX, Power Query, and data visualization best practices.

Responsibilities

• Design, develop, and maintain dashboards, scorecards, and reports using Power BI and Tableau.
• Build and optimize Power BI semantic models and Tableau data sources.
• Develop advanced DAX measures and Power Query transformations for data prep.
• Troubleshoot data model, report performance, and data quality issues.
• Design and maintain dimensional data models with fact and dimension tables.
• Analyze business data to identify trends and performance opportunities.
• Create KPI frameworks and executive dashboards.
• Collaborate with data engineering to ensure analytics-ready data.
• Participate in BI deployments, migrations, and environment management.
• Document BI solutions, data models, and business definitions.

Skills

Power BI

Tableau

Excel

DAX

Power Query

Data Modeling

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI Service

Tableau Server

Sigma Computing

Jira

Job description

Designation: BI Developer (Power BI + Tableau)

Experience: 5+

We are seeking a skilled BI Developer with 5+ years of experience in designing, developing, and supporting business intelligence and analytics solutions. The ideal candidate will have strong expertise in Power BI, Tableau, Excel, data visualization, data modeling, and analytics, with the ability to transform complex data into actionable business insights. Experience working with cloud data platforms and the insurance domain is a plus.

Key Responsibilities

• Design, develop, and maintain interactive dashboards, scorecards, and reports using Power BI and Tableau.
• Build and optimize Power BI semantic models and Tableau data sources to support business reporting and analytics needs.
• Develop advanced DAX measures and Power Query transformations for data preparation and analysis.
• Troubleshoot and resolve data model, report performance, and data quality issues.
• Design and maintain dimensional data models including fact and dimension tables.
• Analyze business data to identify trends, patterns, anomalies, and performance improvement opportunities.
• Develop KPI frameworks, metrics definitions, and executive reporting dashboards.
• Create meaningful visualizations and data stories that support business decision-making.
• Support self-service analytics initiatives by creating reusable datasets and governed reporting assets.
• Collaborate with data engineering teams to ensure data is accurate, complete, and analytics-ready.
• Participate in BI deployments, report migrations, and environment management activities.
• Document BI solutions, data models, reporting processes, and business definitions.

Required Skills Power BI

• Strong experience developing reports, dashboards, and scorecards in Power BI.
• Hands-on experience with data modeling, relationships, star schemas, and semantic models.
• Proficiency in DAX including calculated measures, time intelligence, and performance optimization.
• Experience with Power Query (M) for data transformation and preparation.
• Knowledge of Power BI Service features including workspaces, deployment pipelines, Row-Level Security (RLS), and scheduled refreshes.
• Experience implementing self-service reporting solutions and reusable datasets.

Tableau

• Experience building interactive dashboards and visualizations using Tableau.
• Understanding of Tableau Server/Tableau Cloud and published data sources.
• Ability to optimize dashboard performance and user experience.
• Experience designing enterprise reporting and analytics solutions using Tableau.

Microsoft Excel

• Advanced proficiency in Microsoft Excel for reporting, analytics, and data management.
• Strong experience with Pivot Tables, Pivot Charts, Power Pivot, and Power Query.
• Expertise in advanced Excel formulas and functions such as XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and logical functions.
• Experience performing data reconciliation, validation, trend analysis, and ad-hoc reporting.
• Ability to create automated reports, KPI scorecards, and executive reporting templates.
• Experience integrating Excel outputs with Power BI and other reporting platforms.

Data Analytics & Visualization

• Strong analytical and problem-solving skills with the ability to interpret complex datasets.
• Experience developing KPI frameworks, business metrics, and performance dashboards.
• Ability to perform trend analysis, variance analysis, root-cause analysis, and business performance monitoring.
• Expertise in data visualization best practices and dashboard design principles.
• Experience translating business requirements into actionable insights and analytics solutions.
• Knowledge of data profiling, data quality assessment, and data validation techniques.
• Strong understanding of storytelling with data and executive-level reporting.

Data Modeling

• Strong understanding of dimensional modeling concepts including fact and dimension design.
• Experience working with enterprise data warehouses and analytics data marts.
• Knowledge of star schema and data modeling best practices for BI reporting.
• Familiarity with ETL/ELT concepts and data integration processes.

Good to Have

• Experience with Snowflake and cloud-based analytics platforms.
• Exposure to Sigma Computing or other self-service analytics tools.
• Knowledge of insurance domain concepts.
• Familiarity with Agile delivery methodologies and tools such as Jira.
• Experience working in large-scale enterprise reporting and analytics environments.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or a related field.
• 5+ years of experience in Business Intelligence, Reporting, Data Analytics, or a related role.
• Strong passion for data visualization, analytics, and delivering business insights through data.