Lead Analytics Architect: Enterprise Dimensional Modeling

name; New York (NY); Hybrid; USD 163,944 - 215,176; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) plan participation

Unlimited vacation program

Job summary

Oscar in New York City is seeking a Lead Analytics Engineer to drive the vision for its unified analytics data foundation. This role requires strong experience in dimensional modeling and SQL, and involves building an enterprise-wide semantic layer for analytics.

As part of the Data Team, you will collaborate cross-functionally to ensure Oscar's analytics deliver accurate and high-quality insights. Hybrid work schedule with three in-office days per week, plus competitive benefits.

Qualifications

• 6+ years of experience in Analytics Engineering, Data Engineering, or a related field.
• 4+ years of experience working with SQL to transform and model data at scale.
• Demonstrated experience in establishing a dimensional model and a semantic layer at enterprise scale.

Responsibilities

• Partner cross‑functionally to capture business logic.
• Lead the design and implementation of an enterprise‑wide semantic layer.
• Champion Oscar's culture and values, mentor junior team members.

Skills

Dimensional modeling

SQL

Data transformation tools (dbt)

Business intelligence platforms (Tableau, Looker, Power BI)

People management

Job description

Oscar in New York City is seeking a Lead Analytics Engineer to drive the vision for its unified analytics data foundation. This role requires strong experience in dimensional modeling and SQL, and involves building an enterprise-wide semantic layer for analytics.

As part of the Data Team, you will collaborate cross-functionally to ensure Oscar's analytics deliver accurate and high-quality insights. Hybrid work schedule with three in-office days per week, plus competitive benefits.