Senior Analytics Engineer, Oscar Health

• 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

Desirable

• The Lead Analytics Engineer drives the definition of the vision for Oscar's unified analytics data foundation, leading this effort from initial buildout through ongoing operation and continuous expansion of domain coverage and platform capabilities.
• Oscar is consolidating fragmented legacy data transformation systems that support analytics across the organization into a single dimensionally modeled platform in dbt, and building out an enterprise-wide semantic layer to serve all business analytics use cases.
• This role requires someone who has played a central role in establishing both a dimensional model and a semantic layer at enterprise scale, and who brings the judgment and experience to ensure Oscar gets both right.
• The Lead Analytics Engineer is accountable for the design and coherence of the overall dimensional model and semantic layer while also contributing as a hands-on builder. Data consistency, shared definitions, and singular sourcing are the foundations of trustworthy analytics, and this role exists to deliver on that principle
• You will report into the Associate Director, Data Science
• Partner cross-functionally with domain experts and stakeholders to capture business logic and translate it into the unified dimensional model, whether consolidating from existing systems or modeling new domains
• Define the design standards, patterns, and structure of Oscar's unified dimensional model in dbt, ensuring coherence and extensibility as domain coverage expands across the organization
• Lead the design and implementation of an enterprise-wide semantic layer that serves all business analytics use cases with consistent, governed definitions
• Serve as the subject matter expert on dimensional modeling and semantic layer design, guiding the team on best practices and ensuring implementation quality across all business domains
• Lead cross-functional projects to consolidate, scale, and continuously improve Oscar's analytics data transformation solutions, ensuring they meet business needs efficiently and effectively
• Ensure the analytics platform and related systems are administered according to industry standards, internal controls are followed, and processes are aligned with established Data Governance principles
• Ensure data models and semantic layer artifacts are documented and structured to support enterprise data discoverability
• Design and continuously improve data transformations and semantic layer systems with a focus on performance, cost-effectiveness, and stability
• Expand the coverage of data quality checks and enhance monitoring and alerting pipelines to ensure the reliability and accuracy of analytics outputs
• Champion Oscar's culture and values, mentor 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; enable team members to do the same
• Compliance with all applicable laws and regulations
• Other duties as assigned