Senior Data Analyst: BI Dashboards & Data Automation

UMS Group; Sandton; On-site; ZAR 800,000 - 1,100,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL

Power BI

SQL Server

Data integration

Dashboards

Data governance

Excel

APIs

Analytical thinking

Stakeholder communication

Education

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

Tools

SSMS

SSRS

SQL Profiler

Power BI

Excel/Power Query

Job description

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.