About the company

Octave’s mission is to create a new standard for mental healthcare delivery, one that is accessible to more people and sustainable for providers. We are broadening access to high quality mental health services that are measurement-based and insurance funded. Now more than ever, we are looking to serve communities dealing with the rising public health challenge of addressing mental health needs. Octave is VC-backed and was founded in 2018 with footprints in New York and California, as well as virtually nationwide. We are expanding our beautiful practices throughout New York and California, offering telehealth and also clinic-based services. Learn more at  www.findoctave.com

About the Role

We are seeking a 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 and reports to an Engineering Manager.

Essential Responsibilities:

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

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
• 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
• B.S. / M.S. in Computer Science, Electrical Engineering or related experience
• Must be legally authorized to work in the United States without the need for employer sponsorship now or anytime in the future

Bonus

• Experience with the Google Cloud and/or BigQuery
• Experience with practical applications of data science and AI/ML concepts and technologies
• Experience with business analytics tools such as Tableau and Looker
• Experience with basic infra as code technologies for managing infrastructure