Analytics Engineer I

About the role

You will design, build, and maintain dimensional models and data transformations that convert raw operational data into reliable, well-structured analytical assets. You will partner with domain experts and stakeholders to capture business logic and translate it into dimensional models that serve analytics use cases across the organization. You will work within Oscar's unified data foundation in dbt, under the guidance of more senior Analytics Engineers, to ensure data product health through automated tests and monitoring. You will contribute to the semantic layer that powers enterprise business intelligence and help advance the Analytics Engineering roadmap by executing on small-to-medium projects with minimal oversight. This is a hands-on role focused on growing your craft in dimensional modeling, SQL, and analytics engineering within a healthcare environment where your work directly supports members and providers.

Key facts

What you'll do

• Demonstrate a strong working knowledge of Oscar's analytics technologies and tools as well as the breadth of content contained within.
• Contribute to the development and documentation of best practices for engineering and analytics development, consistent with industry standards and internal guidelines.
• Under the guidance of more senior Analytics Engineers, partner with Subject Matter Experts and Business stakeholders to explore data, define business requirements, design and implement solutions for one or more data transformation and/or downstream semantic layer systems.
• Advance the Analytics Engineering roadmap by executing on small-to-medium projects with minimal oversight.
• Contribute to the administration of the analytics platform, including but not limited to active participation in support channels and actioning access requests.
• Leverage a working knowledge of existing data quality checks as well as monitoring and alerting pipelines to perform Root Cause Analyses of data defects as needed and escalate to the appropriate team when warranted.
• Partner with data and product teams to ensure analytics requirements are translated into robust, maintainable models that meet the needs of diverse stakeholders.
• Implement and refine SQL-based transformations to support accurate and timely insights into member behavior, product usage, and operational performance.
• Collaborate closely with cross-functional teams to define metrics, resolve data discrepancies, and improve data literacy across the organization.
• Support the deployment and iteration of analytics features in production environments, ensuring alignment with release management processes and quality standards.
• Participate in code reviews, documentation efforts, and knowledge-sharing sessions to strengthen the overall analytics engineering practice.
• Utilize version control and development workflows to manage changes to analytics code and ensure reproducibility across environments.
• Monitor data pipelines for performance, reliability, and consistency, taking proactive steps to address issues before they impact downstream consumers.
• Explore opportunities to optimize query performance, reduce redundancy, and improve the scalability of analytical datasets.
• Contribute to long-term strategic initiatives that enhance data governance, security, and compliance within the analytics function.

Requirements

• 1+ years of experience in Analytics Engineering, Data Science, or a related field.
• 1+ years of experience working with SQL.
• 1+ years of experience developing in a semantic modeling language (e.g. LookML).
• 1+ years of experience developing within a modern data transformation tool like DBT.
• 1+ years of experience with cloud database tools (GCP, AWS, Azure).
• Demonstrated ability to learn and apply domain-specific knowledge in a healthcare context.
• Willingness to work within Oscar's technology stack and follow established engineering practices and documentation standards.
• Capacity to collaborate effectively with both technical and non-technical stakeholders in a fast-paced environment.
• Commitment to maintaining high standards of data quality, reliability, and transparency in all analytical outputs.
• Willingness to participate in on-call responsibilities and respond to data-related incidents as needed.

Nice to have

• Experience working with healthcare or insurance industry data, analytics, and reporting.
• Experience with Google Cloud Platform and dbt.
• Experience building dimensional models (star schemas, slowly changing dimensions).
• Strong communication skills, as demonstrated by experience partnering with non-technical stakeholders.

Practical notes

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

• Pay Transparency: The base pay for this role is: $106,812 - $140,190.75 per year. You are also eligible for employee benefits, participation in Oscar's unlimited vacation program, company equity grants, and annual performance bonuses.
• At Oscar, being an Equal Opportunity Employer means more than upholding discrimination-free hiring practices; it means actively creating an environment where people can bring their whole selves to work.
• This is an authentic Oscar Health job opportunity. Learn more about how you can safeguard yourself against recruitment fraud here.