Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and assessment of data warehouse architecture for impactful projects.
- Company: Dynamic tech firm offering hybrid work and exciting challenges.
- Benefits: Competitive daily rate, flexible working, and potential for long-term engagement.
- Why this job: Shape the future of data architecture and drive innovation in a collaborative environment.
- Qualifications: Experience in data warehousing, architecture design, and strong analytical skills.
- Other info: Opportunity for travel to London and excellent career growth potential.
The predicted salary is between 60000 - 84000 £ per year.
Overview
Role: Data Warehouse Architect
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. 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.
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
Microsoft Fabric and Platform Architecture:
- 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
MDM and Data Governance:
- 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
- Ensure MDM integration into analytical and operational use cases
Business Intelligence and Analytics Enablement:
- 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
Key Data Warehouse Building Blocks:
- 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
Architecture Leadership:
- 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
Data Warehouse Architect in City of London employer: TXP
Contact Detail:
TXP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Architect in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the data warehousing field and let them know you're on the lookout for opportunities. You never know who might have a lead or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by brushing up on your technical skills and understanding the latest trends in data architecture. We recommend practising common interview questions related to DWH assessments and design patterns to showcase your expertise.
✨Tip Number 3
Don’t forget to tailor your pitch! When you get the chance to speak with potential employers, highlight your experience with Microsoft Fabric and medallion architecture. Make sure they see how your skills align with their needs.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets noticed. Plus, we’re always looking for talented individuals like you to join our team, so don’t hesitate to hit that apply button!
We think you need these skills to ace Data Warehouse Architect in City of London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Warehouse Architect role. Highlight your experience with data architecture, Microsoft Fabric, and any relevant projects you've worked on. We want to see how your skills align with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention specific experiences that relate to the responsibilities listed in the job description. We love seeing your personality come through!
Showcase Relevant Projects: If you've worked on projects that involved data warehousing or BI, make sure to mention them. We want to know about your hands-on experience with medallion architecture and MDM strategies. This will help us see your practical knowledge in action!
Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and keep track of all candidates. Plus, it shows you’re serious about joining our team at StudySmarter!
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 well as any challenges you've faced and how you overcame them.
✨Showcase Your Microsoft Fabric Expertise
Since the role involves working with Microsoft Fabric, it’s crucial to demonstrate your understanding of its components. Prepare examples of how you've architected solutions using Microsoft Fabric, including Lakehouse and semantic models, and be ready to explain your thought process behind those decisions.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills. Think about potential challenges in data ingestion, governance, or performance issues, and prepare to discuss how you would approach these situations. Use specific examples from your experience to illustrate your points.
✨Understand Business Intelligence Needs
Familiarise yourself with business intelligence and analytics enablement. Be prepared to talk about how you’ve defined KPI metrics and ensured consistency across analytical models. Highlight any experience you have in enabling advanced analytics and how it benefited the organisation.
