Perch Group
Data Warehouse Developer
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
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?
Data Modelling & Architecture
- 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 SMEs, analysts, and data engineers to ensure models and data flows meet requirements.
- Apply data quality and validation principles to ensure trustworthy analytical data.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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:
Essential
- 4+ years of hands-on data warehouse development in an enterprise environment.
- Strong expertise in dimensional data modelling, including conformed dimensions, fact table design, hierarchies, slowly changing dimensions, and granularity decisions.
- 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.
Desirable Skills
- 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).
Get help with your application
Your very own career expert that helps elevate your application to the next level.
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. Please note we will close this role once we have enough applications for the next stages therefore you should submit your application asap to avoid any disappointment.
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.
So, what are you waiting for? Submit your application today.
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 recruitment@perchgroup.co.uk.
PLEASE NOTE - All new employees must undergo a full DBS and Credit Check upon acceptance of a job offer with Perch Group.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills