Analytics Engineer
Data Science
Johannesburg, South Africa
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
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