COUNCIL FOR MEDICAL SCHEMES: Data Management Analyst

You will work within the Policy Research & Monitoring Unit of the Council.

You will also be responsible for the following:

 Monitor the impact of the Medical Schemes Act and trends in Private health Finance
– Review of contents of statutory returns; Analysis of non-accounting data, including demographics, utilisation of healthcare services, burden of disease and geographic distribution of membership for quarterly and annual statutory returns; Conduct exploratory data analysis;
– Provide statistical input into research projects; Conduct research on the private health care sector; and Evaluate and revise definitions of non-financial indicators (including PMBs).

 Statistical and analytical functions
– Data analysis and evaluation of submissions (comparative trend and statistical analysis);
– Consolidation and analysis of actuarial assumptions for benefit changes and contribution increases;
– Review of economic and health indicators for actuarial assumptions;
– Adhoc data and statistical analysis for projects e.g. the revision of the solvency framework, NHI etc. ; and provide data and analytics support to survey studies.

Systems development and maintenance:
– Develop data specifications for submission of healthcare utilization data; and
– Creation of analysis tools, templates, and reports for adhoc projects.

 Data Management:
– Extract data from databases and performing ad-hoc queries;
– Review, maintain analyse, and validate data to ensure consistency, integrity, completeness and accuracy based on project specific guidelines and create detailed reports;
– Assist in developing and maintain documentation and data management guidelines, standards and procedures;
– Assist in the development and implementation of strategy for data cleaning and advising on the design and programming of databases;
– Develop templates for data collection and reporting; and
– Liaise with stakeholders and internal staff to resolve problems with data submissions, resubmissions, data quality, and delivery issues related to the transmission and/or processing of such data.

The successful candidate will have the following key competencies and skills:

BSc Statistics or BCom Statistics;
3 years working experience in research environment and data management environment;
Experience and understanding of the whole data management life cycle
Experience in data preparation and data cleansing;
Experience in using qualitative and quantitative research methods;
Experience in research and more specific in the private healthcare environment;
Experience in data management and / or other Business intelligent (BI) tools;
Ability to work under pressure and to consult with external stakeholder on data quality and other data-related issues
Knowledge of public health financial and administrative mechanisms; and
Computer literacy – MS Office and advanced proficiency in Excel and statistical software packages (e.g. SAS, STATA, SPSS, SQL Server).