Lead Data Analyst

Overture Partners; Edison (NJ); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical insurance (choice of 3 plans)

401(k) starting on day one

Voluntary life and disability insurance

Sick time (if required by law)

Job summary

Overture Partners is seeking a Senior Data Analyst in Edison, NJ, to lead data warehouse initiatives in a complex data environment. The ideal candidate will have over 10 years of experience in data analysis and warehousing, strong SQL skills, and in-depth knowledge of the Property & Casualty insurance sector. This role entails driving data solutions and collaborating with stakeholders to ensure data accuracy and reliability. Benefits include medical plans, 401(k), and more for eligible employees.

Qualifications

• 10+ years of experience in data analysis, data warehousing, or related technical roles.
• Strong expertise in SQL and relational databases.
• Solid understanding of cloud-based data environments, particularly AWS.
• Deep knowledge of Property & Casualty (P&C) insurance domains.

Responsibilities

• Lead full lifecycle delivery of data warehouse initiatives.
• Analyze and refine business requirements.
• Design and maintain robust data models.
• Mentor junior team members.

Skills

Data analysis

SQL

Data warehousing

ETL processes

Cloud-based environments (AWS)

Property & Casualty insurance knowledge

Project management

Tools

Informatica

DB2

SQL Server

Oracle

Snowflake

Job description

Job Overview

An organization is seeking a Senior Data Analyst to lead end-to-end data warehouse initiatives within a complex, enterprise data environment. This role is critical in driving data solutions across core business domains, ensuring high-quality data delivery from initial analysis through post-implementation support. Candidates who demonstrate deep expertise in data warehousing, strong domain knowledge, and the ability to independently lead large-scale projects will be prioritized.

Must Haves

• 10+ years of experience in data analysis, data warehousing, or related technical roles
• Strong expertise in SQL and relational databases (e.g., DB2, SQL Server, Oracle, Snowflake)
• Proven experience working within structured SDLC frameworks, including estimation and planning
• Advanced data modeling and data mapping experience
• Hands‑on experience with ETL processes and tools such as Informatica or similar platforms
• Solid understanding of cloud‑based data environments, particularly AWS
• Deep knowledge of Property & Casualty (P&C) insurance domains, including policy and claims lifecycle
• Strong testing experience across unit, integration, and user acceptance phases
• Demonstrated ability to manage projects independently from analysis through delivery

What the Client Needs You to Do

You will serve as a senior technical leader responsible for delivering high‑impact data warehouse solutions that support critical business functions. This includes translating business needs into technical specifications, guiding development efforts, and ensuring data accuracy and reliability across systems. You will collaborate closely with both technical teams and business stakeholders while also mentoring peers and driving continuous improvement across data processes.

Key Responsibilities

• Lead full lifecycle delivery of data warehouse initiatives, from requirements analysis through production support
• Analyze and refine business requirements to ensure clear, actionable technical direction
• Develop detailed system and technical specification documents, including data transformation logic
• Design and maintain robust data models aligned with enterprise data architecture standards
• Coordinate with development teams to ensure proper implementation of data solutions
• Execute and support comprehensive testing efforts, including unit, integration, and performance testing
• Monitor production data environments, troubleshoot issues, and ensure data integrity
• Provide ongoing support to downstream applications and business users relying on data warehouse outputs
• Optimize system performance through tuning and process improvements
• Build strong partnerships with stakeholders across business and IT teams
• Mentor junior team members and provide guidance on best practices in data analysis and warehousing
• Proactively identify gaps, inefficiencies, and opportunities for enhancement within data systems
• Manage multiple priorities effectively while maintaining high-quality deliverables

W2 employees of Overture Partners who work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), 401(k) starting on day one, a variety of voluntary benefits including life and disability insurance, and sick time if required by law in the worked‑in state/locality.