Remote Analytics Engineer I

Summary

Join Oscar's Data team as an Analytics Engineer I and play a vital role in our data pipeline, bridging raw data systems and end-users of financial data. You will partner with the Finance team, creating and maintaining Certified Datasets (CDS) for accounting and actuarial processes. This role involves collaborating with stakeholders, optimizing code, and implementing quality assurance checks. The position offers a blended work culture with remote options and a competitive salary and benefits package. You will report to an Associate Director, Data Science and must reside in one of the specified states. The base pay is $103,200 - $135,450 per year, plus benefits, unlimited vacation, equity grants, and performance bonuses.

Requirements

• 1+ years of experience in Analytics Engineering, Data Science, or a related field
• 1+ years of experience working with SQL
• 1+ years of experience developing in a semantic modeling language (e.g. LookML)
• 1+ years of experience developing within a modern data transformation tool like DBT
• 1+ years of experience with cloud database tools (GCP, AWS, Azure)

Responsibilities

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

Preferred Qualifications

• Experience working with healthcare data, analytics and reporting, particularly with claims payments data
• Experience with GCP and/or DBT
• 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

• Employee benefits
• Participation in Oscar's unlimited vacation program
• Company equity grants
• Annual performance bonuses
• 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