Job Purpose
To service our customers by obtaining and providing accurate data and information, measuring performance and providing intelligence to enable continual improvement.
Principal Accountabilities
Compile and update existing daily/weekly/monthly reports. (DPMO,TCF,iQS)
Review and optimize business processes within QMC.
Research best practice and new innovative ways of presenting data.
SharePoint administration libraries, Lists, site permissions and workflows.
Ad hoc and bi-annual reporting.
Manage multiple portfolios.
Identify, analyze and interpret trends or patterns in complex data sets using statistical techniques with a focus on increasing service efficiency.
Design and build excel reports based on business requirements using power pivot, Power query and Dax.
Experience in developing PowerBI reports.
Data processing implementing protocols for data processing, cleansing and verification of data used for analyses
Proposed system improvements by analysis facilitating JAD sessions.
Enhancing data collection procedures to include information that is relevant for Building reports.
Design, create and execute test cases and test scripts.
Document business requirements in the form of BRDs, use cases, user stories and Business rules
Education
Essential: Matric with Math
Advantageous: Degree/Diploma: Information systems or Stats - advantageous
Knowledge
Excel (Essential) - Advanced
Word and PowerPoint (Essential0 - Advanced
Information systems (includes SharePoint Cognos) (Essential) - Intermediate
Data Models Cubes and Tabular (Essential) - Intermediate
Power Pivot and Power Query (Essential) - Advanced
Visual Basic (Essential) - Intermediate
SQL and DAX (Essential) - Intermediate
Jira and Confluence (Essential) - Intermediate
Python and R (Nice to have) - Intermediate
SSAS SSIS SSRS (Nice to have) - Intermediate
Experience
Essential: 2- 3 years' data analysis experience
Advantageous: 2-3 Business analyst experience.