Analytics Engineer II

Summary

Join Oscar's Data team as an Analytics Engineer II and play a leading role in designing, implementing, and maintaining our analytics platform. You will be instrumental in transitioning our Certified Datasets (CDS) from an in-house tool to DBT, building and architecting our DBT implementation, and managing self-service BI in Looker. Collaborate with business users to define requirements and deliver data products. This role involves optimizing data models, contributing to platform administration, leading projects, and developing best practices. The position offers a blended work culture with remote options and competitive compensation, including benefits and bonuses. You will report to the Associate Director, Data.

Requirements

• 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

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

Preferred Qualifications

• 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

Benefits

• Medical, dental, and vision benefits
• 11 paid holidays
• Paid sick time
• Paid parental leave
• 401(k) plan participation
• Life and disability insurance
• Paid wellness time and reimbursements
• Participation in Oscar's unlimited vacation program
• Company equity grants
• Annual performance bonuses