Analytics Engineer — Snowflake & dbt Data Pipelines

Lyra Health

Johannesburg

On-site

ZAR 600,000 - 900,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Lyra Health is a leading provider of mental health solutions for employers. The international data team is transforming its data architecture, moving from a legacy SQL server to Snowflake, dbt, Airflow, Tableau, and Sigma. The role offers a chance to mentor and share best practices with Snowflake/dbt, while building data infrastructure from scratch.

You will collaborate with teams in different time zones and contribute to scalable data solutions for reporting and analytics.

Qualifications

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.

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.