Key Responsibilities
• Profile data, design and execute data quality rules, and monitor scorecards and dashboards to identify issues, trends, and areas requiring corrective action.
• Investigate data anomalies and root causes using Excel, MSSQ and SSIS, assessing the impact of data issues and determining appropriate remediation steps against the production golden data source and LIVE customer facing databases
• Apply controlled corrections to data where required, ensuring changes are accurate, authorised, traceable, and completed in line with agreed governance standards, approval processes, and audit requirements.
• Design and implement improvements to the existing data ingestion pipelines and post load validation to increase efficiency and reduce risk of pipeline failures.
• Support remediation activity through SSIS/ETL workflows, working with technology teams to ensure data fixes are implemented safely and consistently across relevant systems.
• Maintain documentation for data quality rules, thresholds, lineage, controlled correction procedures, remediation actions, and operating processes.
• Collaborate with business, technology, and compliance teams to align data quality activity, remediation approaches, and controlled data corrections with regulatory and operational needs.