Operational Technical Data Quality Analyst (11934) at Investec

Description

• This role specialises in data quality issue management including issue identification, data profiling, data cleanup and data quality issue prevention under guidance of data governance practices and in collaboration with team, data owners and data stewards.

Responsibilities:

Data Quality Tools Management:

• Liaison with tech partners to ensure tools function as required in support of data quality and governance work.
• Optimizing tools used for data quality and data governance within Private Bank in support of team objectives.
• Establishing and maintaining standards to ensure tools are used effectively and efficiently.
• Assist with training and adoption of new tools within the Data Ops Team.

Data Quality Tracking and Issue Identification: 

• Understand and contribute to the Private Bank (PB) Data Quality Tracking Model (DQTM) [Microsoft SQL code]. 
• Contribute to new data quality tool implementations.
• Acquire new data into the DQTM employing relevant ETL tools.
• Support the DQTM through monitoring control-m job execution in support week and resolving data issues/requests.
• Perform additional data quality analysis and build dashboards as required. [Power BI]

Data Quality Issue Cleanups: 

• Acquire solid business understanding of relevant data.
• Prepare data for cleanup following agreed procedures.
• Follow the System Development Lifecycle (SDLC) process agreed per platform to update data in the source [Oracle Sequel].  
• Perform regular and manual cleanups following agreed governance processes with full stakeholder involvement
• Ad Hoc requests: Investigate data quality requests during support week and manage the shared mailbox during this week following team guidelines.

Data Quality Practitioner per Specified Source System:

• Continuously improve data quality for assigned sources in collaboration with your team and the data stewards following the new data quality model.
• Gain a solid business understanding of the source system data and ERD (Entity Relationship Diagram) as well as an understanding of the related business processes.

Other activities:

• Contribute to the establishment and refinement of quality processes and prepare reports on data and meta data quality for the data community as required.
• Contribute to the understanding of data by updating business data glossaries and other relevant data quality artefacts as required and within the agreed community guidelines.
• Continuously enhance own knowledge of the data in Private Bank and Investec Group where relevant including the tools within our domain

Skill and experience:

• Excellent problem-solving skills    
• Very good communication and collaboration skills 
• Strong writing skills 
• SQL query writing experience
• Knowledge of Private Bank systems is preferred
• Power BI skill is preferred
• Any data steward experience is advantageous
• Systems development/testing or data integration experience is advantageous

Qualifications:

• Information management, Computer Science, or other relevant degree

Personal Attributes:

• A self-starter who works well in a team and drives own learning.   
• Ability to work collaboratively with various stakeholders.
• Accurate in the detail and effective in the big picture
• Analytical with excellent problem-solving ability