We are seeking an experienced Data Architect/Data Modelling Consultant with a strong banking and investment management background to lead the design of target-state reporting and analytics data models within a modern cloud-based data platform. This role is 4 day onsite in London with 1 day remote. The role is INSIDE IR35

The successful candidate will work closely with business and technology stakeholders to understand reporting and analytical requirements, analyse existing data structures, define target-state data models and establish best-practice approaches for data consumption across regulatory reporting, management information, analytics and business intelligence.

Working as part of an Agile delivery team, you will contribute incrementally to the target-state data model as solutions are developed and deployed, rather than undertaking a standalone discovery or design phase.

This is primarily a data modelling and consulting-focused role rather than a platform or infrastructure architecture position.

Key Responsibilities

* Analyse existing data models and architectures and define target-state reporting and analytics models.
* Design dimensional, analytical and reporting data models using industry best practices.
* Define and optimise data structures for reporting, Business Intelligence and analytics.
* Work closely with business and technology stakeholders to translate requirements into scalable data solutions.
* Establish data modelling standards, governance and architectural principles.
* Support the design of medallion/layered data architectures and data consumption patterns.
* Ensure data quality, lineage, governance and regulatory reporting requirements are considered.
* Provide architectural leadership and consultancy to delivery teams and stakeholders.
* Translate complex business and reporting requirements into logical and physical data models.
* Work as an active member of Agile sprint teams, delivering incremental data modelling changes aligned to sprint objectives.

Essential Skills & Experience

* Strong commercial experience as a Data Architect, Information Architect or Data Modelling Consultant.
* Significant experience within banking, wealth management, investment management or other financial services environments.
* Expert-level dimensional modelling skills, including Kimball methodologies.
* Experience designing reporting, analytics and Business Intelligence data models.
* Strong understanding of medallion, layered and modern analytical data architecture approaches.
* Experience defining target-state data models from complex existing source systems.
* Strong SQL skills and ability to analyse complex datasets.
* Strong stakeholder engagement, consulting and communication skills.
* Good understanding of data governance, lineage, quality and regulatory reporting requirements.
* Experience working within Agile delivery teams, with the ability to deliver incremental data modelling solutions in collaboration with engineering teams.

Technical Environment (Desirable)

* Microsoft Fabric.
* Azure Data Factory.
* Python.
* PySpark.
* Apache Spark.

Desirable Skills

* Azure DevOps.

Advise on rates and availability on application

WA Consultants is an Employment Business and an Employment Agency as described within The Conduct of Employment Agencies and Employment Businesses Regulations 2003.