Business Data Analyst

EXL; Jersey City (NJ); On-site; USD 100,000 - 130,000; Full time

Job summary

EXL in New Jersey seeks a Business Data Analyst with strong expertise in large-scale data applications, data analysis, and transformation to support enterprise initiatives in the Property & Casualty insurance domain. You will apply SQL, data mapping, and business analysis skills, partnering with SMEs and engineers to drive data accuracy and alignment with business processes.

Responsibilities include profiling, validation, STTM documentation, and optimizing data flows to deliver reliable,

Qualifications

• 5+ years of hands-on data analysis, mapping and transformation in enterprise environments.
• Strong SQL skills with analytical functions and performance tuning.
• Experience developing source-to-target mapping (STTM) documents and ETL/data flow knowledge.
• Knowledge of Property & Casualty Insurance data is a plus.

Responsibilities

• Perform end-to-end data analysis, including profiling, validation and transformation for large-scale data projects.
• Develop source-to-target data mappings (STTM) and document based on requirements.
• Collaborate with stakeholders to translate requirements into technical specs.
• Work with data engineers to implement data consolidation and transformation logic.
• Optimize SQL queries for performance on large datasets.
• Participate in data quality assessments and enrichment strategies.
• Leverage P&C domain knowledge to align data with business processes.
• Facilitate communication among SMEs, data modelers and technical teams.

Skills

SQL proficiency

Data analysis

Data mapping

ETL / data flows

Job description

Base Compensation Range: 100,000 - 130,000

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process

Job Summary:

We are seeking a Business Data Analyst with a strong background in large-scale data applications, data analysis, and transformation to support enterprise-level initiatives in the Property & Casualty (P&C) Insurance domain. The ideal candidate will bring hands-on expertise in SQL, data mapping, and business analysis, along with deep domain knowledge of policy and claims data. This role requires close collaboration with business stakeholders, SMEs, and technical teams to drive data accuracy, consistency, and values.

Key Responsibilities:

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 datase

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.

Required Skills & Experience:

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 processeses

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