Analytics Engineer

The role

You will build and maintain data pipelines and dbt models that prepare data for business intelligence tools. You will work with the international data team on a move to Snowflake, dbt, Airflow, Tableau and Sigma.

What you will do

• Build and maintain pipelines to ingest data from Salesforce and other data sources
• Build and maintain dbt models using Medallion architecture for business intelligence tools
• Work with the Business Intelligence team to monitor and implement data warehouse enhancement requests
• Work collaboratively with team members in different time zones

Required qualifications

• 3+ years 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 (essential)

Before you apply

• Preference is given to suitably qualified candidates from designated groups, including persons with disabilities, under the Employment Equity Act

About the company

Lyra Health is a provider of mental health solutions for employers, supporting more than 20 million people globally. Its platform is Lyra Empower, which combines care and technology.