Data Warehouse Solution Architect at Datacentrix

Data Warehouse Solution Architect

Our external client based in Cape Town (Northern Surbubs) is looking for a 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

Qualifications and Experience Required:

• Degree in Information Systems / B Sc Computer Science (or similar)
• 7-10 yrs Working experience within the IT industry
• 5 + yrs Working experience in data warehousing with at least 5 project lifecycles
• 5 + yrs Working experience with different ETL integration technologies (SSIS, Talend, SAP Data Services, etc.)
• 5 + yrs Experience with all aspects of IT projects from business analysis, architectures, system analysis and design through development,
• testing, implementation, and production support (SDLC).
• 2 - 3 yrs Lead a team through an architectural development process and collaborate with application development teams, architects and other members of the software development team.
• Architecture and design (UML, OO, SOA, etc.)
• S/W frameworks and methodologies (Agile, TOGAF, etc.)
• 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
• Experience using BI solutions, decision support systems, OLAP technology, and multi-dimensional data
• Experience with modern data warehousing technologies such as Snowflake, Teradata, Oracle 12c, Informatica, Cloudera and Alteryx.

Overall Responsibilities:

• 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
• 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
• Define and develop the overall data warehousing architecture landscape in partnership with the Domain Architect, Data Analytics team and other Solution Architects.