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.

Skills & Competencies

Strong analytical/problem-solving skills; attention to detail and data integrity.

Proficiency in Excel (advanced formulas, pivot tables), advanced MSSQL including the use of DDL , DML and TCL commands within the constraints of the role with robust testing/QA of all production scripts and familiarity with SSIS/ETL flows.

Develop Stored procedures to further detect and trigger automated correction of erroneous data within Production and Live SQL Servers.

Understanding of data quality frameworks, data governance, and regulatory expectations.

Data Quality Analyst

Responsibilities

Company

Cube

More roles at Cube