Senior Data Warehouse Architect

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

About the Role

Our client, a leading financial institution renowned for its innovative use of data, is seeking a highly skilled Senior Data Warehouse Architect to join their enterprise data team in Sandton, Gauteng. This role is critical for designing, developing, and managing robust, scalable, and high-performance data warehousing solutions that support critical business intelligence and analytics initiatives. You will be responsible for defining data architecture standards, guiding development teams, and ensuring data integrity and accessibility. The Sandton location is a prime business district, offering a dynamic professional environment. The ideal candidate will possess extensive experience with various data warehousing technologies (e.g., Kimball, Inmon methodologies), ETL/ELT processes, and modern cloud data platforms, combined with strong analytical and problem-solving skills. We are looking for an architect who can translate complex business requirements into efficient and effective data solutions. This position offers the opportunity to work with vast datasets and cutting-edge data technologies. Our client is dedicated to leveraging data for strategic decision-making.

Key Responsibilities

• Design and architect enterprise-level data warehouses, data marts, and data lakes to meet business intelligence and analytics needs.
• Develop and maintain 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.
• Optimize query performance and data loading processes for large datasets.
• 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.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related quantitative field. A Master's degree is a plus.
• A minimum of 7-10 years of experience in data warehousing and data architecture, with at least 3-5 years in a senior architect role.
• Proven experience designing and implementing data warehouses using Kimball or Inmon methodologies.
• Expertise in SQL, ETL/ELT tools (e.g., Informatica, Talend, SSIS, dbt), and data modeling tools.
• Strong understanding of cloud data platforms (e.g., Snowflake, Redshift, BigQuery) and distributed computing concepts.
• Experience with various database technologies (e.g., SQL Server, Oracle, PostgreSQL).
• Excellent analytical, problem-solving, and critical thinking skills.
• Strong communication and interpersonal skills, with the ability to articulate technical concepts to non-technical audiences.
• Experience with data governance, data quality, and master data management principles.
• Demonstrated ability to lead technical projects and mentor team members.
• Located in or able to commute to Sandton, Gauteng.

Benefits

Our client offers a highly competitive salary, annual bonus, comprehensive medical and retirement benefits, and substantial opportunities for professional growth, including advanced training and conference attendance. We provide a collaborative and intellectually stimulating work environment in Sandton. Join a leading organization in Gauteng that is at the forefront of data innovation.