Data Architect 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 ResponsibilitiesAnalyse 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 & ExperienceProven 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 ExperienceMicrosoft Azure FabricAzure Data FactoryPythonPySparkApache SparkDesirable SkillsData Vault modellingAzure DevOpsTerraformExperience working with regulatory reporting and investment data domains
Michelle Sutherland