Data Warehouse Engineer

Parvana; Johannesburg; Hybrid; ZAR 650,000 - 900,000; Full time

Job summary

Parvana is seeking a skilled Data Warehouse Engineer in Johannesburg to design and optimize scalable data warehouse solutions. You will implement ETL/ELT pipelines and work with SQL Server/PostgreSQL, Python, and BI tools to drive data-driven decisions.

You’ll participate in Agile/Scrum, contribute to SDLC activities, and help document data flows and architecture while collaborating with stakeholders across the business.

Qualifications

• Bachelor’s degree or equivalent in Computer Science, IT or data science.
• Strong knowledge of analytical and dimensional data warehouse modeling, design and architecture.
• Experience in ETL processes with multiple data sources and performance tuning.
• Proficiency in SQL and Python for data manipulation and analytics.
• Ability to document technical designs, data flows and metadata.
• Experience with BI tools like Power BI or Yellowfin.

Responsibilities

• 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 normalization, indexing, and query optimization.
• Develop and maintain dashboards/reports using 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.

Skills

Data warehousing

ETL/ELT

SQL

Python

Data modeling

Power BI

Yellowfin

SDLC

Agile

Education

Bachelor’s degree in CS/IT/Data Science

Tools

SQL Server

PostgreSQL

Job description

Location: Johannesburg | Work Type: Hybrid | Job ID: J107172

About our client: Our client offers financial service solutions helping their clients achieve their dreams. With an emphasis on culture fit, they boast a dedicated team of over 600 employees, many with over a decade of tenure. They have built their culture on a feeling of togetherness, trust and respect and are always looking to support employees' continuous learning. Using Agile, they provide diverse services with a focus on research, innovation and improvement.

What you will be doing:

• 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.

What our client is looking for:

• 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.

For a more comprehensive list of opportunities that we have on offer, do visit our website - https://www.parvana.co.uk/careers

Requirements

Data Warehouse, ETL, ELT, SQL, Python, Dimensional Modeling, Star Schema, Snowflake Schema, SDLC, Agile, Power BI, Yellowfin, Performance Tuning