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. By centralising data assets, implementing robust security frameworks, and removing data silos, the architect ensures the organisation has a single, reliable source of truth to support advanced analytics and AI initiative
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)
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 Benefits
- Salary aligned with your skills and expertise
- Car allowance
- 27 days holiday allowance plus statutory public holidays and the option to purchase more
- Birthday leave
- Hybrid working
- Flexible benefit and well-being schemes
- 2 giving back days per year. We encourage our team to support the wider community by providing paid leave to work with local charities or good causes
- A hard working, fun and professional working environment
- Enhanced family friendly policies, including enhanced Maternity pay
Leonard Curtis is a market leading professional services provider operating across the UK and offshore. Since our formation we’ve supported business owners and advisors by listening and offering practical solutions and tailored advice. Our expert team of specialists deliver positive strategic advice across restructuring and insolvency, funding, legal, business services and M&A advisory across 30 offices. A career with Leonard Curtis will open the door to varied career pathways.
We have built an environment that empowers you to express yourself to have confidence in who you are and what you’re capable of and develop the career you want.
Learning and Development
Leonard Curtis has a wealth of resources available to help you develop your career from the moment you join. Activities range from on-line learning modules to external training and qualifications.
Diversity and Inclusion
Diversity is a core business imperative of the Group. We are an equal opportunities employer which promotes inclusiveness and always employ the best professional for the job. Having a diverse workforce allows the Group to draw upon a range of different ideas and experiences which supports our business’s growth and creates an environment where everyone has an equal opportunity for success.
Benefits:
- Company events
- Company pension
- Cycle to work scheme
- Enhanced maternity leave
- Free or subsidised travel
- Free parking
- Health & wellbeing programme
- On-site parking
- Private medical insurance
- Referral programme
- Transport links
- Work from home
Ability to commute/relocate:
- Manchester M45 7TA: reliably commute or plan to relocate before starting work (required)
Application question(s):
- Do you have at least 3 years experience in a Data Architect role?
- What are your salary expectations?
Work authorisation:
- United Kingdom (required)
Work Location: Hybrid remote in Manchester M45 7TA
