> Markdown version of [/jobs/ext/2821827-data-warehouse-developer](https://www.wearedevelopers.com/jobs/ext/2821827-data-warehouse-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Warehouse Developer - **Company:** Perch Group - **Location:** Manchester, UK - **Experience:** Experienced - **Salary:** £55,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, Automation of Tests, Microsoft Azure, Code Review, Continuous Integration, Data Governance, Extract Transform Load (ETL), Data Transformation, Data Vault Modeling, Data Warehousing, Metadata, Meta-Data Management, Microsoft SQL Server, Performance Tuning, Power BI, SQL Databases, Data Streaming, Transact-SQL, Azure Data Factory, Snowflake, Data Layers, Physical Data Models, Ssas Tabular, Databricks - **Published:** September 10, 2026 - **Apply:** https://www.collegerecruiter.com/job/2847388436-data-warehouse-developer ## About the Role We're looking for a Data Warehouse Developer with real delivery experience, not just theoretical knowledge: * 4+ years of hands-on data warehouse development in an enterprise environment. * Proven experience designing and delivering full DWH layers (staging * integration * dimensional). * Proficiency in T-SQL for data transformations, performance tuning, and DWH logic. * Experience with Azure data ecosystem (ADF, Databricks, Synapse, or SQL Server). * Solid understanding of data governance, data quality, and metadata management concepts. * Experience with Data Vault or hybrid DWH modelling patterns. * Knowledge of semantic modelling for BI tools (Power BI, SSAS tabular). * Exposure to metadata-driven ETL/ELT or parameterised pipeline frameworks. * Familiarity with Azure DevOps, CI/CD, or automated testing for data applications. * Experience in regulated industries (financial services, utilities, or debt recovery). The Application Timeline * A first stage video call with the internal recruitment team (15 minutes) * A technical test in person or over Zoom (up to 2 hours) * A face-to-face interview with the hiring manager (1 hour) ## Description We're looking for an experienced Data Warehouse Developer with strong data modelling capability and proven experience delivering enterprise-grade data warehouse solutions. You will play a key role in shaping our analytical data assets, designing high-quality dimensional models, and ensuring that the data warehouse underpins reliable, scalable, and consistent reporting across the business. This role is ideal for someone who is passionate about data modelling as a craft, understands the realities of end-to-end DWH delivery, and wants to make a meaningful impact on data quality, governance, and analytical enablement. So, what will your day-to-day look like? * Design high-quality dimensional data models (star, snowflake, Data Vault if applicable) aligned to business definitions and analytical needs. * Maintain and evolve semantic layers, conformed dimensions, and enterprise-wide modelling standards. * Translate business requirements into conceptual, logical, and physical data models. * Ensure models support performance, usability, extensibility, and governance needs. Data Warehouse Delivery * Develop and enhance data warehouse layers (staging, integration, dimensional/presentation). * Build robust ETL/ELT processes using ADF, Databricks, or SQL-based pipelines. * Work closely with business SME's, analysts, and data engineers to ensure models and data flows meet requirements. * Apply data quality and validation principles to ensure trustworthy analytical data. Collaboration, Governance & Continuous Improvement * Partner with analysts and business teams to evolve definitions, hierarchies, and KPI logic. * Participate in code reviews and help maintain modelling and DWH delivery standards. * Contribute to data governance activities including documentation, lineage, and metadata enhancement. * Champion good modelling practices and share knowledge across the team. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)