Analytics Engineer II

Responsibilities

• Partner with the Finance team to determine the requirements for the structure of data and functionality in the Financial Data Hub and the flow of data between the Hub and Finance's software.  Design and build the Hub and its connections based on those requirements.
• Become a financial data subject matter expert and use that knowledge both to inform the design and build of the Financial Data Hub and to contribute to expanding the breadth, depth, and accuracy of Finance CDS, the principal direct source of financial data for the Hub and for business users across Oscar.
• Promote data fidelity in upstream data producing systems and expand quality checks within Finance CDS and the Financial Data Hub.
• Partner with Engineering to validate updates to raw financial data structure within an evolving production system and update Finance CDS and Financial Data Hub code accordingly while preventing service interruption for stakeholders.
• Identify opportunities and implement solutions to enhance the efficiency of existing financial data transformations, with a focus on speed, cost-effectiveness, and stability.
• 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 with cloud database tools (GCP, AWS, Azure)
• 2+ years of experience developing within a modern data transformation tool like DBT.
• 1+ years of experience working with and presenting to non-technical stakeholders.