Analytics Engineer

About Ophelia
Ophelia is a mission-driven organization that helps individuals with opioid use disorder (OUD) improve their health and quality of life. We make evidence-based treatment private, accessible, and affordable.
Opioid overdose is the #1 cause of death for Americans under 50, accounting for over 100 deaths each day. There is a proven treatment for OUD, called medication-assisted treatment (MAT), but 80% of people in need are unable to access it. We created Ophelia to make this treatment accessible from the privacy of your home.
We're a diverse and dedicated team - clinicians, scientists, techies, and humanitarians - on a mission to reimagine addiction treatment in America. We've raised $68 million from the world's top healthcare and technology investors (Y Combinator, Tiger Global, Menlo Ventures, General Catalyst), and we're rapidly expanding across the nation, helping thousands of people each day.
Join us, save lives, and help fix healthcare for those who need it most.
As an Analytics Engineer in the newly forming data team at Ophelia, you will be responsible for building and maturing the data warehouse for analytics, reporting, and research. That includes building a robust data pipeline with a scalable data model, pulling in data from the electronic medical records system (EMR), published events, the customer relationship management system (CRM), and many other sources. As one of the initial hires in this team, you will collaborate across departments to understand needs and prioritize work. You will also be expected to deliver stellar data work while employing an agile methodology. 
“Data” today centers around business operations analytics, which requires a sound data engineering base. Over time, this team will likely expand to include key focus areas around clinical analytics, clinical research, and data science capabilities, amongst others.
Our data systems today are nascent yet burgeoning. We’re based in Google Cloud Platform (GCP), using dbt, Airflow, Fivetran, Rudderstack, Snowflake, and Looker. Data is already deeply ingrained in our corporate culture: you’ll witness our team already speaking with data and many leaders querying data directly. But there’s a lot of room for improvement!
In this fully remote role, you will report to our Senior Director of Data and be a peer to other analysts and analytics engineers as the team grows. You will work with the larger Technology Team at the company to foster a culture of data-driven decision-making, ultimately to help us improve patient care. You will be responsible for all analytics data, ensuring high quality availability of that data through the supporting systems. You will own the population of data in all data products as well as the infrastructure, set tests, and alerts to ensure the ongoing quality of data.
Together, we’ll help hard-to-reach people treat their opioid dependence. You may not have experience in this treatment area, but ideally you’ll have knowledge of the healthcare space, including understanding health outcomes and benchmarks, systems, and regulatory compliance (HIPAA).

Responsibilities

• In partnership with the data team, architect and build out data analytics schemas in Snowflake, complete with documentation, data dictionaries, and ERDs as per business requirements across the business
• Assist in the design, implementation, and maintenance of a modern data stack that is reliable, accessible, compliant, and with appropriate security for healthcare data as governed by applicable laws
• Support and maintain established data pipelines in case of issues
• Serve as a subject matter expert of all data assets at Ophelia and be able to answer data questions with confidence and rigor, collaborate with stakeholders across the company with differing levels of data expertise
• Improve access to data insights for everyone at Ophelia by making access faster, easier, and more well understood
• Help support a data-driven culture around decision making across the company through supporting questions and requests from other teams

Skills and Competencies

• 2 to 4 years experience in data architecture and ETL in agile technology teams, experienced in working with Snowflake, AWS, and/or other similar database tools
• Strong experience with data modeling and relevant data engineering tools including Snowflake, dbt, and Airflow, or similar and with relevant business intelligence tools such as Looker, Tableau, PowerBI, etc. 
• Expert at analytical use of SQL, R, Python and analyzing data using common tools like Google Sheets or Microsoft Excel
• Subject matter expert in measurement related to at least two of the following disciplines: finance, digital products, marketing, business operations, or healthcare
• Passionate about our mission to make evidence-based addiction treatment universally accessible, performing data analysis and data exploration
• Experience building automated big data pipelines and performing ad hoc data analyses and data exploration to improve the flow and structure of data
• Previous healthcare experience a plus

Salary range: $120-$145k based on experience
Interested in learning more about Ophelia and this role? Apply below!