Data Warehouse Architect in Manchester

Data Warehouse Architect in Manchester

Manchester Full-Time 60000 - 80000 £ / year (est.) No working from home possible
Leonard Curtis Recovery Limited

At a Glance

  • Tasks: Design and optimise data architectures for impactful decision-making.
  • Company: Join a forward-thinking company that values inclusivity and diversity.
  • Benefits: Competitive salary, 27 days holiday, hybrid work, and birthday leave.
  • Other info: Enjoy a fun, professional environment with excellent career growth opportunities.
  • Why this job: Shape the future of data with innovative technologies and make a real difference.
  • Qualifications: Expertise in Microsoft Fabric and Databricks, plus strong data pipeline skills.

The predicted salary is between 60000 - 80000 £ per year.

We’re currently seeking a Data Warehouse Architect who will be responsible for establishing, optimising, and governing a unified enterprise data platform that enables data‑driven decision‑making. Acting as a bridge between complex raw data and meaningful business insight, the role involves designing scalable, high‑performance Lakehouse and data warehouse architectures.

Job Responsibilities

  • Design global architectural blueprints combining Microsoft Fabric OneLake and Databricks Unity Catalog.
  • Build optimised Lakehouse and warehouse structures using Databricks SQL and Fabric SQL endpoints.
  • Establish data pipelines using Databricks Workflows, Delta Live Tables (DLT), and Fabric Data Factory.
  • Formulate cross‑platform data strategies utilising shared Delta Lake formats to eliminate data duplication.
  • Implement unified data governance, access controls, and Row‑Level Security (RLS) via Unity Catalog.
  • Direct multi‑engine computation strategies using Fabric capacities alongside Databricks clusters.
  • Define CI/CD deployment frameworks across both platforms using Azure DevOps, GitHub, and Databricks Asset Bundles.

Job Requirements

  • Expertise in Microsoft Fabric (OneLake) and Databricks (Unity Catalog) architecture.
  • Experience building scalable lakehouse and warehouse solutions (Databricks SQL, Fabric SQL).
  • Strong data pipeline development using Databricks Workflows, DLT, and Fabric Data Factory.
  • Knowledge of Delta Lake and cross‑platform data strategies to reduce duplication.
  • Data governance expertise, including Unity Catalog, RLS, and data lineage.
  • Experience managing compute across Fabric and Databricks environments.
  • CI/CD knowledge using Azure DevOps, GitHub, and Databricks Asset Bundles.
  • Proficiency in PySpark, Databricks SQL, T‑SQL, and Delta Lake internals.
  • Strong understanding of Medallion Architecture and modern data modelling (Star Schema, Data Vault 2.0).
  • Experience optimising Databricks performance and integrating with Power BI (Direct Lake).

Benefits

  • Salary aligned with your skills and expertise.
  • 27 days holiday allowance plus statutory public holidays and the option to purchase more.
  • Birthday leave.
  • Hybrid working.
  • Car allowance.
  • Flexible benefit and well‑being schemes.
  • 2 giving back days per year – paid leave to work with local charities or good causes.
  • Enhanced family friendly policies, including enhanced Maternity pay.
  • A hard working, fun and professional working environment.

We are an equal opportunities employer which promotes inclusiveness and always employs the best professional for the job. We value a diverse workforce and provide an environment where everyone has an equal opportunity for success.

Data Warehouse Architect in Manchester employer: Leonard Curtis Recovery Limited

As a Data Warehouse Architect at our company, you will thrive in a dynamic and inclusive environment that champions innovation and professional growth. With competitive salaries, generous holiday allowances, and flexible working arrangements, we prioritise your well-being while empowering you to make impactful contributions to our enterprise data platform. Join us to be part of a collaborative team that values diversity and offers unique opportunities to engage with local charities through our giving back days.

Leonard Curtis Recovery Limited

Contact Details:

Leonard Curtis Recovery Limited Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Data Warehouse Architect in Manchester

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 game. You never know when a casual chat could lead to your next big opportunity.

Show Off Your Skills

Don’t just tell them what you can do; show them! Create a portfolio showcasing your projects, especially those involving Microsoft Fabric and Databricks. This will give potential employers a clear view of your capabilities and how you can add value.

Ace the Interview

Prepare for those interviews by brushing up on common questions related to data architecture and governance. Be ready to discuss your experience with CI/CD frameworks and data pipelines. Confidence is key, so practice makes perfect!

Apply Through Our Website

We love seeing applications come through our website! It shows you’re genuinely interested in joining our team. Plus, it’s a great way to ensure your application gets the attention it deserves. So, don’t hesitate—hit that apply button!

We think you need these skills to ace Data Warehouse Architect in Manchester

Microsoft Fabric (OneLake)
Databricks (Unity Catalog)
Databricks SQL
Fabric SQL
Databricks Workflows
Delta Live Tables (DLT)
Fabric Data Factory

Some tips for your application 🫡

Tailor Your CV:Make sure your CV reflects the skills and experiences that match the Data Warehouse Architect role. Highlight your expertise in Microsoft Fabric and Databricks, and don’t forget to mention any relevant projects you've worked on!

Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data architecture and how your background makes you the perfect fit for our team. Keep it engaging and personal!

Showcase Your Technical Skills:We want to see your technical prowess! Be specific about your experience with data pipelines, CI/CD frameworks, and any tools like Azure DevOps or GitHub. The more detail, the better!

Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!

How to prepare for a job interview at Leonard Curtis Recovery Limited

Know Your Tech Inside Out

Make sure you’re well-versed in Microsoft Fabric and Databricks architecture. Brush up on your knowledge of Lakehouse and data warehouse solutions, as well as the specific tools mentioned in the job description like Databricks SQL and Fabric SQL endpoints. Being able to discuss these technologies confidently will show that you're the right fit for the role.

Showcase Your Data Pipeline Skills

Prepare to talk about your experience with data pipeline development using Databricks Workflows and Delta Live Tables. Have examples ready that demonstrate how you've built optimised structures and established effective data governance. This will highlight your practical skills and understanding of the role's requirements.

Understand the Bigger Picture

Familiarise yourself with cross-platform data strategies and the importance of reducing data duplication. Be ready to discuss how you would implement unified data governance and access controls. This shows that you can think strategically and understand the impact of your work on the business.

Prepare for Technical Questions

Expect technical questions related to CI/CD frameworks, Azure DevOps, and GitHub. Brush up on your knowledge of PySpark, T-SQL, and modern data modelling techniques like Star Schema and Data Vault 2.0. Being prepared for these questions will demonstrate your expertise and readiness for the challenges of the role.