Business Data Analyst

EXL

Business Data Analyst supporting enterprise-level initiatives in the Property & Casualty Insurance domain. Collaborating with stakeholders and driving data accuracy through analysis and transformation.

Posted 6/19/2026full-time🇺🇸 United StatesMid-LevelSenior💰 $90,000 - $140,000 per yearWebsite

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Perform end-to-end data analysis, including data profiling, validation, and transformation for large-scale data integration and reporting projects.
Develop source-to-target data mappings (STTM) and documentation based on business requirements.
Collaborate with business users and stakeholders to gather, analyze, and translate functional requirements into technical specifications.
Work with data engineers and developers to implement and validate data consolidation, standardization, and transformation logic.
Optimize complex SQL queries for performance and accuracy in handling large datasets.
Participate in data quality assessments and recommend data cleansing or enrichment strategies.
Leverage domain knowledge of Property & Casualty Insurance—including policy administration and claims lifecycle—to ensure data alignment with business processes.
Facilitate communication between business SMEs, data modelers, and technical teams for successful data delivery and adoption.

Requirements

What you’ll need

Bachelors in related field
5+ years of hands-on experience in data analysis, data mapping, and data transformation within enterprise data environments.
Strong proficiency in SQL, including analytical functions, query optimization, and performance tuning.
Proven experience developing source-to-target mapping (STTM) documents and understanding ETL/data flow processes.
Exposure to data consolidation, standardization, and transformation across heterogeneous data sources.
In-depth knowledge of the Property & Casualty Insurance domain
Exceptional communication and interpersonal skills—able to work effectively with technical teams, business stakeholders, and subject matter experts.
Strong documentation skills with the ability to create clear and concise technical and business artifacts.

Benefits

Comp & perks

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisdata mappingdata transformationSQLquery optimizationperformance tuningETLdata consolidationdata standardizationdata profiling

Soft Skills

communication skillsinterpersonal skillscollaborationdocumentation skillsanalytical skills

Certifications

Bachelor's degree