Senior Analytics Engineer at Lyra Health | Torre
Senior Analytics Engineer
Report
Lyra Health

Senior Analytics Engineer

Lyra Health
Emma
Emma
Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

Provide your expected compensation while applying
location_on
Remote (for South Africa residents)
Match
skeleton-gauges
You have opted out of job matches in .
Shared by
Emma of Torre.ai
 about 1 month ago

Requirements and responsibilities

About LyraLyra 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 OverviewThe 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 practises with Snowflake and dbt with the team, as well as a chance to build data infrastructure from scratch.Key Responsibilities:7+ years experience in data engineeringExperience in development of pipelines to ingest and transform data from sources using REST APIs, AWS S3 and AirflowExperience in building dbt models to transform data using Medallion architectureExperience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemasExperience in maintaining data warehouses on SQL ServerExperience in designing and building at least one data warehouse on Snowflake from scratchBe the Snowflake and dbt expert on the team, providing guidance on best practisesMake key design decisions for a brand new multi-dimensional data modelMake key architectural decisions for building a brand new data warehouse on SnowflakeBuild and maintain pipelines to ingest data from Salesforce and various other data sourcesBuild and maintain dbt models to transform data using Medallion architecture for use by business intelligence toolsWork closely with our Business Intelligence team - monitoring and implementing enhancement requests for the data warehouse to meet the reporting demands of stakeholdersThe 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 timezones, it is important that the candidate has strong interpersonal skillsRequirements: 7+ years experience in data engineering, ideally including cloud migration to SnowflakeDevelopment of pipelines to ingest and transform data from scratch using REST APIs, AWS S3 and AirflowExperience in designing and building dimensional data models from scratch with Type 2 SCDs and star schemasExperience in designing and building at least one data warehouse on Snowflake from scratchStrong SQL skills (CTEs and window functions)Proficiency in Python for building pipelines with SnowparkExperience designing multi-dimensional data models with star schema and Type 2 SCDsExperience with dbt for building robust ELT processes
This job opening is closed.