Posted 5 months ago
Analytics Engineer
JohannesburgRemoteFull-time
AI Summary
An Analytics Engineer at Lyra Health designs and builds data pipelines and multi-dimensional data models in Snowflake, migrates the data stack to modern cloud tools (Snowflake, dbt, Tableau), and supports cross‑time‑zone reporting needs.
About this role
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.
The Lyra Health International Data team are responsible for the processing of data from source systems for use in data analytics, with a particular focus on adherence to privacy legislation such as GDPR.
As Lyra operates in 150+ countries, our data must be accurate and accessible across many time zones simultaneously. Our data is used to power dashboards that enable data-driven decision making to support our company’s vision. Our long term goal is to work towards process and infrastructure standardisation across both our team and the counterpart team in the US.
Key Responsibilities:
- Report to the team lead and be a key contributor to our migration from a legacy SQL Server data stack to a modern cloud data stack consisting of Snowflake, dbt and Tableau
- Design and build data pipelines using Snowpark and/or Snowpipe where native connectors do not exist for Snowflake for various data sources
- Contribute to designing and building a new multi-dimensional data model in Snowflake
- Work closely with our Business Intelligence Analytics 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.
Requirements:
-
3+ years of experience in data engineering, ideally including cloud migration to Snowflake
-
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
Skills
CTEsData WarehouseDbtELTGDPRPythonSnowflakeSnowparkSnowpipeSQLStar SchemaTableauType 2 SCDsWindow Functions
Explore related jobs
More jobs at Lyra Health
- Senior Sales ConsultantSouth Africa
- Mental Health Therapist - Telehealth (Unrestricted License LMSW-C, LMFT, LPC - Michigan)Michigan
- Mental Health Therapist - Telehealth (Unrestricted License LICSW, LMFT, LPC - Alabama)Alabama
- Mental Health Therapist - Telehealth (Unrestricted License LCSW-C, LCMFT, LCPC- Maryland)Maryland
- Mental Health Therapist - Telehealth (Unrestricted LCSW, LMFT, LCPC - Nevada)Nevada
- Prescribing Nurse Practitioner or Physician Assistant (In Person) - Pelham, AL - 1099 Contractor (copy)Pelham, Alabama
Similar CTEs jobs
Jobs in Johannesburg
Sales Development Representative (Outbound SDR)Adaptive Teams · Johannesburg, South Africa- IT SupportTakealot Group · Eastport, Johannesburg
- DC Operations Managertakealot.com · Johannesburg
- OMF Financial Consultant (Eastgate Mall)Old Mutual Life Assurance Company (SA) Ltd (PFA) · Johannesburg
- Profit Center Manager - Commercial Property, SSAAIG PC Global Services, Inc. · Johannesburg
- Senior Specialist: Marketing Cloud & Data CloudAbsa Bank · Johannesburg
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.