Data Architect

Company: Pharos Resource Partners
Apply for the Data Architect
Location: London
Job Description:

About the Role

We are seeking an experienced Data Architect / Data Modelling Consultant to design and shape the enterprise data architecture underpinning our investment platform. This is a high-impact role for someone who combines deep technical data architecture expertise with a strong understanding of the asset management data landscape (securities, positions, transactions, benchmarks, pricing, risk, and performance data)

Key Responsibilities

  • Design and own the conceptual, logical, and physical data models underpinning core investment data domains (instruments, positions, transactions, holdings, pricing, benchmarks, risk, performance, client/account data)
  • Define and evolve the firm’s data architecture strategy, including data warehouse/lake design, data mesh or domain-oriented approaches, and integration patterns
  • Establish data modelling standards, naming conventions, and governance practices across the organisation
  • Partner with portfolio management, risk, compliance, and operations teams to understand data requirements and translate them into scalable architecture
  • Work closely with engineering teams to implement data pipelines, master/reference data solutions, and data quality frameworks
  • Lead or support evaluation and selection of data platforms and tools (cloud data warehouses, data catalogues, MDM solutions)
  • Ensure data architecture supports regulatory, risk, and reporting requirements (e.g., performance reporting, look-through, regulatory reporting)
  • Produce clear architecture documentation, data dictionaries, and data lineage/mapping artefacts
  • Provide thought leadership and mentoring to data engineers and analysts on modelling best practice
  • Support data governance initiatives, including data quality, metadata management, and stewardship processes

What We’re Looking For

  • Proven experience as a Data Architect / Data Modeller within asset management, investment banking, or financial services
  • Strong understanding of investment data domains: instruments/securities, positions, transactions, corporate actions, pricing, benchmarks, risk, and performance data
  • Expertise in data modelling techniques (conceptual, logical, physical; dimensional modelling, normalisation, entity-relationship modelling)
  • Hands‑on experience with modern data platforms (e.g., Snowflake, Databricks, BigQuery, Azure Synapse) and data warehouse/lakehouse architectures
  • Strong SQL skills and experience with data modelling tools (e.g., ERwin, ER/Studio, dbt, SQL DBM)
  • Familiarity with industry data standards and vendor data models (e.g., FIX, FpML, Bloomberg, SimCorp, GoldenSource, RIMES, FINBOURNE/LUSID)
  • Experience with data governance, MDM, and metadata/lineage tools (e.g., Collibra, Alation, Informatica)
  • Excellent stakeholder management skills, able to bridge business and technical teams
  • Strong documentation skills, including data dictionaries, ERDs, and architecture diagrams

#J-18808-Ljbffr…

Posted: August 9th, 2026