JOB PURPOSE

The Manager – Testing (Data & Analytics) is responsible for planning and executing independent, data-driven Second Line testing of regulatory and financial crime controls. The role applies SQL and analytics to test full populations, validates data integrity, documents evidence-based findings and root causes, and supports independent validation of remediation in line with the approved testing methodology

KEY RESPONSIBILITIES

• Plan and execute assigned independent compliance testing engagements and risk-based control assessments.
• Write SQL queries and Python, R or SAS scripts for population analysis, sampling and exception detection.
• Reconcile source data, test completeness, document extraction logic and ensure reproducibility.
• Test KYC, CDD/EDD, UBO, customer risk rating, transaction monitoring, sanctions screening and regulatory reporting controls.
• Validate exceptions, analyse root causes, document evidence and recommend remediation.
• Maintain dashboards, scripts, version control, quality-assured working papers and secure data handling.
• Supervise and coach analysts and deliver assignments to agreed timelines.

KEY ACCOUNTABILITIES

• Prepare test plans, scoping documents and test scripts in line with the approved testing methodology.
• Develop accurate, documented and reusable SQL and analytics scripts for testing.
• Reconcile extracted data to source systems and document data completeness and accuracy checks.
• Perform full-population and sample-based testing of financial crime and regulatory controls.
• Validate exceptions with control owners and confirm the accuracy of findings before reporting.
• Perform root cause analysis and propose practical remediation recommendations.
• Prepare quality-assured working papers that support reperformance and independent review.
• Draft testing reports with clear findings, severity ratings and agreed management actions.
• Validate remediation evidence and support independent closure of findings.
• Maintain dashboards and continuous monitoring routines assigned to the team.
• Ensure secure handling, storage and disposal of customer and confidential data in line with the Data Protection Act and Bank policies.
• Supervise and coach analysts and maintain quality standards for team outputs.

CORE COMPETENCIES AND SKILLS

• Good knowledge of Kenyan banking regulation, AML/CFT/CPF requirements and financial crime controls.
• Strong practical SQL capability and proficiency in Python, R, SAS or comparable analytics tools.
• Working knowledge of Power BI or similar data visualisation tools.
• Understanding of statistical sampling, data reconciliation and reproducible testing.
• Strong analytical, problem-solving and attention-to-detail capabilities.
• Clear working paper documentation and report writing skills.
• Effective stakeholder engagement and constructive challenge capability.
• Supervisory, coaching and team development skills.
• High integrity, independence and professional scepticism.

EXPERIENCE

• Minimum 7 years’ experience in Compliance Testing, Internal Audit, Financial Crime Compliance, Risk or Data Analytics within the financial services sector.
• At least 3 years’ experience in a supervisory or senior specialist role.
• Demonstrated experience executing data-driven control testing using SQL and analytics tools.
• Experience documenting evidence-based findings and validating remediation.
• Prior experience in a Tier 1 bank and familiarity with CBK and FRC supervisory expectations will be an added advantage.

ACADEMIC AND PROFESSIONAL QUALIFICATIONS

• Bachelor’s degree in finance, Accounting, Economics, Statistics, Computer Science, Information Systems, Data Science or a related field.
• Master’s degree in a relevant discipline will be an added advantage.
• Professional certifications such as CISA, CIA, CAMS, CPA(K) or recognised data analytics certifications.
• Demonstrated commitment to continuous professional development in compliance testing and data analytics.

• Plan and execute assigned independent compliance testing engagements and risk-based control assessments.
• Write SQL queries and Python, R or SAS scripts for population analysis, sampling and exception detection.
• Reconcile source data, test completeness, document extraction logic and ensure reproducibility.
• Test KYC, CDD/EDD, UBO, customer risk rating, transaction monitoring, sanctions screening and regulatory reporting controls.
• Validate exceptions, analyse root causes, document evidence and recommend remediation.
• Maintain dashboards, scripts, version control, quality-assured working papers and secure data handling.
• Supervise and coach analysts and deliver assignments to agreed timelines.
• Prepare test plans, scoping documents and test scripts in line with the approved testing methodology.
• Develop accurate, documented and reusable SQL and analytics scripts for testing.
• Reconcile extracted data to source systems and document data completeness and accuracy checks.
• Perform full-population and sample-based testing of financial crime and regulatory controls.
• Validate exceptions with control owners and confirm the accuracy of findings before reporting.
• Perform root cause analysis and propose practical remediation recommendations.
• Prepare quality-assured working papers that support reperformance and independent review.
• Draft testing reports with clear findings, severity ratings and agreed management actions.
• Validate remediation evidence and support independent closure of findings.
• Maintain dashboards and continuous monitoring routines assigned to the team.
• Ensure secure handling, storage and disposal of customer and confidential data in line with the Data Protection Act and Bank policies.
• Supervise and coach analysts and maintain quality standards for team outputs.

• Good knowledge of Kenyan banking regulation, AML/CFT/CPF requirements and financial crime controls.
• Strong practical SQL capability and proficiency in Python, R, SAS or comparable analytics tools.
• Working knowledge of Power BI or similar data visualisation tools.
• Understanding of statistical sampling, data reconciliation and reproducible testing.
• Strong analytical, problem-solving and attention-to-detail capabilities.
• Clear working paper documentation and report writing skills.
• Effective stakeholder engagement and constructive challenge capability.
• Supervisory, coaching and team development skills.
• High integrity, independence and professional scepticism.

• Bachelor’s degree in finance, Accounting, Economics, Statistics, Computer Science, Information Systems, Data Science or a related field.
• Master’s degree in a relevant discipline will be an added advantage.
• Professional certifications such as CISA, CIA, CAMS, CPA(K) or recognised data analytics certifications.
• Demonstrated commitment to continuous professional development in compliance testing and data analytics.