Tesco Insurance • Edinburgh - 2 South Gyle Crescent, Edinburgh, EH12 9FQ, United Kingdom • Permanent • Apply by 06-May-2026
Salary - Between £80,000 - £90,000 + annual bonus & benefits
Work Level - 2
Location - Edinburgh, Permanent
Office Attendance - Our roles are hybrid; however, you should be able to travel to our Edinburgh office 2 days per week for this position.
Closing Date - Applications close 6th May 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:
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 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.
#J-18808-Ljbffr