Be an Early Applicant
We are revolutionizing how people find and receive mental health care.
The Role
Build and maintain data ingestion pipelines from Salesforce and other sources using REST APIs, AWS S3, and Airflow. Develop dbt models using Medallion architecture, maintain dimensional models with Type 2 SCDs and star schemas, and support Snowflake data warehouses for BI reporting. Collaborate with stakeholders and international team members to enhance data infrastructure, share best practices, and mentor colleagues.
Summary Generated by Built In
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.
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.
Key Responsibilities:
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.
Requirements:
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
"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 data under the UK and EU GDPR. Providing this information is optional and completely voluntary, and if you provide it you consent to Lyra processing it for the purposes as described at the point of collection, for example for diversity and inclusion initiatives. If you are a California resident and would like to limit how we use this information, please use the Limit the Use of My Sensitive Personal Information form. This information will only be retained for as long as needed to fulfill the purposes for which it was collected, as described above. Please note that Lyra does not “sell” or “share” personal information as defined by the CPRA. Outside of the United States, for example in the EU, Switzerland and the UK, you may have the right to request access to, or a copy of, your personal information, including in a portable format; request that we delete your information from our systems; object to or restrict processing of your information; or correct inaccurate or outdated personal information in our systems. These rights may be subject to legal limitations. To exercise your data privacy rights outside of the United States, please contact [email protected]. For more information about how we use and retain your information, please see our Workforce Privacy Notice."
Skills Required
- 3+ years of experience in data engineering
- Experience developing pipelines to ingest and transform data using REST APIs, AWS S3, and Airflow
- Experience building dbt models using Medallion architecture
- Experience maintaining dimensional data models with Type 2 SCDs and star schemas
- Experience maintaining data warehouses on SQL Server
- Experience working with Snowflake, dbt, and Tableau
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Lyra Health’s mission is to transform mental health care through technology with a human touch — to get more patients the care they need when they need it. If you are an engineer or data scientist who would like to join in this effort, please reach out.
Gallery
