Junior data engineer

We’re working with an established retail business, and they’re looking for a Junior Data Engineer to help build and maintain the data pipelines and warehouse behind its operations.

You’ll work across ETL/ELT processes, data ingestion and warehousing, learning from an experienced team while taking real ownership of clean, reliable data.

What you’ll do Help design, develop and maintain scalable ETL/ELT processes using SQL and SSIS Build data-ingestion pipelines from operational systems (ERP, POS, vendor APIs) into the data warehouse Monitor daily data movements, troubleshoot pipeline failures and resolve data discrepancies Contribute to the enterprise data warehouse — building star and snowflake schema tables Prepare trusted, structured datasets for Power BI and SSRS reporting Support and optimise Microsoft SQL Server environments (SSMS, SSDT) Adhere to POPIA-compliant data governance, security and quality standards Manage source code with Git/Git Hub and take part in Jira-driven delivery and CI/CD What you’ll bring 1–2 years’ experience, or a strong academic background, in Microsoft SQL Server (T-SQL, SSMS) An understanding of data-warehousing concepts (star and snowflake schema modelling) Basic experience with ETL/ELT tools and processes (SSIS preferred) Familiarity with version control (Git/Git Hub) A positive, problem-solving mindset and eagerness to learn Advantageous Exposure to cloud and modern platforms (Microsoft Fabric, AWS, GCP or Databricks) Consuming REST APIs and processing JSON/XML Power BI or SSRS reporting, CI/CD and agile delivery (Jira) Awareness of data governance (POPIA, RBAC, data lineage) Working model

Hybrid, based in Cape Town, with some in-office days. #J-18808-Ljbffr