Senior Analytics Engineer: AI-Driven Dimensional Modeling

name; New York (NY); Hybrid; USD 149,000 - 196,000; Full time

Benefits offered by this job

Unlimited vacation

Equity grants

Annual performance bonuses

Hybrid work schedule

Job summary

Oscar Health in New York City is seeking a Senior Analytics Engineer to design, build, and maintain conformed dimensional models within our unified data foundation. This role emphasizes cross-domain data modeling, quality, and governance, with mentorship of teammates and proactive collaboration with stakeholders.

You will work in a hybrid NYC office (3 days/week in person) and leverage dbt and AI to accelerate workflows, delivering scalable analytical assets and reliable insights for the

Qualifications

• 4+ years of experience in Analytics Engineering, Data Engineering, or a related field.
• 3+ years of experience working with SQL to transform and model data at scale.
• 2+ years of experience building dimensional models (star schemas, slowly changing dimensions, surrogate key management).
• 2+ years of experience developing within a modern data transformation tool such as dbt.

Responsibilities

• Partner with domain experts and stakeholders to understand business logic and translate it into dimensional models within Oscar's unified data foundation.
• Design, build, and maintain conformed dimensional models in dbt spanning multiple business domains, including source-to-target mapping, historical change tracking, and shared dimension governance.
• Resolve cross-source inconsistencies when integrating independently-built upstream systems, ensuring data from different origins conforms to shared definitions and enables analysts to answer questions that span domains.
• Contribute to the design and implementation of semantic layer artifacts that support enterprise business intelligence needs.
• Lead cross-functional mid-to-long term projects focused on optimizing, scaling, and improving analytics data transformation solutions, with a focus on efficiency, cost-effectiveness, and stability.
• Ensure data models and transformations align with established Data Governance principles.
• Expand the coverage of data quality checks and enhance monitoring and alerting pipelines to ensure the reliability and accuracy of analytics outputs.
• Develop deep expertise in Oscar's analytics technologies, tools, and business domains, contributing to the continuous improvement of Oscar's analytics ecosystem.
• Provide training and mentorship to more junior team members, cultivate a culture of excellence in analytics engineering, and foster continuous skill development.
• Use AI to accelerate development, improve quality, and solve problems.

Skills

Analytics engineering

SQL

Dimensional modeling

AI tooling

Stakeholder collaboration

Cloud platforms

Tools

dbt

Job description

Oscar Health in New York City is seeking a Senior Analytics Engineer to design, build, and maintain conformed dimensional models within our unified data foundation. This role emphasizes cross-domain data modeling, quality, and governance, with mentorship of teammates and proactive collaboration with stakeholders.

You will work in a hybrid NYC office (3 days/week in person) and leverage dbt and AI to accelerate workflows, delivering scalable analytical assets and reliable insights for the