Senior Data Analyst / Lead Data Analyst

American It Systems; Johannesburg; Hybrid; ZAR 900,000 - 1,300,000; Full time

Benefits offered by this job

Hybrid/Onsite work options

Job summary

American It Systems is seeking a Senior Data Analyst to lead end-to-end data analysis for the AML ODS and Compliance Data Platforms. You will liaison with business, compliance, technology, and data engineering teams to translate regulatory requirements into robust data solutions supporting governance and reporting.

Ideal candidates have 8+ years in data analysis/BA roles within AML or financial services, strong SQL and data governance skills, and experience with ETL, data lineage, and Purview.

Qualifications

• Strong SQL development and data analysis skills.
• Data warehousing and ODS concepts knowledge.
• ETL processes and SSIS experience.
• Data profiling, reconciliation, and data quality management.

Responsibilities

• Engage with stakeholders to gather, analyse, and document requirements.
• Translate requirements into functional/data specs.
• Define business rules, transformation rules, and acceptance criteria.
• Conduct source system analysis, profiling, impact analysis, and gap assessments.
• Produce source-to-target mappings and data lineage documentation.
• Analyze impacts on data models, ETL, dashboards, and governance.

Skills

SQL development

Data analysis

Data warehousing

ODS concepts

ETL processes (SSIS)

Data profiling

Data lineage

Metadata management

Reporting & dashboards

Microsoft Purview

AML/Compliance data environments

Relational databases (SQL Server/OR)**

Education

Bachelor's Degree in Information Systems, Computer Science, Data Analytics, Finance, Business Analysis, or related discipline

CBAP / CDMP / DAMA / Microsoft Data & Analytics Certifications (advantageous)

Tools

SSIS

Microsoft Purview

SQL Server

Oracle

Job description

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.
• 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.
• 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)
• Banking and Financial Services
• Regulatory Reporting
• Transaction Monitoring
• 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.
• 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

Role Level: Senior Data Analyst / Lead Data Analyst
Domain: AML, Compliance Data Platforms & Data Governance
Reporting To: Delivery Lead / Data & Analytics Manager / Compliance Technology Manager
Location: Hybrid / Onsite as required.