Data Warehouse Developer

Perch Group; Manchester; Hybrid; GBP 50,000 - 61,000; Full time

Benefits offered by this job

Hybrid work

Bonus up to 20%

Job summary

Perch Group in the UK is seeking an experienced Data Warehouse Developer to design and deliver enterprise‑grade DWH solutions. You will shape analytical data assets, design dimensional models, and ensure reporting is reliable, scalable and governed.

The role requires 4+ years in DW development, proficiency in T‑SQL, and experience with Azure data tools (ADF, Databricks, Synapse or SQL Server). Knowledge of Data Vault modelling and BI semantic tooling (Power BI) is desirable.

Qualifications

• 4+ years hands‑on data warehouse development in an enterprise environment.
• Proficiency in T‑SQL for data transformations and DWH logic.
• Experience with Azure data ecosystem (ADF, Databricks, Synapse, or SQL Server).
• Knowledge of Data Vault or hybrid DWH modelling patterns.
• Experience with semantic modelling for BI tools (Power BI).

Responsibilities

• Design high‑quality dimensional data models (star, snowflake, Data Vault if applicable).
• Maintain semantic layers and conformed dimensions.
• Translate requirements into conceptual, logical, and physical data models.
• Develop and enhance data warehouse layers (staging, integration, dimensional/presentation).
• Build ETL/ELT processes using Azure tools and SQL‑based pipelines.
• Collaborate with analysts, SMEs, and data engineers to meet requirements.
• Apply data quality and governance principles.

Skills

Data modelling

ETL/ELT

T‑SQL

Azure data services

Power BI

Data governance

Data Vault

CI/CD for data

Tools

ADF

Databricks

Synapse

SQL Server

Job description

Perch are recruiting for a Data Warehouse Developer.

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.

Could this be the next step in your career?

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.

Does this sound like you?

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)

Typically, the average successful applicant will be within this timeline for 2-3 weeks.

If you do not receive a response after 3 weeks of applying, please assume you have been unsuccessful as we may experience a high volume of applications.

Why you should be EXCITED to apply…

• £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.

We’re an equal opportunity employer. All applicants will be considered for employment without attention to age, ethnicity, religion, sex, sexual orientation, gender identity, family or parental status, national origin, or veteran, neurodiversity or disability status.

If you have any questions or suggestions of how we can assist you in your application due to disability or personal reasons, please email [e-mail].

PLEASE NOTE - All new employees must undergo a full DBS and Credit Check upon acceptance of a job offer with Perch Group.