Role introduction:

As a Data Analytics Engineer at COMPASS Pathways, you will be responsible for maintaining and developing the data analytics platform and working cross-functionally with multiple departments to drive usage, dashboard creation and company-wide adoption. Our analytics platform serves various stakeholders, including clinical site coordinators, therapists, auditors, business partners as well as internal compass teams.

This role is perfect for someone who is proficient in gathering requirements, working with product and engineering teams, SQL as well as being eager to learn how each department in a biotech company conducts their business processes. We’re looking for someone enthusiastic about data and the insights and stories provided. As a Data Analytics Engineer, you will get the chance to work with many varied teams at COMPASS, making a direct impact on how we achieve our mission to transform mental health care.

Location: The role can be based in the United Kingdom or the United States (East Coast).

Reports to: Vice President, Engineering.

Role and responsibilities
(include but are not limited to):

• Collaborate with stakeholders to understand every aspect of their processes, discern the data they possess or need, and propose comprehensive data analytics solutions that meet their requirements
• Liaise with engineers to ensure that the necessary data for analysis is efficiently delivered to the data warehouse
• Cleanse and transform ingested source data using DBT (data build tool), while also establishing clear data quality acceptance metrics
• Construct models, marts, aggregations, and cubes that will form the foundation of reporting dashboards
• Visualize data by leveraging our BI tool, Metabase
• Oversee dashboard management, regularly conduct audits on existing dashboards and assess their usage
• Sustain our DBT model repository, author and maintain models, macros, tests, documentation, and snapshots
• Ensure that our data privacy and access controls are in strict compliance with company policies.
• Communicate requests to Product Managers to align on priority builds

Candidate Profile:

• Prior experience in a Data Analyst role or similar capacity
• Ability to understand the needs of non-technical stakeholders and transform these needs to measurable analytics and reporting
• Exceptional communication skills with team members from varied background and technical abilities
• Background in the pharmaceutical, clinical trial and/or health tech industry is highly beneficial
• Capable of explaining complex data insights in a lucid and concise manner to senior level stakeholders
• Self-motivated and autonomous, with the aptitude to flourish in a dynamic environment, managing multiple projects concurrently
• Strong design skills when presenting data to technical and non-technical audiences – data should be clear and easy to explain/understand
• Proven experience in data pre-processing, cleaning, and analysis
• Mastery of SQL, preferably PostgreSQL
• Proficiency with Git command-line tools for version control, and the capacity to operate comfortably within Unix command-line interfaces
• Experience with data modelling, testing, and transformations using DBT
• Basic familiarity with the Python programming language
• Knowledge of the pull request review process in GitHub
• Prior exposure to Meltano and Airbyte for data analysis is a plus
• Experience with data visualization tools, particularly Tableau, Looker, and Metabase
• Aligned with our company mission and values: Compassionate, Bold, Rigorous, and Inclusive