Skip to content

Analytics Engineer II

Oscar Health LogoOscar Health
View Organization

Salary

$119,200 - $156,450 per year

Location

Remote. You must reside in one of the following states: Alabama, Arizona, California, Colorado, Connecticut, Florida, Georgia, Illinois, Indiana, Iowa, Kansas, Kentucky, Maine, Maryland, Massachusetts, Michigan, Minnesota, Missouri, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, Ohio, Oregon, Pennsylvania, Rhode Island, South Carolina, Tennessee, Texas, Utah, Vermont, Virginia, Washington, or Washington, D.C.

The Analytics Engineer II plays a leading role in the design, implementation, optimization, and maintenance of Oscar’s analytics platform, including data transformation infrastructure and downstream semantic layer systems. You will help Oscar transition their CDS (Certified Datasets) from an in-house data transformation tool to DBT. You will build and architect our DBT implementation, with an eye towards improving our development workflows. You will also help manage self-service BI in Looker, onboarding new dimensional data models with performance and usability in mind. You will collaborate with business users and subject matter experts to explore data, define requirements, and deliver data products to our end-users. You’ll help improve and enhance our analytics stack on an ongoing basis as we look to expand our capabilities in data services and governance.

You will report to the Associate Director, Data.

Responsibilities

  • Develop an understanding and expertise of Oscar’s analytics technologies and tools, contributing to the continuous improvement of Oscar’s analytics ecosystem.
  • Play a role in the design, build, and implementation of the next generation of CDS, utilizing technologies such as DBT, Github actions, and others as necessary with an eye towards improving data governance and developer productivity.
  • Optimize our existing data models so they are more reliable, efficient, fast, and scalable using dimensional modeling principles.
  • Contribute to the administration of the analytics platform, including but not limited to active participation in support channels and actioning on access requests.
  • Lead cross-functional short-to-mid term projects focused on optimizing and scaling the analytics tech stack, ensuring its efficiency and effectiveness in meeting business needs. Participate in “build or buy” analyses of additional services required.
  • Contribute to the development and documentation of best practices for engineering and analytics development, ensuring adherence to industry standards and internal guidelines.
  • Work with other Analytics Engineers, Subject Matter Experts and Business stakeholders to explore data and define business requirements for one or more data transformation and/or downstream semantic layer systems.
  • Contribute towards development of our BI tools, Looker and Looker Studio Pro, improving performance, adding new content, and maintaining our process automation scripts.
  • Train and mentor data scientists and data engineers in analytics engineering best practices.

Qualifications

  • 3+ years of experience in Analytics Engineering, Data Science, or a related field.
  • 3+ years of experience working with a variety of database languages, including SQL, DDL and DML with demonstrated ability to efficiently transform data and databases.
  • 2+ years of experience developing in a semantic modeling language (e.g. LookML).
  • 2+ years of experience developing within a modern data transformation tool like DBT.
  • 2+ years of experience with cloud database tools (GCP, AWS, Azure).
  • 1+ years of experience working with and presenting to non-technical stakeholders.

Bonus Points

  • Experience developing within a Business Intelligence Platform like Looker, Tableau or Power BI.
  • Experience integrating DBT and Looker (or equivalent ETL-to-BI integration).
  • Experience working with healthcare data, analytics and reporting.
  • Experience with GCP.
  • A background in healthcare and/or insurance.
  • Strong communication skills, verbal and written, as demonstrated by experience on at least 1 project or initiative requiring communication between technical and non-technical users.

‌