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.

Positive 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.

Responsibilities

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.

Qualifications

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.

EXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration – and we’ve been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers.

We function as one team to make your goals our goals, whether that’s unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible.

Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It’s our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients.

Find out for yourself why clients, employees, and analysts think we’re some of the best in the business. Contact us to see how we can help you achieve your goals.

📌 BI Developer (Pune)
🏢 EXL
📍 Pune