Data Warehousing - Solutions Architect at Paracon

Data Warehousing - Solutions Architect

You will be responsible for strategically advising and shaping requirements for data warehousing solutions and creating high-quality data, application and technology architectures in support of the business requirements and leading the realisation of the design into the final solution implementation.

To apply, you need to have a Degree in Information Systems / BSc Computer Science (or similar) coupled with 7-10 years’ working experience within the IT industry and 5+ years’ working experience in data warehousing with at least 5 project lifecycles.

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.

You also need 5+ years’ experience in the following:

• Working with different ETL integration technologies (SSIS, Talend, SAP Data Services, etc.);
• All aspects of IT projects from business analysis, architectures, system analysis and design through development, testing, implementation, and production support (SDLC); and,
• Leading a team through an architectural development process and collaborating with application development teams, architects and other members of the software development team (2-3 years).

Adding to the above, your knowledge/experience will need to encompass the following:

• Architecture and design (UML, OO, SOA, etc.);
• Software frameworks and methodologies (Agile, TOGAF, etc.);
• The design and use of (multi-dimensional) Data Warehouses, and the use of ETL software to provide these with information;
• RDBMS and advanced skills in query languages, especially SQL;
• BI solutions, decision support systems, OLAP technology and multi-dimensional data; and,
• Modern data warehousing technologies such as Snowflake, Teradata, Oracle 12c, Informatica, Cloudera, Alteryx, etc.