Analytics Engineer, Oscar Health

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

Desirable

• As an Analytics Engineer I, you will occupy a vital position in Oscar’s data pipeline between raw data producing systems and end users of financial data. You will maintain a crucial partnership with Oscar’s Finance team, a critical data user, servicing it with comprehensive and reliable Certified Datasets (CDS) curated to enable accounting and actuarial processes and 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 and collaborate with multiple stakeholders, executing on tasks that range from requirements gathering to detailed optimization of code to brainstorming and implementing quality assurance checks on financial data
• You will report to an Associate Director, Data Science
• 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