Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and architecture of data warehouses, ensuring optimal data flow and governance.
- Company: Dynamic tech firm offering hybrid work and exciting projects.
- Benefits: Competitive daily rate, flexible 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, architecture design, and strong analytical skills.
- Other info: Opportunity for travel to London and collaboration with industry leaders.
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
- Ensure MDM integration into analytical and operational use cases
- 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 employer: TXP
Contact Detail:
TXP Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Warehouse Architect
✨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 hunt for a role. 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. Be ready to discuss how you would approach the responsibilities listed in the job description, like defining target state architecture and MDM strategies.
✨Tip Number 3
Showcase your expertise! Create a portfolio or case studies that highlight your previous work with data warehouses, especially any experience with Microsoft Fabric or medallion architecture. This will give you an edge during discussions.
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Data Warehouse Architect
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 that showcase your skills in DWH assessment and design.
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 align with the responsibilities listed in the job description, like defining target state architecture or MDM strategies.
Showcase Your Technical Skills: Don’t forget to highlight your technical skills related to data warehousing, such as your familiarity with medallion architecture and Power BI. We want to see how you can contribute to our data landscape!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates!
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 Microsoft Fabric, Lakehouse Warehouse, and data governance. We recommend reviewing case studies or examples from your previous work that demonstrate your ability to define integration patterns and establish non-functional requirements.
✨Showcase Your Leadership Skills
As an architectural authority, you'll need to demonstrate your leadership capabilities. Prepare examples of how you've acted as a design reviewer or governed delivery in past projects. This will help interviewers see your potential to lead within their organisation.
✨Ask Insightful Questions
At the end of the interview, don’t forget to ask questions! Inquire about the company's current DWH landscape and what challenges they face. This shows your genuine interest in the role and helps you assess if it's the right fit for you.
