Enter a job title or keyword
Data Solutions Architect
Job Location:
Yearly Salary:
Posted:
10 October 2026 (Yesterday)
Posted:
Application Deadline:
7 January 2027
Application Deadline:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
General information
Job Title
Data Solutions Architect
Ref #
9532
Location
Edinburgh - 2 South Gyle Crescent Edinburgh EH12 9FQ
Department
IMS - Architecture
Business Area
Architecture
Working time
Full-Time
Date Published
0
Serving our customers communities and planet a little better every day.
Salary - Between 80000 - 90000 (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
Why this role
Were 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. Youll 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. Youll 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.
What youll 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.
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.
What were looking for (minimum criteria)
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 defining data solutions for AI machine learning or conversational/ NLQ analytics capabilities
Background supporting or enabling AI/ advanced analytics through well designed data foundations
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.
We welcome applications from everyone. If youre excited about this role but your experience doesnt align perfectly with every requirement wed still love to hear from you.
Whats in it for you
A generous pension with up to 7.5% employer contribution depending on what you put in.
Private Medical Insurance (WL2) and virtual GP Service for you and your family
Performance related annual bonus.
7.2 weeks holiday with the opportunity to buy more.
Colleague Clubcard discount (10-15% second card to share with someone else).
Enhanced parental leave.
Opportunities to Save and Buy as you earn.
A place to get on - take advantage of our ongoing learning opportunities to help you achieve the job and career you want.
Interviews
As a Disability Confident Employer (Level 2) were committed to creating an accessible and supportive environment for all. We offer reasonable adjustments throughout the recruitment process including interviews to ensure every candidate has a fair opportunity to succeed.
We also know the importance of balancing work with lifes other commitments. Please talk to us at interview about the flexibility you need as were committed to exploring part time and flexible working opportunities at every level of the organisation.
Interviews are expected to be held shortly after closing date.
Dont miss out. Were assessing applications throughout the recruitment process and may close this opportunity ahead of the closing date if we receive a high volume of applications.
Why Tesco Insurance and Money Services
Seeing your impact all around you: theres no better feeling.
Everything we do is about making things better. Not just for others but for you too. Its why youll get bags of choice and plenty of development. Its why youll always be heard and find balance that works for you. Its why youll feel totally at home in a place where everyones welcome.
Lucky for us we get to feel it all the time. Because whatever our role were helping our colleagues and serving our customers communities and planet a little better every day.
We deal in the personal from pet insurance for your best friend and home insurance for peace of mind to motor insurance for your dream car or travel money for that trip youve worked hard for.
We deal in the personal from pet insurance for your best friend and home insurance for peace of mind to motor insurance for your dream car or travel money for that trip youve worked hard for.
Everything we do is about making things better. Not just for others but for you too. Its why youll get bags of choice and plenty of development. Its why youll always be heard and find balance that works for you. Its why youll feel totally at home in a place where everyones welcome.
So if you want a career where you can do good and feel good youve found it.
Lets make everyday a little better.
Lets make everyday a little better.
Our story
Making Insurance and Money Services more rewarding and offering great value and choice - because we know little wins can make a big difference.
Delivering great customer service means having great people behind the scenes people who understand our customers and are driven by doing the right thing for them. We offer colleagues a place where they can feel totally at home in a place where everyones welcome where they can be part of a great team focused on making a real difference for our customers.
We began life in 1997 and now help more than 2 million customers protect what matters to them.
We want to deliver a helpful service in everything we do and to make life easier for our customers. Our policies are really easy to manage online for our customers but we know that being able to speak to our customer service staff when you need to is really important. This is why our customer service centres are open seven days a week.
We want to deliver a helpful service in everything we do and to make life easier for our customers. Our policies are really easy to manage online for our customers but we know that being able to speak to our customer service staff when you need to is really important. This is why our customer service centres are open seven days a week.
Delivering great customer service means having great people behind the scenes people who understand our customers and are driven by doing the right thing for them. We offer colleagues a place where they can feel totally at home in a place where everyones welcome where they can be part of a great team focused on making a real difference for our customers.
How to apply
We value our people and diverse teams and believe the variety of backgrounds and experiences make us stronger to achieve our goals.
Our colleagues are working hybrid taking time to meet with colleagues in our offices for moments that matter such as team catch ups planning meetings and more. If youre interested in finding out more about what a career at Tesco Insurance and Money Services looks like click apply to find out more!
Required Experience:
Staff IC
About Company
Welcome to Tesco online. Discover great value groceries, plus clothing, recipes, bank, and mobile services. Browse on Tesco.com now!
