Senior Analytics Engineer

About Lyra

Lyra Health is the leading provider of mental health solutions for employers supporting more than 20 million people globally. The company has delivered 13 million sessions of mental health care, published more than 20 peer‑reviewed studies, and delivered unmatched outcomes in terms of access, clinical effectiveness, and cost efficiency. Extensive peer‑reviewed research confirms Lyra’s transformative care model helps people recover twice as fast and results in a 26% annual reduction in overall health‑care claims costs.

Lyra is transforming access to life‑changing mental health care through Lyra Empower, the only fully integrated, AI‑powered platform combining the highest‑quality care and technology solutions.

The international data team is undergoing a complete transformation of their data architecture, migrating from a legacy SQL server, Azure Data Factory, SSAS and Power BI stack to Snowflake, dbt, Airflow, Tableau and Sigma. This opportunity will give you a chance to share your knowledge about best practices with Snowflake and dbt with the team, as well as to build data infrastructure from scratch.

• 7+ years experience in data engineering
• Experience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and Airflow
• Experience in building dbt models to transform data using Medallion architecture
• Experience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemas
• Experience in maintaining data warehouses on SQL Server
• Experience in designing and building at least one data warehouse on Snowflake from scratch
• Be the Snowflake and dbt expert on the team, providing guidance on best practices
• Make key design decisions for a brand new multi‑dimensional data model
• Make key architectural decisions for building a brand new data warehouse on Snowflake
• Build and maintain pipelines to ingest data from Salesforce and various other data sources
• Build and maintain dbt models to transform data using Medallion architecture for use by business intelligence tools
• Work closely with our Business Intelligence team – monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholders
• The successful candidate will also be given the opportunity to develop mentoring skills as we look to expand the team’s skillset to match those of our counterpart US team. As we work collaboratively with team members in different time zones, it is important that the candidate has strong interpersonal skills

• 7+ years experience in data engineering, ideally including cloud migration to Snowflake
• Development of pipelines to ingest and transform data from scratch using REST APIs, AWS S3 and Airflow
• Experience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemas
• Experience in designing and building at least one data warehouse on Snowflake from scratch
• Strong SQL skills (CTEs and window functions)
• Proficiency in Python for building pipelines with Snowpark
• Experience designing multi‑dimensional data models with star schema and Type 2 SCDs
• Experience with dbt for building robust ELT processes

We are an Equal Opportunity Employer. We do not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, age, disability, genetic information or any other category protected by law.

By applying for this position, you acknowledge that your personal information will be processed as per the Lyra Health Workforce Privacy Notice. Through this application, to the extent permitted by law, we will collect personal information from you including, but not limited to, your name, email address, gender identity, employment information, and phone number for the purposes of recruiting and assessing suitability, aptitude, skills, qualifications, and interests for employment with Lyra.

We may also collect information about your race, ethnicity, and sexual orientation, which is considered sensitive personal information under the California Privacy Rights Act (CPRA) and special category…