Overview
About Lyra
Full job description
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 healthcare 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.
Role Overview The international data team is undergoing a complete transformation of their data architecture, migration from a legacy SQL server, Azure Data Factory, SSAS and Power BI stack to Snowflake, dbt, Airflow, Tableau and Sigma. This opportunity will give the successful candidate a chance to share knowledge about best practices with Snowflake and dbt with the team, as well as a chance to build data infrastructure from scratch.
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
Work collaboratively with team members in different timezones
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.
3+ 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 maintaining dimensional data models with Type 2 SCDs and star schemas
Experience in maintaining data warehouses on SQL Server
Experience working with Snowflake, dbt and Tableau is essential
Tips for this job
Practical Job and Scholarship guidance. These tips do not replace official rules or create new eligibility requirements.
- Tailor the CV and application to the responsibilities and required skills stated on the official employer page.
- Use concrete evidence of relevant work, projects and measurable results rather than generic claims.
- Confirm location, work authorization, remote restrictions and sponsorship terms before applying.
- Apply through the original employer or official recruitment destination shown on this page.
Verification notes
laptop-ats-crawler v2
Job and Scholarship is the discovery and verification layer. Confirm eligibility, dates, salary/funding and application instructions on the original source before submitting anything.
Lyrahealth (lever) ↗Browse current Job and Scholarship listings from Lyrahealth (lever) →