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.
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.
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.
Skills Required
- 5+ years of experience in Business Intelligence, Reporting, or Data Analytics
- Develop reports, dashboards, and scorecards in Power BI
- Proficiency in DAX including calculated measures and time intelligence
- Experience with Power Query (M) for data transformation
- Experience with Power BI data modeling, semantic models, and star schema design
- Knowledge of Power BI Service features including workspaces, deployment pipelines, RLS, and scheduled refreshes
- Experience building interactive dashboards and visualizations using Tableau
- Familiarity with Tableau Server/Tableau Cloud and published data sources
- Advanced Microsoft Excel skills (Pivot Tables, Power Pivot, Power Query, advanced formulas like XLOOKUP and INDEX-MATCH)
- Strong understanding of dimensional modeling including fact and dimension design
- Experience working with enterprise data warehouses and ETL/ELT concepts
- Experience with cloud data platforms
- Experience with Snowflake
- 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
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business Analytics, or related field
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
