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

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

About the Role

As an Analytics Engineer I, you will occupy a vital position in Oscars data pipeline between raw data producing systems & end users of financial data.  You will maintain a crucial partnership with Oscars Finance team, a critical data user, servicing it with comprehensive & reliable Certified Datasets (CDS) curated to enable accounting & actuarial processes & facilitate efficient answering of business questions.  You will guide Engineering to help ensure that the financial data model is correctly implemented in production systems.  You will problem solve & collaborate with multiple stakeholders, executing on tasks that range from requirements gathering to detailed optimization of code to brainstorming & implementing quality assurance checks on financial data.  

You will report to an Associate Director, Data Science. 

Work Location:

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

This is a hybrid role in our New York City office. You will work part of the time in the office & part of the time remote / work-from-home. #LI-Hybrid

Pay Transparency: 

The base pay for this role is $119,200 - $156,450. You are also eligible for employee benefits, participation in Oscar's unlimited vacation program, company equity grants & annual performance bonuses.

Responsibilities

• Become a financial data subject matter expert & use that knowledge to understand & organize raw data sources & structure them into CDS which stakeholders can readily rely on & self service with. 
• Partner with the finance team to expand the breadth & depth of finance CDS to support its processes & to more seamlessly integrate CDS into Finance's systems. 
• Facilitate automation of key Finance team processes by programming reports based on complex queries. 
• Partner with Engineering to validate updates to raw financial data structure within an evolving production system & update CDS code accordingly while preventing service interruption for stakeholders. 
• Promote data fidelity in upstream data producing systems & expand quality checks within finance CDS. 
• Conduct root cause analyses of financial data defects & escalate to upstream data owners or cure in finance CDS. 
• Compliance with all applicable laws & regulations. 
• Other duties as assigned. 

Qualifications

• 2+ years of experience in Analytics Engineering, Data Analytics, Data Science, or a related field.
• 1+ years of experience developing with modern data transformation & workflow tools such as DBT & Airflow.
• 1+ years of experience with cloud database tools (GCP, AWS, Azure).
• Knowledge of a variety of database languages, including SQL, DDL & DML with demonstrated ability to efficiently transform data & databases.
• Strong communication skills, verbal & written, as demonstrated by experience on at least 1 project requiring translation of business requirements from non technical stakeholders into technical specifications.

Bonus Points

• Experience working with healthcare data, analytics & reporting, particularly with claims payments data.
• Experience with Google Cloud Platform and/or DBT.
• A background in healthcare and/or insurance.