Business Data Analyst

CSM Technologies; New Jersey; On-site; USD 100,000 - 150,000; Full time

Job summary

CSM Technologies is seeking a Senior Business Data Analyst to lead enterprise data analysis initiatives within the Property & Casualty Insurance domain. The role requires coordination between Data Engineers, Actuaries, and business stakeholders to ensure accurate, consistent data aligned with business goals.

The ideal candidate will have 5+ years in data analysis, strong SQL/Snowflake skills, and experience documenting STTM and BRD artifacts, with solid ETL/ELT and SDLC knowledge.

Qualifications

• 5+ years of enterprise data analysis experience.
• Expertise in SQL and Snowflake.
• Experience creating STTM and BRD artifacts.
• Strong ETL/ELT and data transformation knowledge.
• Deep understanding of P&C insurance data.
• Excellent communication and stakeholder coordination.
• Familiarity with SDLC and data delivery processes.

Responsibilities

• Lead end-to-end data analysis including profiling, validation, and transformation.
• Develop and maintain STTM, BRD, and data analysis docs.
• Coordinate between data engineers and actuaries for planning and delivery.
• Collaborate on data consolidation and transformation logic using Snowflake.
• Write and optimize complex SQL for analytics and reporting.
• Apply P&C domain knowledge to ensure data aligns with business needs.
• Participate in SDLC activities from requirements to production readiness.

Skills

SQL proficiency

Stakeholder liaison

Data profiling

Data validation

Data transformation

Snowflake expertise

ETL/ELT understanding

P&C insurance domain knowledge

SDLC knowledge

Tools

Snowflake platform

Job description

We are seeking a senior Business Data Analyst with strong experience in enterprise data analysis, transformation, and large-scale data platforms within the Property & Casualty Insurance domain. This role operates as a lead-level liaison between Data Engineers, Actuaries, and Business Stakeholders, supporting data-driven initiatives with a focus on accuracy, consistency, and business alignment.

Key Responsibilities

• Perform end-to-end data analysis, including data profiling, validation, and transformation for enterprise data initiatives.
• Develop and maintain Source-to-Target Mapping (STTM), Business Requirements (BRD), and data analysis documentation.
• Act as a primary coordinator between data engineers and actuaries, supporting planning, prioritization, and delivery.
• Collaborate with data engineers to implement and validate data consolidation and transformation logic, primarily on Snowflake.
• Write and optimize complex SQL queries to support analytics and reporting on large datasets.
• Apply P&C insurance domain knowledge (policy and claims lifecycle) to ensure data aligns with business and actuarial needs.
• Participate in SDLC activities, including requirements gathering, design reviews, testing support, and production readiness.

Required Skills & Experience

• 5+ years of experience in business/data analysis within enterprise data environments.
• Strong proficiency in SQL and experience with Snowflake (required).
• Proven experience creating STTM, BRD, and data analysis documentation.
• Solid understanding of ETL/ELT processes and data transformation concepts.
• In-depth knowledge of Property & Casualty Insurance, including policy and claims data.
• Strong communication and coordination skills, with experience acting as a liaison between technical and business teams.
• Good understanding of SDLC and enterprise data delivery processes.