Senior Analytics Engineer

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

About the role:

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

You will report into the Associate Director, Data Science.

Work Location:

This position is based in our New York City office, requiring a hybrid work schedule with 3 days of in-office work per week. Thursdays are a required in-office day for team meetings and events, while your other two office days are flexible to suit your schedule. #LI-Hybrid

Pay Transparency:

The base pay for this role is: $149,040 - $195,615 per year. You are also eligible for employee benefits, participation in Oscar's unlimited vacation program, company equity grants, and annual performance bonuses.

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.

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.

Bonus points:

• 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.

This is an authentic Oscar Health job opportunity.

At Oscar, being an Equal Opportunity Employer means more than upholding discrimination-free hiring practices. It means that we cultivate an environment where people can be their most authentic selves and find both belonging and support. We're on a mission to change health care -- an experience made whole by our unique backgrounds and perspectives.

Pay Transparency:

Final offer amounts, within the base pay set forth above, are determined by factors including your relevant skills, education, and experience. Full-time employees are eligible for benefits including: medical, dental, and vision benefits, 11 paid holidays, paid sick time, paid parental leave, 401(k) plan participation, life and disability insurance, and paid wellness time and reimbursements.

Artificial Intelligence (AI):

Our AI Guidelines outline the acceptable use of artificial intelligence for candidates and detail how we use AI to support our recruiting efforts.

Reasonable Accommodation:

Oscar applicants are considered solely based on their qualifications, without regard to applicant’s disability or need for accommodation. Any Oscar applicant who requires reasonable accommodations during the application process should contact the Oscar Benefits Team ([e-mail]) to make the need for an accommodation known.

California Residents:

For information about our collection, use, and disclosure of applicants’ personal information as well as applicants’ rights over their personal information, please see our Privacy Policy.