Data Warehouse Engineer

Parvana

Data Warehouse Engineer in Johannesburg designing scalable data warehouse architectures and optimizing ETL pipelines. Collaborating with stakeholders and employing Agile methodologies.

Posted 5/5/2026full-timeJohannesburg • 🇿🇦 South AfricaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLPostgresPythonSDLCSQL

About the role

Key responsibilities & impact

Design, implement, and maintain scalable data warehouse architectures (Star/Snowflake) and optimize ETL/ELT pipelines for data quality.
Write and tune complex SQL (T-SQL/ANSI) and use Python for data manipulation and advanced analytics.
Own the full SDLC: requirements, design, testing, deployment, and solution estimation.
Collaborate with stakeholders to translate business data needs into technical structures.
Identify and resolve performance bottlenecks through normalisation, indexing, and query optimization.
Develop and maintain dashboards/reports using tools like Power BI or Yellowfin for data-led decision-making.
Create and maintain high-quality technical documentation (data flow diagrams, specifications, metadata).
Actively participate in the Agile/Scrum framework and sprint ceremonies.
Research and evaluate emerging data technologies to continuously improve the data warehouse.

Requirements

What you’ll need

A relevant tertiary qualification would be beneficial (Computer Science, IT, Data Science, etc.)
Strong knowledge of analytical & dimensional data warehouse modelling, design, architecture, data structures, and fundamental design principles.
Experience in developing and modifying ETL processes (Extract, Transform, Load) using various data sources, and understanding concepts like data normalisation and performance tuning.
Proficiency in relational databases (SQL Server, PostgreSQL), SQL (TSQL/ANSI), and programming languages like Python.
Capability in the full Software Development Life Cycle, including solution estimation, requirements gathering, analysis (modifying data structures to meet client needs), technical design, unit testing, debugging, and documentation.
Ability to consult with clients to gather requirements, analyse business needs, propose technical alternatives, and provide necessary documentation (e.g., technical specifications, data flow diagrams).
Understanding of Big Data Visualization Tools and specific industry BI Visualisation tools (e.g., Yellowfin or Power BI).
Essential skills include communication (verbal & written, internal & external), problem-solving, and being a team player.

Benefits

Comp & perks

Flexible working arrangements
Professional development opportunities

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data warehouse architectureETLELTSQLT-SQLANSI SQLPythondata modellingperformance tuningdata normalisation

Soft Skills

communicationproblem-solvingteam playercollaborationrequirements gatheringtechnical documentationanalytical skillssolution estimationdebuggingclient consultation

Certifications

Computer Science degreeIT degreeData Science degree