Senior Data Warehouse Architect — Lead Data Innovation in Sandton

Placements24; Sandton; Hybrid; ZAR 900,000 - 1,700,000; Full time

Benefits offered by this job

Annual bonus

Medical and retirement benefits

Professional growth opportunities

Conference attendance

Job summary

Placements24 represents a leading financial institution in Sandton, Gauteng, seeking a Senior Data Warehouse Architect to lead enterprise data warehouse initiatives. You will design scalable data warehouses, data lakes, and data marts, define standards, and guide cross-functional teams to deliver BI and analytics solutions.

The role requires deep expertise in Kimball or Inmon methodologies, ETL/ELT tooling, cloud platforms such as Snowflake or Redshift, and strong data governance.

Qualifications

• Bachelor's degree in CS/IT/Engineering or related field.
• 7–10 years in data warehousing with 3–5 years in a senior architect role.
• Experience with Kimball or Inmon methodologies.
• Proficiency in SQL and ETL/ELT tools (Informatica, Talend, SSIS, dbt).
• Cloud data platforms such as Snowflake, Redshift, BigQuery; various DBs like SQL Server, Oracle, PostgreSQL.
• Strong analytical, problem-solving, and communication skills.
• Located in or able to commute to Sandton, Gauteng.

Responsibilities

• Design and architect enterprise-level data warehouses, data marts, and data lakes to meet BI and analytics needs.
• Develop conceptual, logical, and physical data models for the data warehouse environment.
• Define standards and best practices for data modeling, ETL/ELT processes, and data governance.
• Oversee the design and implementation of efficient data integration strategies from various source systems.
• Evaluate, select, and implement appropriate data warehousing technologies, tools, and platforms.
• Collaborate with data engineers, business analysts, and stakeholders to gather requirements and deliver solutions.
• Ensure data quality, integrity, consistency, and security within the data warehouse environment.
• Provide technical leadership and guidance to data engineering teams.
• Develop and maintain comprehensive documentation for data warehouse designs, processes, and standards.
• Stay abreast of emerging trends and technologies in data warehousing, data lakes, and big data analytics.
• Participate in data governance initiatives to ensure data accuracy and compliance.

Skills

SQL

Analytical thinking

Communication

Mentoring

Education

Bachelor's degree in Computer Science/IT/Engineering

Master's degree (bonus)

Tools

Informatica

Talend

SSIS

dbt

Job description

Placements24 represents a leading financial institution in Sandton, Gauteng, seeking a Senior Data Warehouse Architect to lead enterprise data warehouse initiatives. You will design scalable data warehouses, data lakes, and data marts, define standards, and guide cross-functional teams to deliver BI and analytics solutions.

The role requires deep expertise in Kimball or Inmon methodologies, ETL/ELT tooling, cloud platforms such as Snowflake or Redshift, and strong data governance.