Analytics Engineer II

Hi, we're Oscar. We're hiring an Analytics Engineer II to join our Data team.

Oscar is the first health insurance company built around a full stack technology platform and a focus on serving our members. We started Oscar in 2012 to create the kind of health insurance company we would want for ourselves—one that behaves like a doctor in the family.

About the role

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.

Work Location:

Oscar is a blended work culture where everyone, regardless of work type or location, feels connected to their teammates, our culture and our mission.

If you live within commutable distance to our New York City office (in Hudson Square), our Tempe office (off the 101 at University Dr), or our Los Angeles office (in Marina Del Rey), you will be expected to come into the office at least two days each week. Otherwise, this is a remote / work-from-home role.

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. Note, this list of states is subject to change. #LI-Remote

Pay Transparency:

The base pay for this role in the states of California, Connecticut, New Jersey, New York, and Washington is: $119,200 - $156,450 per year. You are also eligible for employee benefits, participation in Oscar's unlimited vacation program, company equity grants, and annual performance bonuses.

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.
• Experience with Python.
• 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.