Senior Data Analyst

UMS Group; Sandton; In loco; ZAR 800.000 - 1.100.000; Tempo pieno

Descrizione del lavoro

UMS Group is seeking an experienced Senior Data Analyst to develop and maintain advanced data analytics, business intelligence solutions, dashboards and reporting tools across the Group.

The successful candidate will apply strong technical expertise in SQL, database management, data integration and reporting technologies to improve data accessibility, automate reporting processes and optimise existing information systems.

Competenze

• Relevant tertiary qualification in Computer Science, Information Technology, Data Analytics, Information Systems or a related discipline.
• Minimum 5–8 years of proven experience in data analysis, business intelligence, technical reporting or related information systems environments.
• Advanced SQL skills, including writing complex queries, data extraction, transformation and performance optimisation.
• Experience working with relational databases, preferably Microsoft SQL Server.

Mansioni

• Translate business requirements into analytical models, dashboards, reports and performance indicators.
• Develop interactive reporting solutions using Power BI, Excel and other analytical tools.
• Provide meaningful insights and recommendations to improve operational performance, efficiency and business processes.
• Support management with ad hoc analysis, scenario modelling and business performance assessments.

Conoscenze

SQL

Power BI

SQL Server

Data integration

Dashboards

Data governance

Excel

APIs

Analytical thinking

Stakeholder communication

Formazione

Relevant tertiary qualification in Computer Science/Information Technology/Data Analytics/Information Systems or related discipline

Strumenti

SSMS

SSRS

SQL Profiler

Power BI

Excel/Power Query

Descrizione del lavoro

UMS is seeking an experienced Senior Data Analyst to develop and maintain advanced data analytics, business intelligence solutions, dashboards and reporting tools across the Group.

The successful candidate will apply strong technical expertise in SQL, database management, data integration and reporting technologies to improve data accessibility, automate reporting processes and optimise existing information systems.

• Relevant tertiary qualification in Computer Science, Information Technology, Data Analytics, Information Systems or a related discipline.
• Valid drivers licence.
• Minimum 5-8 years of proven experience in data analysis, business intelligence, technical reporting or related information systems environments.
• Advanced SQL skills, including writing complex queries, data extraction, transformation and performance optimisation.
• Experience working with relational databases, preferably Microsoft SQL Server.
• Demonstrated ability to develop dashboards and reporting solutions using Power BI, advanced Excel, Power Query or similar tools.
• Proven experience integrating data from multiple business systems, databases and data sources.
• Strong problem-solving skills with the ability to investigate and resolve data quality, reporting and technical system issues.
• Working knowledge of data governance, information security and data quality management principles.
• Excellent communication skills with the ability to translate business requirements into effective technical solutions.

Distinct Advantages

• Experience with SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS) and SQL Profiler.
• Experience with API integrations and custom SQL-based reporting solutions.
• Exposure to Agile methodologies and technical project coordination.
• Experience developing technical manuals, training materials and user guidance.
• Knowledge of AI-enabled analytical and automation tools.
• Exposure to mining, engineering, construction, EPCM or multidisciplinary systems environments.

Duties and Responsibilities

Data Analysis & Business Intelligence

• Translate business requirements into analytical models, dashboards, reports and performance indicators.
• Develop interactive reporting solutions using Power BI, Excel and other analytical tools.
• Provide meaningful insights and recommendations to improve operational performance, efficiency and business processes.
• Support management with ad hoc analysis, scenario modelling and business performance assessments.

Data Management, Quality & Governance

• Extract, clean, transform and consolidate information from multiple systems and databases.
• Validate and reconcile data to ensure accuracy, completeness and reliability.
• Investigate and resolve data discrepancies in collaboration with IT and business stakeholders.
• Maintain appropriate data structures, documentation and compliance with information-security requirements.

Reporting Systems & Process Optimisation

• Develop and maintain SQL-based reports, data models, dashboards and automated reporting solutions.
• Support integration between business systems, databases and approved APIs.
• Resolve technical reporting, data extraction and system-performance challenges.
• Identify opportunities to improve reporting efficiency, automation and data accessibility.

Business Systems & Stakeholder Support

• Engage with stakeholders to understand reporting requirements and translate business needs into practical technical solutions.
• Coordinate assigned data analytics and reporting initiatives, including implementation, testing and user acceptance.
• Validate reporting outputs and address data interpretation or usability concerns.
• Provide technical support to promote effective adoption of reporting solutions.

Technical Expertise & Continuous Improvement

• Provide technical guidance and mentoring to junior analysts and business users.
• Maintain technical documentation, reporting procedures and user guidance.
• Facilitate training and knowledge sharing to improve reporting capabilities.
• Identify opportunities to improve analytical methods, reporting systems and processes through emerging technologies.

We are committed to employment equity and the principles of diversity and inclusion. Our recruitment processes aim to support our employment equity objectives while ensuring that appointments are made in line with operational requirements.