Sr. Business Data Analyst

Posted Yesterday
Jersey City, NJ, USA
Hybrid
100K-140K Annually
Senior level
Information Technology • Database • Consulting
The Role
Performs end-to-end data analysis, profiling, validation, mapping, and transformation for enterprise data integration and reporting. Develops source-to-target mappings, translates business requirements into technical specifications, optimizes SQL queries, and supports data quality and cleansing initiatives. Collaborates with stakeholders, data engineers, developers, and SMEs while applying Property and Casualty Insurance knowledge to policy and claims data.
Summary Generated by Built In

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

Base Compensation Range: 100,000 - 140,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.

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

Responsibilities

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

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

Qualifications

bachelors in related field 

Skills Required

  • 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
  • Experience developing source-to-target mapping documents and understanding ETL and data flow processes
  • Experience with data consolidation, standardization, and transformation across heterogeneous data sources
  • In-depth knowledge of the Property and Casualty Insurance domain
  • Strong communication and interpersonal skills for working with technical teams, business stakeholders, and subject matter experts
  • Strong documentation skills for creating technical and business artifacts
  • Bachelor's degree in a related field

EXL Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about EXL and has not been reviewed or approved by EXL.

  • Healthcare Strength — Medical plan options include HSA, HRA, and PPO choices, with additional health-related programs such as disability coverage and an employee assistance program. Feedback suggests these options provide meaningful flexibility and coverage breadth for many roles.
  • Leave & Time Off Breadth — Up to 20 days of paid time off, plus federal holidays and paid sick and safe time, are highlighted. Feedback suggests this leave structure is a notable benefit alongside core compensation.
  • Retirement Support — A traditional and Roth 401(k) with up to a 3% company match and full vesting after one year is described. Feedback suggests this match and vesting timeline help bolster long-term savings.

EXL Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: New York, NY
30,246 Employees
Year Founded: 1999

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.

Similar Jobs

BECU Logo BECU

Business Intelligence Analyst

Fintech • Financial Services
Remote or Hybrid
3 Locations
3000 Employees

Samsara Logo Samsara

Sr. Manager, Procure to Pay

Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Easy Apply
Remote or Hybrid
United States
4000 Employees
117K-209K Annually

Imprivata Logo Imprivata

Principal Product Manager

Healthtech • Information Technology • Security • Software • Cybersecurity
Remote or Hybrid
United States
1372 Employees
167K-203K Annually

Garner Health Logo Garner Health

Account Executive

Artificial Intelligence • Big Data • Healthtech • HR Tech • Machine Learning • Software • Big Data Analytics
Easy Apply
Remote or Hybrid
USA
590 Employees
160K-175K Annually

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account