Senior Data Engineer (Remote)

Octave is a national behavioral health practice creating a new standard for care delivery that’s both high-quality and accessible to more people. With in-person and virtual clinics in California and New York, the company offers personalized care plans that can include individual therapy, couples therapy, and groups, while pioneering relationships with payers to make care more affordable through insurance. Grounded in science, Octave enables clients to experience profound change that is as measurable as it is meaningful. Learn more at www.findoctave.com

About the Role

We are seeking a mid-senior level Data Engineer to write high-quality production code and perform as a key contributor to our central Data Warehouse and data processing systems to support the Business Intelligence team and assist business operations .Octave is a full-stack behavioral health services company: we employ therapists, contract with insurance providers for reimbursing care, and run our own tech stack to support across the business. We are a technology-enabled service provider working to increase access to mental health care for insured people in the US.The team is distributed across the US and has varied backgrounds, from education to fitness, advertising, travel, and healthcare. The role is virtual, with the opportunity to work in person in San Francisco in the future. This role reports to an Engineering Manager

• Build and maintain data pipelines on AWS using best-in-class technologies (e.g., Python, Spark, Glue, Redshift, Athena, etc.)
• Create analytic & data processing tools and reporting dashboards utilizing data pipelines to provide insights for operational teams
• Build data extraction jobs from a variety of data sources (relational databases, APIs, FTP sites, etc.)
• Jointly architect a high-dimensional data-warehouse using industry standard data warehousing principles
• Grow into a Data Engineering Lead responsible for managing data systems (data warehousing & analytics) and ensuring high quality data for business operations
• Evolve the core data model and schema through business growth
• Maintain high quality data for reporting and analysis through the use of automated testing and data quality validation
• Must be legally authorized to work in the United States without the need for employer sponsorship now or anytime in the future.

Experience, Skills, Knowledge And/or Abilities

• 5+ years of data engineering experience
• Expertise with the Python, PySpark, and the AWS Big Data ecosystem
• Deep knowledge of SQL (preferably PostgreSQL)
• Expertise in building out data pipelines, ETL design (both implementation and maintenance), and data warehousing
• Previous experience working with agile collaborative software development methodology and related tools (preferably Pivotal Tracker and GitHub)
• Excellent written, communication, analytical skills, and attention to detail
• Willingness to learn and improve data engineering skills through collaboration with senior engineers
• Architected star or snowflake schema data warehouses
• Solid Object Oriented software engineering design and implementation skills
• Experience with business analytics tools such as Tableau and Looker is highly desirable
• B.S. / M.S. in Computer Science, Electrical Engineering or related experience
• Must be eligible to work in the United States without sponsorship now or anytime in the future