Analytics Engineer, Oscar Health

• 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

Desirable

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