Data Solutions Architect

Company: Tesco Insurance
Apply for the Data Solutions Architect
Location: City of Edinburgh
Job Description:

Serving our customers, communities, and planet a little better every day.

Applications close 23rd June at 5pm.

What you’ll be doing

  • Define and own data architecture patterns, standards and target state designs for our Microsoft Fabric platform, ensuring consistency across ingestion, storage, semantic modelling and consumption layers.
  • Lead the design and governance of enterprise and domain data models, from conceptual and logical models through to physical implementations optimised for Fabric (Lakehouse, Warehouse and semantic models).
  • Partner with data engineers, analytics engineers and platform teams to ensure data models are correctly implemented, performant and aligned to architectural intent.
  • Shape and assure the semantic layer (e.g. shared dimensions, facts and metrics), enabling trusted, reusable analytics and reducing duplication across teams.
  • Work with Product, Business and Data Owners to translate business concepts, KPIs and regulatory requirements into clear, well governed data structures.
  • Embed data quality, lineage, metadata and lifecycle management into all designs, aligned to data governance, privacy and regulatory obligations.
  • Provide architectural assurance across change initiatives, balancing speed of delivery with long term data integrity, resilience and operational sustainability.
  • Mentor and coach engineers and analysts on data modelling best practice, raising overall data architecture maturity across the organisation.

We need you to have

  • Proven experience as a Data Architect working across modern analytics and data platforms.
  • Strong, hands‑on expertise in data modelling, including:
    • Conceptual and logical enterprise data models
    • Dimensional modelling (facts, dimensions, star/snowflake schemas)
    • Experience designing semantic layers for self‑service analytics
  • Experience designing data architectures on cloud-based platforms, ideally Microsoft Fabric, Azure Synapse, or equivalent lakehouse style platforms.
  • Deep understanding of how data models support analytics, reporting, AI/ML and operational use cases, not just storage.
  • Ability to work effectively in Agile and product led environments, providing clear architectural direction without becoming a delivery bottleneck.
  • Strong stakeholder engagement skills, with the ability to explain complex data concepts clearly to both technical and non‑technical audiences.

And if you have any of these, even better

  • Experience working in regulated or customer critical environments (e.g. financial services, insurance), with an understanding of data risk, privacy and regulatory constraints.
  • Knowledge of Microsoft Fabric components such as Lakehouse, Warehouse, Data Factory, OneLake and Power BI semantic models.
  • Experience aligning data architecture with data governance, ownership models and operating frameworks.
  • Background supporting or enabling AI / advanced analytics through well designed data foundations.

What’s in it for you

  • Colleague pension scheme to support your future.
  • Private Medical Insurance (WL2+) and Virtual GP service for you and your family.
  • Performance related annual bonus.
  • Generous holiday allowance – minimum 7.2 weeks, with options to buy more.
  • Colleague Clubcard with up to 15% discount and a second card to share.
  • Enhanced family friendly policies, including maternity, shared parental and paternity leave.
  • Access to award winning learning and development opportunities to support your long‑term career.
  • Buy as You Earn and Save As You Earn share schemes.

Everyone’s welcome

We want all our colleagues to feel welcome and be themselves. We’re committed to building a more inclusive workplace and celebrating the diversity that makes us stronger.

#J-18808-Ljbffr…

Posted: June 12th, 2026