At a Glance
- Tasks: Design and govern a modern enterprise data platform for advanced analytics and AI.
- Company: Join a forward-thinking company that values innovation and collaboration.
- Benefits: Competitive salary, hybrid work model, and comprehensive benefits package.
- Other info: Dynamic role with opportunities for professional growth and development.
- Why this job: Shape the future of data architecture and make a real impact in the tech world.
- Qualifications: Expertise in Microsoft Fabric and Databricks, with strong programming skills.
The predicted salary is between 75000 - 75000 £ per year.
We are seeking a Data Warehouse Architect to design, establish, and govern a modern enterprise data platform. This role will bridge complex raw data and business insights by creating scalable, high-performance lakehouse and data warehouse architectures. You will play a key role in consolidating data assets, eliminating silos, and ensuring a single source of truth to support advanced analytics and AI.
Data Warehouse Architect Responsibilities:
- Design and implement enterprise-wide data architecture across Microsoft Fabric (OneLake) and Databricks (Unity Catalog)
- Build scalable lakehouse and warehouse solutions using Databricks SQL and Fabric SQL endpoints
- Develop robust data pipelines with Databricks Workflows, Delta Live Tables (DLT), and Fabric Data Factory
- Define and implement cross-platform data strategies using Delta Lake to minimise duplication
- Establish data governance frameworks, including access controls, lineage, and Row-Level Security (RLS)
- Manage and optimise compute resources across Fabric and Databricks environments
- Lead CI/CD implementation using Azure DevOps, GitHub, and Databricks Asset Bundles
- Drive adoption of best practices in data modelling and architecture patterns
As Data Warehouse Architect, you will have:
- Strong expertise in Microsoft Fabric (OneLake) and Databricks (Unity Catalog) architecture
- Proven experience building modern lakehouse and data warehouse platforms
- Hands-on experience with:
- Databricks SQL & Fabric SQL
- Databricks Workflows & Delta Live Tables (DLT)
- Fabric Data Factory
- Deep knowledge of Delta Lake and cross-platform data strategies
- Solid experience in data governance, including lineage, access control, and RLS
- Experience managing multi-engine compute environments
- CI/CD experience with Azure DevOps, GitHub, and Databricks Asset Bundles
- Strong programming skills in PySpark, Databricks SQL, and T-SQL
- Understanding of Medallion Architecture and modern data modelling approaches (Star Schema, Data Vault 2.0)
- Experience with performance optimisation in Databricks and integration with Power BI (Direct Lake)
Data Warehouse Architect employer: Robert Walters
At Robert Walters Operations Limited, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration. As a Data Warehouse Architect in Bury, you will benefit from a hybrid working model, competitive salary, and opportunities for professional growth within a supportive environment that values your contributions to building cutting-edge data solutions.
