At a Glance
- Tasks: Design and develop high-quality data models and enhance data warehouse layers.
- Company: Join Perch Group, a leader in ethical debt resolution through innovative technology.
- Benefits: Earn £55,000 plus bonuses, enjoy flexible working, and access professional development opportunities.
- Other info: Hybrid role with excellent career growth and a supportive work environment.
- Why this job: Make a real impact on data quality and governance while working with cutting-edge tech.
- Qualifications: 4+ years of data warehouse development experience and proficiency in T-SQL.
The predicted salary is between 63000 - 77000 £ per year.
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 Dev Ops, 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 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.
#J-18808-Ljbffr
Data Warehouse Developer in Manchester employer: Perch Group
At Perch Group, we pride ourselves on being an exceptional employer, offering a dynamic work culture that prioritises empathy and innovation in the debt resolution industry. Our Blackpool and Manchester offices provide a supportive environment where employees can thrive, with flexible working arrangements, opportunities for professional development, and a commitment to employee wellbeing. Join us to be part of a team that values your contributions and empowers you to grow while making a meaningful impact in the lives of our customers.
StudySmarter Expert Advice🤫
We think this is how you could land Data Warehouse Developer in Manchester
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Perch Group!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Warehouse Developer at Perch Group.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Perch Group.
✨Apply Directly through Our Website
When you find a suitable opening like Data Warehouse Developer at Perch Group, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Warehouse Developer in Manchester
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Perch Group, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Perch Group. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Perch Group
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Perch Group!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
