Dave McDiarmid

Own the reporting strategy and future roadmap for the function, setting consistent definitions, reporting standards and governance across the estate. Shaped the operating model for C&I dashboard development in QuickSight and authored a tooling whitepaper comparing Power BI, Tableau and AWS QuickSight.

Delivered a retail customer segmentation dashboard and data model spanning all products, with Premier eligibility and core and Premier splits to identify the segments to target for growth. Own the BI and reporting strategy and roadmap for a function built around customer value and profitability model outputs.

Promoted to practice leadership in 2024, with responsibility across a core team of eight alongside line management, then appointed to two consecutive BI leadership roles within NatWest Group inside 12 months.

Continuous consultancy engagement since 2022 across three sequential client mandates. Promoted to Head of Visual & Data Analytics in 2024, holding practice leadership across a core team of eight alongside line management of direct reports.

Led a delivery team of five, a team lead and four Tableau developers, covering Commercial & Institutional and Retail reporting. Designed a new reporting operating model, moving the function from manual, tactical reporting to an automated solution sourcing strategic data from Snowflake into Tableau Cloud.

Led a delivery team of five covering Commercial & Institutional and Retail reporting, setting priorities and developing capability. Led development of the C&I flow of funds dashboard and designed a new reporting operating model and architecture.

Delivery lead and solution architect for moving Basel IV credit risk regulatory reporting from SAS to Tableau, from data provisioning through to PRA and EBA submission. Stood up the client's Tableau capability from nothing and trained permanent staff to run it themselves.

Delivery lead and solution architect for the migration of Basel IV credit risk regulatory reporting from SAS to Tableau, from data provisioning through to PRA and EBA submission, with BCBS 239 embedded throughout. Owned delivery of the Tableau risk reporting suite and defined the target-state architecture.

Requirements gathering, design and proof-of-concept work on a global financial services platform (WinForms front end, Linux / COBOL back end).

Owned the transaction monitoring and fraud metrics within the global financial crime KPI/KRI suite, developing three new fraud metrics and owning six transaction monitoring metrics. Built and maintained an extensive reporting library and taxonomy, and delivered metrics and Qlik dashboards within a complex global reporting structure.

Analysed a 20,000+ case investigation backlog and identified a root-cause pattern of misrouted low-risk cases, designing a new triage process that cut the backlog by over 40%. Built MI reporting on team and individual productivity, presented to global, regional and local stakeholders.

Analysed a 20,000+ case backlog and found that low risk cases were being misrouted. Designed a new triage process with Risk Policy that cut the backlog by over 40% within weeks.

Team workload, forecasting and QA / QC management, with process ownership for AML exits.

AWS Certified Cloud Practitioner certification in progress.

MSc in Transport Planning & Traffic Engineering from Edinburgh Napier University.

BSc (Hons) in Civil Engineering from Edinburgh Napier University.