Solution Architect II – Data Warehousing | IT Recruitment

Position Purpose:

Become part of an innovative, forward-thinking and strategic IT architecture team.

Our mature architecture team is based in Brackenfell (strategically placed close to the sea and the Cape winelands) and includes experts in enterprise architecture, solution architecture and data architecture. We operate in an agile retail environment of Africa’s largest retailer that utilizes industry leading IT technologies which run on-premises and in multiple cloud platforms.

As a recognized authority in data warehouse solutions, covering staging area, data warehouse, data marts, and operational data stores, etc., the data warehouse solution architect strategically advises and shapes requirements for data warehousing solutions and creates high quality data, application and technology architectures in support of the business requirements and leads the realization of the design into the final solution implementation. Deep subject matter knowledge of data staging, data warehousing, data marts, operational data stores and reporting as applicable to the Retail business domain is essential.



  • Degree in Information Systems / B Sc Computer Science (or similar) – essential



  • 7-10 years – Working experience within the IT industry.
  • 5-10 years – Working experience in data warehousing with at least 5 project lifecycles
  • 5 years – Retail industry experience with an understanding of retail business processes.
  • 5+ years – Working experience with different ETL integration technologies (SSIS, Talend, SAP Data Services, etc.)
  • 5+ years – Working experience with data modelling tools
  • 5+ years – Worked on projects across multiple applications, SAP and non-SAP
  • 5+ years – Experience with all aspects of IT projects from business analysis, architectures, system analysis and design through development, testing, implementation, and production support (SDLC).
  • 5+ years – Excellent design and architecture skills and proven track record delivering well designed complex enterprise class systems.
  • 3+ years – Excellent technical development and be able to mentor others to improve their design and development skills.
  • 5+ years – Identification and formulation of solution architecture and solution alternatives and their assessment
  • 5+ years – Demonstrated expertise in a variety of application development methodologies and practices.
  • 2-3 years – Lead a team through an architectural development process and collaborate with application development teams, architects and other members of the software development team.
  • 2-3 years – Experience with current research and standards in Solution Architecture.
  • 3+ years – Experience in high volume data and files processing, in a batch and real time, integration environment. – desirable
  • 2-3 years – Project management experience of mid-sized projects. – desirable


Job objectives:

Define and continuously improve the data warehousing architecture framework and solution architecture modeling standards.

  • Develop and maintain an understanding of the business strategy and changes to business priorities.
  • Define a structured data warehouse architecture approach and methodology for capturing the key views of the enterprise.
  • Architect the next-generation data warehousing framework developed on a group of core technologies.
  • Align to the enterprise data reference architecture in support of the enterprise and regulatory information governance needs such as Information Security, Enterprise Information Management, POPI, PCI, etc.
  • Identify, define and communicate standards, guidelines, formats, meta-models, policies, best practices, and governance practices for Data Warehouse architectures and designs.
  • Ensure that the Data Warehousing approach integrates into the methodologies and processes of the rest of the Enterprise Architecture team.
  • Stay abreast of best practices and / or new developments in Data Warehousing and related disciplines and drive adoption as deemed appropriate.


Define and create solution level data warehousing architecture models that are aligned with business blueprints, non-functional requirements, delivery constraints, data, application and technology standards.

  • Analyze business requirements and create related Data Warehousing architectures and designs for the baseline (“as is”) and target (“to be”) solution architectures.
  • Define data warehousing architecture governance processes and quality compliance criteria.
  • Perform quality assurance checks on Data Warehousing Architectures and Designs and enforce quality compliance criteria to set policies and standards.
  • Perform quality checks on existing Data Warehousing Architectures and Designs to identify potential business risks areas and make re-engineering recommendations.
  • Ensure Data Warehousing security conforms to Information Security Governance policies and standards


Provide expert data warehousing guidance, ensure solution architectures and designs are in line with the data warehousing technology standards and conduct architecture and design reviews as part of the Architecture Review Committee.

  • Be clearly identified as the data warehousing technical lead and provide technical guidance and leadership in proposals, RFIs, RFPs, and BI project teams.
  • Provide architectural oversight and guidance to development teams to ensure high-quality technical solution designs during the detailed design, build, test and deploy phases that conforms to architecture principles and standards.
  • Mentor senior developers / designers / business analysts to become Solution Architects.
  • Define and develop the overall data warehousing architecture landscape in partnership with the Domain Architect, Data Analytics team and other Solution Architects.
  • Review proposed solution architectures ensuring alignment with architecture principles, the architecture framework, cloud reference architectures, set technology standards and identify critical gaps, and recommend improvements.
  • Give guidance and advice to peers in respect to data warehousing solution designs ensuring the designs conform to industry best practices and standards


Knowledge & Skills:

  • Architecture and solution design (UML, OO, SOA, etc.)
  • S/W frameworks and methodologies (Agile, TOGAF, etc.)
  • Solid track record in successful delivery solution architecture
  • Strong analytical, problem-solving and logical skills
  • Excellent team-working, inter-personal skills
  • Develop of proposals and excellent written communication & presentation skills
  • Excellent organisation and facilitation skills
  • Strong conflict management skills
  • Commercial & business understanding of retail industry – desirable
  • Knowledge and experience in the design and use of (multi-dimensional) Data Warehouses, and the use of ETL software to provide these with information
  • Experience using an RDBMS and advanced skills in query languages, especially SQL and Python
  • Experience using BI solutions, decision support systems, OLAP technology, and multi-dimensional data
  • Experience with AWS BI-related technologies (e.g., Talend, EMR, Kinesis, Selinium, Athena, Redshift, etc.) – desirable
  • Experience with modern data warehousing technologies such as Snowflake, Teradata, Oracle 12c, Informatica, Cloudera, Alteryx, etc.
  • Experience with data monetization business models – desirable
Upload your CV/resume or any other relevant file. Max. file size: 20 MB.