Banking & Investment Management | London | Hybrid (4 Days Office-Based) | £600 per day | Long-term Contract
We are seeking an experienced Data Architect / Data Modelling Consultant with a strong background in banking, wealth management or investment management to join a major financial services programme. This is an excellent opportunity to play a key role in shaping the target-state reporting and analytics landscape within a modern cloud-based data platform. This is a data modelling and consulting-focused position, ideal for someone who enjoys working closely with both business and technology stakeholders to design scalable reporting and analytics data models. The role is centred on defining future-state data architecture rather than platform or infrastructure architecture.
Key Responsibilities
- Analyse existing data models and architectures to define target-state reporting and analytics data models.
- Design logical, physical, dimensional and analytical data models using industry best practices.
- Develop scalable data structures to support reporting, business intelligence and advanced analytics.
- Translate complex business, regulatory and reporting requirements into effective data models.
- Collaborate with business and technology stakeholders to deliver robust data solutions.
- Establish data modelling standards, governance frameworks and architectural principles.
- Support the design of modern layered and medallion data architectures.
- Ensure data quality, lineage, governance and regulatory reporting requirements are embedded within data solutions.
- Provide architectural leadership, guidance and consultancy to delivery teams and stakeholders.
Essential Skills & Experience
- Proven commercial experience as a Data Architect, Information Architect or Data Modelling Consultant.
- Strong experience within banking, financial services, wealth management or investment management environments.
- Expert knowledge of dimensional data modelling, including Kimball methodologies.
- Extensive experience designing reporting, analytics and business intelligence data models.
- Strong understanding of modern analytical data architecture, including layered and medallion approaches.
- Experience analysing complex source systems and defining target-state data models.
- Strong SQL skills with the ability to interrogate and analyse complex datasets.
- Excellent stakeholder management, consulting and communication skills.
- Solid understanding of data governance, lineage, data quality and regulatory reporting principles.
Desirable Technical Experience
- Microsoft Azure Fabric
- Azure Data Factory
- Python
- PySpark
- Apache Spark
- Data Vault modelling
- Azure DevOps
- Terraform
- Experience working with regulatory reporting and investment data domains
