Operational Reference Data Analyst

Standardbankgroup; Johannesburg; Sur place; ZAR 480 000 - 560 000; Plein temps

Résumé du poste

Standardbankgroup is seeking an Operational Reference Data Analyst in Johannesburg to manage and validate reference data across multiple systems. The role emphasizes data quality, governance, and supporting system enhancements.

You will generate analytics, maintain audit trails, and collaborate with stakeholders to ensure data integrity. The position requires proficiency in SQL, Excel, and Power BI, with experience in data management and reporting within regulated environments.

Qualifications

• Matric, Diploma, Degree or Postgraduate qualification in Data Analytics, Finance, Risk Management, or Business Analytics.
• Building and maintaining OSD data-quality dashboards.
• Monitoring data publication from CIF to OSD and reporting data discrepancies.
• Tracking remediation of identified discrepancies and exceptions.
• Monitoring OSD data against agreed standards and business rules.
• Refreshing Power BI dashboards and resolving refresh failures.
• Administering access to Reservoir/Lakehouse and conducting quarterly reviews.
• Providing data support for Operational Incident Management.
• Proven experience in data analysis, data management, or a related analytical role.
• Proficiency in SQL and advanced Microsoft Excel for data manipulation and analysis.
• Strong attention to detail and excellent organizational skills.
• Experience with data governance frameworks and MDM platforms.
• Familiarity with data visualization tools such as Tableau or Power BI.

Responsabilités

• Maintain and manage operational reference data across systems, ensuring consistency and accuracy.
• Perform data quality assurance and validation checks to identify discrepancies.
• Analyse data issues and implement corrective actions to resolve anomalies.
• Document data processes, governance standards and compliance requirements.
• Collaborate with cross-functional stakeholders to understand data requirements.
• Generate reports and analytics on data integrity metrics and quality performance.
• Support system implementations, data migrations and data cleansing initiatives.
• Maintain audit trails and records of data changes for compliance.

Connaissances

SQL

Power BI

Excel

Data analysis

Data governance

MDM

Data quality

Tableau

Formation

Matric or equivalent

Diploma/Degree in Data Analytics, Finance, Risk Management, or Business Analytics

Outils

Tableau

Power BI

SQL

Excel

Description du poste

We are seeking an Operational Reference Data Analyst to join our organisation in Johannesburg, South Africa. In this Contract position, you will play a crucial role in maintaining the integrity and accuracy of our operational reference data. The successful candidate will be responsible for managing, validating, and optimising reference data across our systems, ensuring that all data meets our stringent quality standards and supports effective business operations.

• - Maintain and manage operational reference data across multiple systems and databases, ensuring consistency and accuracy
• Perform comprehensive data quality assurance and validation checks to identify and rectify discrepancies
• Analyse data issues and implement corrective actions to resolve data anomalies and inconsistencies
• Document data processes, procedures, and governance standards to ensure organisational compliance
• Collaborate with cross-functional stakeholders to understand data requirements and support system enhancements
• Generate detailed reports and analytics on data integrity metrics and quality performance
• Support system implementations, data migrations, and reference data cleansing initiatives
• Ensure adherence to data governance frameworks and regulatory requirements
• Maintain detailed records of data changes and maintain audit trails for compliance purposes
• Provide technical support and guidance to end-users regarding reference data queries and issues

Matric, Diploma, Degree or Postgraduate qualification in Data Analytics, Finance, Risk Management, or Business Analytics

Experience Required

• Building and maintaining OSD data-quality dashboards.
• Monitoring data publication from CIF to OSD and reporting data discrepancies.
• Tracking remediation of identified discrepancies and exceptions.
• Monitoring OSD data against agreed standards and business rules, including completeness, correctness, consistency and timeliness.
• Refreshing and monitoring Power BI dashboards, resolving scheduled-refresh failures, and consolidating critical exceptions for weekly reporting.
• Supporting applicable data requests and administering access to the Reservoir/Lakehouse, including quarterly access reviews.
• Providing data support for Operational Incident Management.
• Proven experience in data analysis, data management, or a related analytical role
• Proficiency in SQL and advanced Microsoft Excel for data manipulation and analysis
• Strong attention to detail with exceptional organisational abilities
• Excellent problem-solving skills and analytical mindset
• Demonstrated ability to work with large datasets and identify patterns or anomalies
• Strong written and verbal communication skills
• Ability to work independently and collaboratively within a team environment
• Experience with data quality assurance and validation processes
• Experience with reference data management systems or master data management (MDM) platforms
• Knowledge of data governance frameworks and best practices
• Familiarity with financial systems, operational systems, or enterprise resource planning (ERP) environments
• Experience with data visualisation tools such as Tableau or Power BI
• Project management experience or exposure to data-related projects
• Understanding of database structures and data architecture principles
• Experience working in a regulated industry or compliance-focused environment