Data Solutions Architect

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

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

Salary - Between £80,000 - £90,000 (DOE) + annual bonus & benefits

Work Level - 2

Location – Edinburgh, Permanent

Office Attendance – Our hybrid working model gives you the best of both worlds - flexibility to work from home and valuable face‑to‑face time with colleagues. This role typically requires 2 days per week onsite.

Closing Date - Applications close on 22nd October at 5pm

We’re looking for a Data Solutions Architect to play a key role in shaping and delivering data services utilising our new Microsoft Fabric data platform within Tesco Insurance and Money Services. This is a pivotal role at a critical point in our data journey. You’ll provide key technical and architectural skills across data modelling, analytics and platform design, ensuring our data foundations are robust, governed and built for long term use.

You’ll work closely with engineers, analysts, product teams and senior stakeholders to translate business and regulatory needs into clear, scalable data architectures.

The role combines strategic design with a particular focus on high quality conceptual, logical and physical data models that underpin analytics, reporting, AI and operational use cases across the organisation.

• 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.
• Develop next‑generation platform capabilities, including real‑time ingestion, AI‑driven insights and API‑led integration
• 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.

• Proven experience as a Data Architect working across modern analytics and data platforms.
• Strong, hands‑on expertise in data modelling, including:
• o Conceptual and logical enterprise data models
• o Dimensional modelling (facts, dimensions, star/snowflake schemas)
• o 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…