Business Intelligence Engineer - Reinsurance

EXL; Gurugram District; On-site; INR 900,000 - 1,400,000; Full time

Benefits offered by this job

Mentoring program

Training in analytics tools

Growth opportunities

Job summary

EXL Analytics is seeking an experienced analytics professional to lead discovery of reporting and data landscapes, design data models, and develop analytics-ready datasets using SQL and Redshift.

You will build Power BI structures, define metric logic and data quality checks, collaborate with data engineering and business teams, and document data dictionaries and runbooks.

Qualifications

• Bachelor’s or master’s degree in a relevant field.
• Strong data modeling and dimensional modeling experience.
• Advanced SQL and analytics querying skills.
• Experience with Redshift or similar cloud data warehouse.
• Experience in Power BI datasets and semantic layers.
• Must be from Reinsurance domain expertise.
• 5+ years of experience.

Responsibilities

• Lead discovery of current reporting and data landscapes.
• Design logical and physical data models for analytics use cases.
• Develop analytics-ready datasets using SQL and Redshift.
• Build Power BI-ready data structures for self-service reporting.
• Define metric logic, mappings, lineage, and validation.
• Implement data quality checks for trusted analytics outputs.
• Support Power BI dashboard development and ensure alignment with business needs.
• Collaborate with data engineering, BI, product, and business teams.
• Prepare documentation including data dictionaries and runbooks.
• Assist migration and modernization of legacy reporting assets.
• Use SAS Viya or similar platforms to validate outputs.

Skills

SQL

Power BI

Data modeling

ETL/ELT

Dimensional modeling

Data warehousing

Education

Bachelor's/Master's in CS/IS/Analytics

Tools

Redshift

SAS Viya

Job description

EXL (NASDAQ:EXLS) is a leading operations management and analytics company that helps businesses enhance growth and profitability in the face of relentless competition and continuous disruption. Using our proprietary, award-winning Business EXLerator Framework™, which integrates analytics, automation, benchmarking, BPO, consulting, industry best practices and technology platforms, we look deeper to help companies improve global operations, enhance data-driven insights, increase customer satisfaction, and manage risk and compliance. EXL serves the insurance, healthcare, banking and financial services, utilities, travel, transportation, and logistics industries. Headquartered in New York, New York, EXL has more than 51,000 professionals in locations throughout the United States, Europe, Asia (primarily India and Philippines), Latin America, Australia, and South Africa.

EXL Analytics provides data-driven, action-oriented solutions to business problems through statistical data mining, cutting edge analytics techniques and a consultative approach. Leveraging proprietary methodology and best-of-breed technology

Please visit www.exlservice.com for more information about EXL Analytics.

Role and Responsibilities:

• Lead discovery of current reporting, BI, and data landscapes: inventory source systems, existing datasets, semantic models, KPIs, metric definitions, data gaps, and upstream/downstream dependencies.
• Design logical and physical data models for analytics use cases, including dimensional models, fact and dimension structures, conformed dimensions, aggregations, and curated reporting marts.
• Develop analytics-ready datasets using SQL and Redshift, including data transformation, joins, business rules, performance tuning, incremental loads, and data reconciliation.
• Build and maintain governed semantic layers and Power BI-ready data structures that enable self-service reporting, standardized metrics, and consistent business interpretation.
• Define and document metric logic, source-to-target mappings, lineage, grain, refresh frequency, business rules, and validation criteria for all analytical data assets.
• Implement data quality and validation checks including completeness, accuracy, duplication, referential integrity, reconciliation, and exception reporting to ensure trusted analytics outputs.
• Support Power BI dashboard development by shaping datasets, optimizing query performance, validating measures, and ensuring alignment between data models and business reporting needs.
• Collaborate with data engineering, BI, product, and business teams to deliver reusable, scalable, and well-governed analytics data products in an Agile delivery model.
• Prepare and maintain clear documentation including data dictionaries, model design notes, source-to-target mapping documents, acceptance criteria, data quality test results, and operational runbooks.
• Support migration, rationalization, and modernization of legacy reporting assets by identifying redundant datasets, retiring unused tables, and aligning future-state models to analytics requirements.
• Use SAS Viya or similar analytics platforms, where applicable, to understand legacy logic, validate analytical outputs, or support transition of existing analytical processes.

Candidate Profile:

• Bachelor’s/master’s degree in computer science, engineering, information systems, data analytics, operations research, or a related field.
• Strong hands‑on experience in data modeling for analytics, including dimensional modeling, star/snowflake schemas, fact and dimension design, metric standardization, and reporting marts.
• Advanced SQL skills with ability to write, debug, optimize, and performance‑tune complex analytical queries.
• Hands‑on experience working with Redshift or similar cloud data warehouse platforms for analytics workloads.
• Experience preparing Power BI‑ready datasets, semantic layers, measures, and reporting data structures to support scalable dashboards and self‑service analytics.
• Ability to translate business reporting requirements into source‑to‑target mappings, curated datasets, reusable data assets, and well‑documented analytical models.
• Strong understanding of ETL/ELT concepts, incremental loads, data transformations, reconciliation, and data quality checks for analytics engineering use cases.
• Experience documenting data dictionaries, metric definitions, lineage, grain, business rules, validation logic, and model design decisions.
• Must be from Reinsurance domain expertise
• 5+ years of experience.

What we offer:

• EXL Analytics offers an exciting, fast paced, and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world‑class analytics consultants.
• You can expect to learn several aspects of businesses that our clients engage in. You will also learn effective teamwork and time‑management skills - key aspects for personal and professional growth.
• Analytics requires different skill sets at various levels within the organization. At EXL Analytics, we invest heavily in training you in all aspects of analytics as well as in leading analytical tools and techniques.
• We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors.
• Sky is the limit for our team members. The unique experiences gathered at EXL Analytics set the stage for further growth and development in our company and beyond.