Job Description

Key purpose:

To provide expertise in the design, development and maintenance of sourcing data and loading it into the data warehouse. To design and develop multi-dimensional cubes, and building of reports and dashboards off the data warehouse and cubes.

Qualifications and experience:

• Minimum Qualification - Relevant Diploma or Degree in Computer Science
• Experience - 5 years relevant experience

Additional requirements

• Understand and identify data requirements from various stakeholders
• Formulate and design data flows and data models
• Facilitate workshops
• Present to CFOs and key stakeholders
• Operate a productionalized data model
• Assessing, analysing and understanding end to end processes/models
• Developing controls to ensure an effective and accurate model execution
• Compile business requirements with stakeholders and business sponsors
• Understand and assist in creating the best and most suitable design solution that meets the user requirement.
• Be thoroughly involved in the design, implementation and testing of profitability models
• Understanding of finance and financial reporting
• Attention to detail
• Presentation skills
• Fast Learner
• Be a good listener and interrogate information(Verbal/Documentation/Data)
• Stakeholder Management
• Maintaining objective and effective working relationships with diverse people
• Business Analysis (Identification of problem, solution formulation, implementation and testing)
• Effective communication skills especially regarding complex and technical topics
• Good Time management
• Appropriate documentation and writing skills
• Competencies in data query languages SQL/SAS/SQL Spark (Favourable)
• Understanding of data and data architecture (Favourable)
• Problem solving
• Understanding of data processes and controls (Favourable)
• Additional Skills: SAS Enterprise Guide - Must have Microsoft SQL SSIS/SSAS Ab Initio (ETL) Advantageous Teradata PowerBI MicroStrategy Passionate about data and good understanding of Data Architecture Understanding of finance and financial reporting Attention to detail

Duties and responsibilities:

• Build working relationships across teams and functional lines in order to enhance work delivery, collaboration and innovation
• Continuously assess own performance, seek timely and clear feedback and request training where appropriate
• Provide input into the development of the tactical strategy, and develop and implement a supporting operational strategy
• Ensure compliance to legislative and audit requirements and adherence to relevant processes
• Develop new reports and dashboards off cubes and data warehouse and manage existing reports/dashboards through ongoing production of MIS outputs
• Extract, Transform and Load data from various sources and convert it into meaning information
• Prevent wastage, and on an ongoing basis identify process improvements in order to contain and reduce costs
• Deliver internal and external customer service excellence through adherence to quality service standards