Senior Data Analyst at SAICA CA(SA)

Job description

MAIN PURPOSE OF THE JOB:

• To take ownership in collecting, organizing, and analyzing data from various resources in line with the Nation Building Programme.
• Design and populate data management sheets and compile / present reports, verify the quality and integrity, and use data to assist executive- and senior-level staff to make informed company decisions to maximise the impact and sustainability of programme results.
• The programme will place strong emphasis on the measurement and evaluation of efforts to better understand results and drive toward continued improvement in delivery and outcomes.

ACCOUNTABILITIES:

Products

Tasks may include, but not limited to:

• Coordinate all analytical work related to ongoing programme evaluation.
• Participate in assembly, cleaning and data management for programme-related datasets for accountability, research, evaluation and performance management projects.
• Extract, analyse and manipulate monthly data received from management to compile a set monthly report.
• Manage data reporting and provide feedback on progress to all members of the Nation Planning Exco in the form of reports and/or presentations. Ensure easily understandable representation of data.
• Populate and manage data bases with product data, and analyse data, as appropriate.
• Manage a data base. Ensure accuracy and integrity of data and its attribution to costs incurred by programme. .
• Project plan around productivity targets and design evaluations, assessments and performance management as required.
• Support the development, definition and calculations for metrics to evaluate programme outcomes.
• Utilize statistical analysis, reporting and presentation tools, such as SPSS, STATA, R, Excel, PowerPoint and Tableau.
• Propose changes to working practices and assist with implementing policies and projects within determined parameters.
• Communicate progress, including easily understandable representation of the data, to all members of the Nation Building Exco on a monthly basis.
• Responsible for ensuring data bases are kept up to date and a quarterly product report is completed and disseminated within 3 weeks of the financial quarter having terminated.

REQUIREMENTS:

• Proficient in Microsoft SQL with a solid understanding of Relational Database theory
• Experienced in the following Microsoft SQL Server tools: SSIS, SSAS
• Creation of Excel pivot tables and charts
• Confident user of statistical analysis and reporting tools, including SPSS, STATA and R
• Understanding of financial and accounting concepts

PHYSICAL WORK ENVIRONMENT FACTORS:

Time: 80% office bound, and 20% requires travel to project sites for meetings (domestic travel only).

QUALIFICATION AND EXPERIENCE:

• N.Dip/B Degree or MS relevant IT qualification
• Previous experience working with data analysis, programme evaluation, research design and /or survey development and business intelligence
• Well-developed organization skill and strong attention to detail.
• Independent and self-driven with the ability to drive components of a large multi-functional project.
• Project management experience and / or experience of educational or social service environments are desirable, but not a requirement.

COMPETENCIES:

• Strong Communication Skills
• Situational Leadership skills
• Problem Solving and Innovation
• Goal setting
• Self Starter/initiative
• Action orientated
• Solution focused
• Business acumen
• Planning and Organisation skills
• Results driven
• Sense of responsibility