Sr. Data Analyst

Accord Technologies Inc; Piscataway Township (NJ); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Accord Technologies Inc in Piscataway, NJ is seeking a Senior Data Analyst to lead data analysis, requirements gathering, and STTM documentation across insurance data domains. You will work with actuarial, underwriting, and broker data teams to deliver accurate, governance-driven data solutions.

Strong SQL, Databricks and Azure experience are highly desirable, with 10+ years in data analysis. Hybrid work arrangement in the New Jersey area is available, supporting enterprise data initiatives.

Qualifications

• Bachelor's degree in a related field.
• 10+ years as Data Analyst or related role.
• Strong SQL and data analysis skills.
• Experience with insurance/actuarial data is a plus.
• Databricks and Azure experience preferred.
• Excellent written and verbal communication.

Responsibilities

• Collaborate with stakeholders to gather, analyze, and document requirements.
• Perform source system analysis to understand data structures and quality.
• Develop STTM documents for migration and integration projects.
• Analyze datasets using advanced SQL for trends and insights.
• Document transformation logic and data validation requirements.
• Work with actuarial, underwriting, and broker data teams on models and reporting.
• Support data reconciliation, validation, and QA activities.
• Participate in data governance, metadata management, and data lineage efforts.
• Collaborate with Data Engineering on Azure/Databricks platforms.
• Create functional specs and assist UAT with data accuracy validation.
• Lead stakeholder meetings and communicate project status, risks, and recommendations.

Skills

SQL

Data Analysis

STTM

BRD

Data Reconciliation

Data Validation

Databricks

Azure

Data Governance

Reporting & Analytics

Excel

Education

Bachelor's degree

Tools

Databricks

Azure

Job description

Senior Data Analyst
Location: Piscataway, NJ (Hybrid/Onsite)
Experience: 10 12+ Years

Job Summary We are seeking an experienced Senior Data Analyst with deep expertise in data analysis, business analysis, and insurance/actuarial domains to support enterprise data initiatives. The ideal candidate will have extensive experience gathering business requirements, performing source data analysis, creating source-to-target mappings, documenting business rules, and collaborating with cross-functional stakeholders to deliver high-quality data solutions.

This role requires strong SQL skills, excellent analytical capabilities, and hands-on experience working with actuarial, underwriting, or broker data within the insurance industry. Familiarity with Databricks, Azure, and modern data governance practices is highly desirable.

Key Responsibilities

• Collaborate with business stakeholders to gather, analyze, and document business and data requirements.
• Perform detailed source system analysis to understand data structures, relationships, and quality.
• Develop comprehensive Source-to-Target Mapping (STTM) documents for data migration and integration projects.
• Analyze complex datasets using advanced SQL to identify trends, anomalies, and business insights.
• Document business rules, transformation logic, and data validation requirements.
• Work closely with actuarial, underwriting, and business teams to understand insurance data models and reporting needs.
• Support data reconciliation, data validation, and quality assurance activities.
• Participate in data governance initiatives including metadata management, data lineage, and data quality improvements.
• Collaborate with Data Engineering teams supporting Azure and Databricks-based data platforms.
• Create functional specifications and support UAT by validating business requirements and data accuracy.
• Facilitate stakeholder meetings and effectively communicate project status, risks, and recommendations.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Mathematics, Statistics, Actuarial Science, Business, or a related field.
• 10 12+ years of experience as a Data Analyst or Business/Data Analyst.
• Strong experience with:
• Requirements gathering and business analysis
• Source data analysis
• Source-to-Target Mapping (STTM)
• Business rule documentation
• Data reconciliation and validation
• Stakeholder management
• Advanced SQL skills for complex querying, analysis, and data validation.
• Hands-on experience in the Insurance industry, preferably within:
• Actuarial
• Underwriting
• Broker data
• Strong analytical and problem-solving abilities.
• Excellent communication and documentation skills.

Preferred Qualifications

• Hands-on actuarial experience.
• Strong understanding of Property & Casualty and/or Life Insurance data.
• Experience working with underwriting and broker datasets.
• Familiarity with Databricks and Microsoft Azure data platforms.
• Exposure to data governance frameworks, metadata management, and data lineage.
• Experience supporting enterprise reporting and analytics initiatives.
• Knowledge of ETL processes and data integration concepts.
• Experience working in Agile/Scrum environments.

Technical Skills

• SQL (Advanced)
• Data Analysis
• Source-to-Target Mapping (STTM)
• Business Requirements Documentation
• Data Reconciliation
• Data Validation
• Databricks (Preferred)
• Microsoft Azure (Preferred)
• Data Governance
• Reporting & Analytics
• Excel (Advanced)

Domain Expertise

• Insurance
• Actuarial
• Underwriting
• Broker Data
• Risk & Financial Data