Senior Data Warehouse Engineer - ETL, SQL & AWS

AJ Personnel; Gauteng; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

AJ Personnel is seeking an experienced Data Warehouse Engineer in Gauteng to design and develop data warehouses using Kimball methodology. You will build ETL pipelines, ingest diverse data sources (CSV/JSON), and implement scalable data architectures for Retail, Financial Services and Logistics domains.

The role requires strong SQL and Python or R proficiency, plus 5–10 years in data warehouse design, with SAS Data Studio and AWS exposure considered advantageous.

Qualifications

• 3-year IT-related degree is required or equivalent experience.
• Postgraduate qualification is advantageous.
• 5–10 years’ experience in designing/developing data warehouses per Kimball.
• Adept at design and development of ETL processes.
• SQL development experience (SAS Data Studio preferred) and AWS exposure.
• Ability to ingest/output CSV, JSON and other flat files and related data sources.
• Proficient in Python or R.
• Experience in Retail, Financial Services and Logistics environments.

Responsibilities

• Ensure high data quality, accuracy and completeness through testing and review.
• Create clear technical documentation maintained over time.
• Conduct data design, database architecture, metadata and repository activities as required by stakeholders.
• Translate business needs into long-term architecture solutions.
• Define, design and build dimensional databases.
• Design ETL pipelines and data warehousing blueprints.
• Evaluate hardware/software platforms and integrate systems.
• Translate metadata into explanatory reports and visuals for end users.
• Pre-process data including transformation, normalisation and feature derivation for models.
• Build data quality metrics and perform validation testing.
• Adhere to IT governance when implementing changes.

Skills

Kimball data warehouse design

ETL development

SQL development

Python or R

Data ingestion/outputs (CSV/JSON)

Retail/FS/Logistics experience

Data quality assurance

Data governance

Education

3-year IT related degree

Postgraduate qualification (advantageous)

Tools

SAS Data Studio

AWS

Job description

AJ Personnel is seeking an experienced Data Warehouse Engineer in Gauteng to design and develop data warehouses using Kimball methodology. You will build ETL pipelines, ingest diverse data sources (CSV/JSON), and implement scalable data architectures for Retail, Financial Services and Logistics domains.

The role requires strong SQL and Python or R proficiency, plus 5–10 years in data warehouse design, with SAS Data Studio and AWS exposure considered advantageous.