Senior Data Analyst

Discovery Limited; Pretoria; On-site; ZAR 600 000 - 850 000; Full time

Job summary

A financial services company in Pretoria is seeking a Data Analyst to lead automation strategies for financial systems. The ideal candidate will optimize financial processes using SageX3 and provide insights through data analysis. Applicants should have a degree in Finance or IT, with strong SQL and VBA skills, and at least 8-10 years of Sage X3 experience. The role includes managing relationships with external partners and supporting financial teams in system usage. Competitive compensation with an equal opportunity employer.

Qualifications

• 8-10 years of Sage X3 support experience, with an understanding of accounting.
• Experience in data analysis and visualization.
• Technical aptitude for system integrations and customizations.

Responsibilities

• Develop automation strategies for financial systems.
• Optimize existing processes and integrate with other systems.
• Provide support and manage external partner relationships.
• Design and develop customizations for the SageX3 ERP system.

Skills

Strong SQL scripting experience

VBA proficiency

Data analysis

Efficacy in financial processes

Education

Degree in Finance or IT

Knowledge of SQL / IT certification

Tools

SageX3

Power BI

Alteryx

Job description

Data Analyst

Job Description

Assume a lead role in developing and implementing automation strategies using the current and future financial systems. Understanding business requirements, translating these to functional specifications and crafting technical solutions used by the developers. Interfacing between business clients and development team regarding business and functional requirements. Ensuring that business requirements are met, building and maintaining strong relationships with clients and acting as a consultant on the application

The candidate should have strong SQL scripting experience as well as the ability to use VBA to expand Excel capabilities to analyze data from SageX3 and other data sources, thus providing insights to improve business performance

Key Outputs

• Optimize existing financial processes by identifying opportunities to use SAGE more efficiently and possibilities of integrations to other business systems.
• Assist internal business users in drawing up business requirements on SAGE.
• Liaising with and managing the external SAGE partner relationship for ongoing SAGE support and project engagements.
• Schedule regular meetings with the Discovery support team and external partner to ensure resolution to open items and updates on projects.
• Providing day to day support to all finance teams using SAGE and other integrated systems.
• Provide support in co-ordinating all system upgrades.
• Facilitate any integration between SAGE and any other financial systems.
• Liaise with auditors and assist with finance system related audits.
• To assist with any other SAGE or related finance system queries and support.
• Design and develop customizations and integrations for the SageX3 ERP system, as well as data models, dashboards, and reports using SQL and data analysis tools such as Power BI, Alteryx, or similar platforms.
• Extract, analyze, and interpret large datasets from SageX3 and other sources to generate meaningful insights and actionable recommendations.

Work Experience

• 8-10 years Sage X3 support experience, with an understanding of accounting

Qualifications

• Degree in Finance or IT
• Knowledge of SQL / IT certification

EMPLOYMENT EQUITY

The Company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.