Data Warehouse Developer

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.

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)

• £55,000, + up to 20% of your annual salary, paid as a bonus.
• This role is hybrid can be based at our Blackpool or Manchester office.
• 37.5 hours per week. We offer flexible and hybrid working between our core hours of 8am- 6pm, Monday to Friday.
• The opportunity to complete formal qualifications and learn on the job in a successful, growing organisation.
• And many more benefits to support your wellbeing and professional development.

At Perch Group, our vision is clear: to lead the UK debt purchase and collection industry by harnessing cutting-edge technology to drive ethical, efficient, and data-driven debt resolution.

Our annual mission is to empower hundreds of thousands of customers to positively engage with and resolve their outstanding debts. We do this through an empathetic and customer-centric approach that is at the heart of our success.