Senior Analytics Engineer

Oscar Health•New York, NY

34d•$149,040 - $195,615•Hybrid

About The Position

The Senior Analytics Engineer designs, builds, and maintains conformed dimensional models that convert raw operational data from multiple independent source systems into reliable, well-structured analytical assets spanning multiple business domains. The Senior Analytics Engineer partners with domain experts and stakeholders to capture business logic, resolves cross-source inconsistencies, and translates requirements into Oscar’s unified dimensional model. The Senior Analytics Engineer contributes to shared conventions and standards, mentors more junior team members, uses AI to accelerate development, and operates with high independence on complex modeling work.

Requirements

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).
Experience designing conformed dimensional models spanning 2 or more distinct business domains or processes.
2+ years of experience developing within a modern data transformation tool such as dbt.
2+ years of experience with cloud data platforms (GCP, AWS, Azure).
2+ years of experience partnering with domain experts or stakeholders to translate business requirements into data models.
Experience using AI tools to accelerate development workflows.

Nice To Haves

Experience designing and implementing semantic layers.
Experience integrating data from multiple independent source systems into a unified analytical foundation.
Experience with Google Cloud Platform.
Experience in the healthcare and/or insurance industries.
Strong communication skills, verbal and written, as demonstrated by experience on projects or initiatives requiring communication between technical and non-technical users.

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.
Compliance with all applicable laws and regulations.
Other duties as assigned.