Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and architecture of data warehouses, ensuring optimal performance and scalability.
- Company: Dynamic tech firm focused on innovative data solutions.
- Benefits: Competitive daily rate, hybrid working, and potential for long-term engagement.
- Why this job: Shape the future of data architecture and make a significant impact in a fast-paced environment.
- Qualifications: Experience in data warehousing and strong architectural skills required.
- Other info: Opportunity for travel to London and collaboration with industry leaders.
The predicted salary is between 84000 - 90000 £ per year.
Check below to see if you have what is needed for this opportunity, and if so, make an application asap.
Contract: 6 week initial engagement
Location: Hybrid working - likely to be some travel to London required
Rate: £700pd-£750pd (outside IR35)
We are currently recruiting for a Data Warehouse Architect who can come in and provide a DWH assessment. You will be responsible for assessing the DWH landscape and providing direction, deliverables and outcomes. This is due to be a 6-week engagement with the chance of it becoming a longer term piece of work.
Core Responsibilities:- Own logical and physical data warehouse architecture from ingestion to consumption
- Define target state architecture and roadmaps for enterprise data platforms
- Design modern data warehouse patterns using medallion architecture: Bronze, Silver, Gold
- Define canonical data models, conformed dimensions and domain boundaries
- Set Master Data Management strategy including golden records, matching and governance
- Define integration patterns for batch, streaming and API based data movement
- Establish non-functional requirements covering performance, security, scalability and cost
- Architect solutions on Microsoft Fabric at platform and solution level
- Define appropriate use of Lakehouse, Warehouse, OneLake and semantic models
- Set standards for data pipelines, notebooks and orchestration patterns
- Define medallion layer responsibilities and data contracts between layers
- Govern Power BI semantic models, Direct Lake usage and enterprise BI patterns
- Define security architecture using Entra ID, RLS, FLS and workspace separation
- Define enterprise MDM architecture and operating model
- Set standards for data domains, ownership, stewardship and controls
- Define data quality frameworks, reference data management and issue management
- Define enterprise BI and semantic layer architecture
- Set standards for KPI metric definition and reuse across the organisation
- Enable advanced analytics and data science consumption from curated layers
- Ensure consistency, usability and performance of analytical models
- Source system classification and data contracts
- Ingestion and landing architecture
- Standardisation, validation and data quality layers
- Master and reference data integration
- Analytical and dimensional modelling approaches
- Semantic layer and BI consumption patterns
- Metadata lineage, observability and monitoring
- Act as architectural authority and design reviewer
- Produce architecture artefacts, principles and standards
- Translate business strategy into scalable data architectures
- Work with engineers, product owners and business leaders to govern delivery
The role will require travel to London and will be hybrid working, please consider this when applying for the role.
Due to the time-frames required for the engagement, you must be available to start a new role as soon as required.
If you are interested in the role and would like to apply, please click on the link to be considered.
Data Warehouse Architect in London employer: TXP
Contact Detail:
TXP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Architect in London
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the data warehouse game. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Show Off Your Skills
When you land that interview, don’t just talk about your experience—show it! Bring along a portfolio of your past projects or case studies that highlight your expertise in data warehousing. This will help us see how you can add value to our team.
✨Tailor Your Approach
Make sure to tailor your pitch to the specific role of Data Warehouse Architect. Highlight your experience with Microsoft Fabric, medallion architecture, and any relevant MDM strategies. We want to see how your skills align with what we’re looking for!
✨Apply Through Our Website
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining our team and ready to dive into this exciting opportunity.
We think you need these skills to ace Data Warehouse Architect in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Warehouse Architect role. Highlight relevant experience and skills that match the job description, especially around data architecture and Microsoft Fabric.
Craft a Compelling Cover Letter: Your cover letter should tell us why you're the perfect fit for this role. Share specific examples of your past work that align with the responsibilities listed in the job description.
Showcase Your Technical Skills: Don’t forget to mention your technical skills! We want to see your expertise in data modelling, MDM strategies, and any experience with BI tools like Power BI. Be specific!
Apply Through Our Website: For the best chance of success, make sure to apply through our website. It’s the quickest way for us to get your application and start the conversation!
How to prepare for a job interview at TXP
✨Know Your Data Warehouse Architecture
Make sure you brush up on your knowledge of data warehouse architecture, especially the medallion architecture. Be ready to discuss how you've designed and implemented similar systems in the past, as this will show your expertise and understanding of the role.
✨Prepare for Technical Questions
Expect technical questions about integration patterns, data models, and performance requirements. We recommend practising your responses to common scenarios, like defining a Master Data Management strategy or explaining your approach to data quality frameworks.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss specific challenges you've faced in previous roles and how you overcame them. This could involve anything from establishing non-functional requirements to ensuring data governance. Use the STAR method (Situation, Task, Action, Result) to structure your answers.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions that demonstrate your interest in the company and the role. Inquire about their current data landscape, the tools they use, or how they envision the future of their data architecture. This shows you're not just interested in the job, but also in contributing to their success.
