Responsibilities:
- Define and continuously improve the Data and Solution Architecture standards for BI and Business Transformation:
- Develop and maintain an understanding of the business strategy and evolving business priorities
- Contribute to a structured BI Architecture approach and methodology for capturing the key strategic BI and Data requirements from business
- Contribute to the definition and continuous improvement of the BI and Data Architecture framework and associated solution architecture patterns and standards
- Align to the enterprise architecture in support of the business and regulatory information governance needs such as information security, enterprise information management, POPIA, etc.
- Identify, define and communicate standards, guidelines, formats, meta-models, policies, best practices and governance practices for BI and Data Architectures and designs
- Stay abreast of best practices and/or new developments in BI (Data Warehousing, Reporting and Analytics) and related disciplines and drive adoption as deemed appropriate
- Create and design data and information asset management framework
- Provide expert BI (Data Warehousing, Reporting and Analytics) guidance, ensure solution architectures and designs are in line with best practices
- Provide technical guidance and leadership in proposals, RFIs, RFPs, and BI Project team
- 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 and guide Technical Leads/Senior Developers/Data Modelers/Business Analysts
- Define and develop the overall BI architecture landscape in partnership with other domain architects and delivery teams
Qualifications and Experience required:
- National Diploma/Bachelors Degree in Computer Science, Statistics, Informatics, Information Systems, Information Technology, Engineering or another quantitative field preferred
- 5-10 years related experience
- Application and data engineering background with a solid background in SQL is required
- Designing, building and maintaining a modern data platform, including data lakes, data warehouses, business friendly semantic layers, etc.
- Extensive experience with data warehousing (Kimball and Data Vault patterns are preferred) and dimensional data modelling (OLAP and MDX experience)
- Exposure to modern data platform technologies that support cloud, big data, real-time data provisioning, advanced analytics and artificial intelligence implementations, including event streaming based data pipelines (e.g. Kafka or NiFi)
- Understanding of the information management and information architecture domain(e.g. DAMA/ DMBOK)
- Data visualization and reporting tools (e.g. SAP Business Objects, PowerBI etc.).
- Understanding of identity and access management technologies (LDAP/Kerberos/SAML/IBM IAM products)
- Data architecture design and delivery
- Database technologies (e.g. SAP Hana, Teradata or similar) and database development (views, functions and stored procedure development)
- Hadoop components including HDFS, Hive, Spark, Oozie and Impala
- Object-oriented/object functional scripting languages: Python, Java, Scala or related
- Knowledge of various toolsets such as SAP Hana Studio, SAP Data Services, Informatica Data Quality Suite, Teradata, Cloudera big data storage and Microsoft PowerBI will be advantageous
- Relevant Data system experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection
- Relevant experience delivering business solutions using applicable technology
Understanding of data flow from a technical and business perspective from source to output though Information management systems such as Data Warehouses and Data transformation hubs - Understanding of Information Architecture domain (e.g. DAMA/DMBOK)
- Understanding of enterprise implications of data policy as it relates to other policy domains – Security, Regulatory, Legal, Tax and Channel conflict
- Experience in warehousing, ETL, Reporting, Management Reporting, Business Intelligence implementations, migrations and technology selection
- Demonstrated competence in business domain analysis, data warehousing (design and operations), and database design
- Demonstrated competence with benefits, design and management of structured and unstructured content and database/repositories (SQL, NoSQL, HDFS/Hadoop distributions, etc.) and hands-on experience with specific products
- Demonstrated competence with Microsoft SQL Server, Oracle DBMS, SAP Business Objects, and related tools is valued
- Working knowledge of data science, data mining, OLAP programming, database management and programming, business process modelling and analysis
- Working knowledge of statistical computing and graphics programming languages (R, Python, etc.)
- Working knowledge of open source or commercial data visualization tools (BOBJ, Tableau, QlikView)
- Working knowledge of cloud-based offerings and vendor differentiation related to analytics and information processing capabilities (AWS, Azure)
- Proven work experience as a Data Architect, Data Scientist, Data Analyst or similar role
- In-depth understanding of database structure principles
- Familiarity with data visualization tools (e.g. PowerBI, Python and R)
- Database design
- Data maintenance, Database security, Database management
Skills:
- Architecture and 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
- Data analysis
- Database knowledge and monitoring
- Ability to mentor others and provide technical direction on data architecture, reporting, warehousing, and online analytical processing (OLAP) design
- Ability to communicate design solutions to both technical and non-technical audiences, clearly identifying and articulating the benefits to the business of recommended solutions and approaches