Data Analyst

MDK Appointments; Johannesburg; On-site; ZAR 300,000 - 600,000; Full time

Job summary

An established industry player is seeking a skilled Reporting Analyst to join their dynamic team. In this role, you will leverage your expertise in SQL and data analysis to extract and manipulate data from relational databases, ensuring data integrity for insightful reporting. You will collaborate closely with IT and stakeholders to develop data models and reporting strategies that drive business decisions. This is an exciting opportunity to enhance your skills in a supportive environment while contributing to impactful data governance and management practices. Join a forward-thinking company where your analytical abilities will make a real difference!

Qualifications

• Experience as a reporting analyst with client-facing experience.
• Strong troubleshooting and report writing abilities.

Responsibilities

• Extract and manipulate data from SQL databases for reporting.
• Support system integration and data mappings for new clients.
• Build reporting and analytics strategies to optimize data quality.

Skills

SQL

Data Analysis

Statistical Techniques

Reporting

Troubleshooting

Team Collaboration

Education

Degree in Management Information Systems

Degree in Finance

Degree in Econometrics

Degree in Statistics

Tools

Excel

Power BI

Cheetah System

Job description

Extracting data from a SQL server relational database.

Advance SQL querying and reporting.

Manipulation and interpretation of data from a SQL server relational database. Conducting and supporting peer reviews to ensure data is fit for purpose with regards to the development of Proof of Concepts, dashboards, and reports. Acquiring and processing data from multiple sources and systems using SQL and data visualization tools.

Interpret data, analyze results using statistical techniques, and provide ongoing reports.

Locate and define new data process improvement opportunities. Filter and clean data by reviewing reports and performance indicators to locate and correct problems.

Administration (10%)

Ensuring that data flows through the various processes correctly.

Recording and reporting on volumes of data flowing through the various data processes.

Controlling and managing data documentation and reports generated.

Client System and Integration Support (10%)

Support in system integration and data mappings for new client take-on.

Act as business analyst for data requirements and management between clients and IT.

Provide support on data queries relating to integration.

Work with management to prioritize business and information needs.

Respond to inquiries and requests for information from stakeholders in a timely manner.

Support interfaces with external client systems such as CAS, Vision, FutureSoft, Tallyman, etc.

Reporting (40%)

Build reporting, data analytics, and other strategies that optimize statistical efficiency and quality to support the business.

Identify, analyze, and interpret trends or patterns in complex data sets.

Develop and test data models to capture clients' KPIs and data transformations.

Work closely with IT, internal stakeholders, and SMEs to interpret data requirements, identify solutions in relation to data management, and recommend technical solutions on data elements to support business decisions.

Assist with the establishment and ongoing review and refinement of the data governance policy(s) and/or management such as data ownership, master data management, and metadata management.

Generate management information reports as required and interpret the validity and integrity of reports produced before distribution.

Submit code regularly to produce predefined extracts and reports.

Recommend improvements regarding code where possible to improve the process.

Experience & Qualification

Degree in management information systems, finance, econometrics, statistics, or similar.

Demonstrable experience as a reporting analyst, preferably with client-facing experience.

Experience working with SQL, Excel, Power BI, or other relevant tools. Ability to create, update, and share databases. Strong troubleshooting and report writing abilities. Attentive and considerate team player. Cheetah System Knowledge (Advantage).