Senior Data Analyst - AML ODS & Compliance Data Platforms
Job Purpose
The Senior Data Analyst is responsible for providing end-to-end data analysis services across the AML Operational Data Store (AML ODS) and associated Compliance Data Platforms. The role supports strategic initiatives, regulatory programs, data governance, reporting, data quality management, testing, production support, and continuous improvement activities.
The incumbent will serve as the primary liaison between business stakeholders, compliance teams, technology teams, and data engineering teams to ensure business requirements are accurately translated into data solutions that meet regulatory, operational, and governance requirements.
Key Responsibilities
Business and Data Analysis
- Engage with business, compliance, regulatory, and technology stakeholders to gather, analyse, and document requirements.
- Translate business and regulatory requirements into detailed functional and data specifications.
- Define business rules, transformation rules, acceptance criteria, assumptions, dependencies, and exclusions.
- Conduct source system analysis, data discovery, profiling, impact analysis, and gap assessments.
- Produce source-to-target mappings and data lineage documentation.
- Analyse impacts on data models, ETL processes, interfaces, reconciliation controls, dashboards, and downstream systems.
- Facilitate stakeholder workshops, walkthroughs, reviews, and approvals.
Strategic Initiatives and Project Delivery
Support and lead data analysis activities for:
- NICE Actimize Alert and Case Data replication.
- ETL SIT and UAT alignment initiatives.
- Operational reporting and dashboard enhancements.
- EIW 10-Day Look-back reviews.
- Customer Party Rebaseline activities.
- SIL Ingestion Rule prioritisation.
- IFTR Modernisation initiatives.
- SAP CRM discovery and integration assessments.
- Account Type to Party Type remediation.
- Access management and system integration improvements.
- Exclusion rule implementation and optimisation.
- Daily Reconciliation Snapshot enhancements.
- Remittance Data Quality Platform implementation.
- Data governance and protection initiatives.
Data Quality and Governance
- Define and maintain Critical Data Elements (CDEs).
- Develop and manage data quality rules, thresholds, controls, and remediation requirements.
- Perform data quality assessments and profiling.
- Maintain metadata, business glossary, lineage, and data catalogue artefacts.
- Support Microsoft Purview implementation and governance requirements.
- Ensure compliance with retention, destruction, TCR, audit, and regulatory requirements.
- Drive data governance best practices and standards.
Testing and Validation
- Develop SIT, UAT, regression, and production validation test scenarios.
- Create expected results and reconciliation requirements.
- Support defect management and root-cause analysis.
- Validate ETL, SQL, SSIS, reporting, and transformation outputs.
- Perform implementation validation and post-deployment verification.
- Ensure traceability between requirements, testing, and acceptance criteria.
Production Support and Operational Excellence
- Monitor data loads, reconciliations, reporting outputs, and batch processing results.
- Investigate incidents, failed ETL jobs, data quality issues, and reporting discrepancies.
- Conduct root-cause analysis and impact assessments.
- Define corrective and preventative actions.
- Support production releases and change validation activities.
- Maintain operational support documentation and audit evidence.
Continuous Improvement
- Identify automation opportunities and process improvements.
- Reduce technical debt through enhanced controls and monitoring.
- Improve reconciliation, validation, and reporting processes.
- Promote data quality and governance maturity across platforms.
Required Skills and Experience
Technical Skills
- Strong SQL development and data analysis skills.
- Data warehousing and Operational Data Store (ODS) concepts.
- ETL processes and tools (SSIS preferred).
- Data profiling, reconciliation, and data quality management.
- Data lineage and metadata management.
- Reporting and dashboard analysis.
- Microsoft Purview knowledge.
- Data governance frameworks and controls.
- AML and Compliance data environments.
- Experience with relational databases such as SQL Server, Oracle, or similar platforms.
Business Skills
- Requirements elicitation and stakeholder management.
- Business process analysis.
- Regulatory and compliance analysis.
- Risk and impact assessment.
- Test management and validation.
- Root cause analysis.
- Documentation and presentation skills.
Preferred Domain Experience
- Anti-Money Laundering (AML)
- Financial Crime Compliance
- Banking and Financial Services
- Regulatory Reporting
- Transaction Monitoring
- Customer Due Diligence (CDD)
- KYC and Financial Crime Controls
Qualifications
- Bachelor's Degree in Information Systems, Computer Science, Data Analytics, Finance, Business Analysis, or a related discipline.
- Relevant certifications advantageous:
- CBAP (Certified Business Analysis Professional)
- CDMP (Certified Data Management Professional)
- DAMA Data Management Certification
- Microsoft Data and Analytics Certifications
- AML or Financial Crime certifications
Experience
- 8+ years of Data Analysis or Business Analysis experience.
- 5+ years within Banking, AML, Compliance, Risk, or Financial Services.
- Proven experience delivering large-scale data transformation and regulatory initiatives.
- Experience working across Agile, Waterfall, and DevOps delivery environments.
- Strong stakeholder engagement experience across Business, Compliance, Technology, and Operations teams.
Key Deliverables
- Business Requirements Specifications (BRS)
- Functional Requirements Specifications (FRS)
- Source-to-Target Mapping Documents
- Data Lineage and Metadata Artefacts
- Data Quality Rule Catalogues
- Reconciliation Specifications
- Impact Assessment Reports
- Data Profiling Reports
- Test Scenarios and Traceability Matrices
- SIT, UAT and Production Validation Reports
- Root Cause Analysis Reports
- Governance and Audit Artefacts
- Stakeholder Sign-off Documentation