Website AES Global
Junior Data Engineer
Location:Cape Town (hybrid, 3 days in office)
Type: Permanent
Experience: 1–2 years
About the role
We’re working with an established retail business looking for a Junior Data Engineer to help build and maintain the data pipelines and warehouse solutions that power its reporting and analytics. It’s a great role for someone early in their data career who wants hands-on experience across ETL, data warehousing, and modern cloud platforms, with room to grow.
What you’ll do
• Help design, develop, and maintain scalable ETL/ELT processes using SQL and SSIS
• Build data ingestion pipelines from various operational systems (ERP, POS, vendor APIs) into the data warehouse
• Monitor daily data movements, troubleshoot pipeline failures, and resolve data discrepancies
• Contribute to enterprise data warehouse solutions, including building fact and dimension tables (Star/Snowflake schemas)
• Prepare and deliver trusted, structured datasets to support Power BI, SSRS reporting, and business users
• Support the administration and optimization of Microsoft SQL Server environments (SSMS, SSDT), including monitoring database performance and scheduled Agent jobs
• Help ensure secure, reliable data exchange across internal and third-party platforms
• Adhere to POPIA-compliant data governance, security, and quality standards
• Manage source code using Git/GitHub and take part in Jira-driven delivery and CI/CD processes
• Help migrate legacy systems to modern cloud data platforms (Databricks, Microsoft Fabric, AWS, or GCP)
• Use approved AI-assisted development tools (e.g. GitHub Copilot) responsibly to boost productivity
What you’ll bring
• Foundational experience or a strong academic background in Microsoft SQL Server (T-SQL, SSMS)
• An understanding of data warehousing concepts (dimensional modelling, fact/dimension tables)
• Basic experience with ETL/ELT tools and processes (preferably SSIS)
• Familiarity with version control, primarily Git/GitHub
• A positive, problem-solving mindset and a strong eagerness to learn
Nice to have
• Exposure to cloud and modern platforms (Microsoft Fabric, AWS, Google Cloud, or Databricks)
• Familiarity with consuming REST APIs and processing JSON/XML data
• Exposure to analytics platforms, specifically Power BI or SSRS
• Basic understanding of automation and DevOps, including CI/CD pipelines and agile delivery (Jira)
• Awareness of data governance, including POPIA compliance, RBAC, and data lineage
To apply for this job email your details to steven@aesglobal.io
