Discipline 07 / 12 · Analysis, reporting and performance insight

Data Analytics & Management Information.

Data analytics converts operational and risk data into evidence that can guide investigations, control improvements and management decisions. Management information should be accurate, appropriately defined and useful to its audience. This discipline contains five detailed skill profiles, each connected to a practical area of financial-services work.

Discipline overview

Scope and purpose.

Data analytics converts operational and risk data into evidence that can guide investigations, control improvements and management decisions. Management information should be accurate, appropriately defined and useful to its audience.

The discipline requires a clear question, sound data selection, validation, analysis and interpretation. It also requires understanding the limits of a dataset so trends, rates and exceptions are not overstated. In practice, this discipline requires more than familiarity with terminology. It requires an ability to connect policy expectations to real workflows, recognise when available information is insufficient, communicate a proportionate view and maintain evidence that another person can follow. It also needs to connect with adjacent teams so a risk or control issue is not treated as a siloed operational problem.

The five skill profiles in this discipline break the subject into practical capabilities. Each can be opened separately for a detailed explanation, a career example, a working method, role relevance and suggested performance measures.

Areas of expertise

What the discipline covers.

  • 01SQL for risk and transaction data analysis. This is a core component of data analytics & management information: it defines which information matters, which control expectation applies and what evidence is needed before a defensible outcome can be reached.
  • 02Python and Pandas for structured data analysis. The practitioner should test reliability, completeness and consistency, resolve material discrepancies and record why any outstanding gap does or does not change the risk conclusion.
  • 03Power BI and risk dashboards. This component requires context, not mechanical checklist completion. The evidence must be interpreted against the customer, activity, process, policy and risk appetite relevant to the decision.
  • 04Advanced Excel and Power Query. Operationally, clear ownership, traceable records and effective hand-offs help the capability work across teams and make weaknesses visible to the right control owner.
  • 05KPI, KRI, SLA and false-positive analysis. At a more senior level, the work should identify recurring patterns and translate them into improvements to procedures, monitoring, reporting or supporting technology.
Operating approach

How the work is structured.

  1. Translate the business or risk question into a defined data requirement.This stage makes the task specific: identify the decision to be supported, the relevant population, the policy or control objective and the owner who is accountable for the outcome. Clear scope prevents gaps and unnecessary work.
  2. Identify data sources, fields, joins, time periods and population boundaries.For data analytics & management information, review the source information and test whether it is current, relevant, internally consistent and sufficiently reliable. Resolve contradictions or preserve them as explicit exceptions rather than silently assuming they are immaterial.
  3. Validate completeness, consistency and calculation logic.Interpret the information in context. Consider how the result affects customer or transaction risk, operational performance, control coverage and any relevant regulatory obligation. Record uncertainty and explain the basis for the judgement.
  4. Analyse trends, exceptions and performance in context.Where another team, data source or technology is involved, agree the next action, evidence required and expected timing. Escalate dependencies that could affect the control outcome or make the final decision unreliable.
  5. Present findings with definitions, assumptions and implications for action.Close with an outcome that another practitioner can follow: what was reviewed, what was found, what decision was made, who owns the next action and which event should trigger a reassessment.
Career example

Relevant experience.

BNY MellonSenior AML / Prevention / KYC AnalystMar 2022 – Feb 2023

I acted as a subject-matter expert for transaction monitoring, sanctions screening and complex KYC/EDD reviews across multiple regulated entities. I investigated cross-border transactional activity, performed root-cause analysis, held primary escalation responsibility for sanctions and AML cases, provided regulatory interpretation, prepared training materials on AML, sanctions and FATF requirements, and built dashboards covering monitoring volumes, false-positive rates, SLA performance and emerging risk indicators.

This experience is relevant to data analytics & management information because it connects the operating work with risk judgement, evidence quality, control discipline and stakeholder coordination. The example is kept within the responsibilities recorded in the CV; it does not add unverified case facts or numerical outcomes.

Value and measurement

How effectiveness can be assessed.

Useful analytics makes risk and operational performance visible, helps prioritise work and supports decisions based on verified information rather than intuition alone. Performance should be evaluated using a balanced set of quality, timeliness, risk and outcome indicators. The measures below are candidates that can help a team understand whether the discipline is producing reliable results.

Analysis turnaround time

For data analytics & management information, define the population being measured, the evidence required and the point at which a record counts as complete. A useful measure should distinguish a genuine control exception from an expected case variation.

Dashboard refresh reliability

Track this measure over a consistent reporting period and segment it by customer type, product, geography, risk tier or workflow stage where those dimensions are relevant. Segmentation helps locate recurring friction instead of hiding it in an overall average.

Metric accuracy and reconciliation

Pair the measure with a quality check. A faster process is not necessarily a better process if the decision rationale is weak, the data is incomplete or the control has been bypassed. Review the exceptions as well as the headline result.

False-positive and SLA trends

Assign an accountable owner, agree a baseline and document the calculation logic before setting a target. This makes the measure reproducible, useful for management information and suitable for challenge or audit.

These are suggested team-level measures, not claims about personal results. The supplied career documents do not provide verified numeric outcomes for publication.

Technology and information

SQL, Python/Pandas, Power BI, Excel Power Query, Looker, Databricks, Oracle and Snowflake. The right platform should support data quality, process traceability and a clear audit trail. Tool familiarity and implementation ownership should be described separately.

Stakeholder environment

Risk management, financial-crime operations, data specialists, compliance and senior management. Effective delivery requires shared definitions, clear accountabilities and escalation routes that work across functional boundaries.