Senior Business Data Analyst

Local To New Jersey

Job Summary:

We are seeking a
Senior 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.

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:

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