Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and development of data warehousing solutions for a financial services organisation.
- Company: Join a specialist firm focused on innovative financial solutions and data-driven decision-making.
- Benefits: Enjoy a competitive salary, hybrid work model, and opportunities for professional growth.
- Why this job: Be at the forefront of data analytics, shaping the future of data governance and security.
- Qualifications: Experience in mortgage or lending data, strong SQL skills, and familiarity with Agile teams required.
- Other info: Mentorship opportunities available to help you grow in a dynamic environment.
The predicted salary is between 54000 - 126000 £ per year.
Lead Data Warehouse Developer – must have lending or mortgage industry experience Perm or Short Term Contract (ltd company) Salary: Up to £90,000 or contracting day rate Hybrid – 2 days a week in Bracknell A specialist financial services organisation is seeking an experienced Lead Data Warehouse Developer to take ownership of the design, development, and maintenance of its enterprise data warehouse infrastructure. This individual will play a key role in enabling structured reporting, complex analytics, and self-service data capabilities. The role also includes providing technical oversight on data solutions, supporting governance standards, and contributing to the strategic evolution of the data landscape. Key Responsibilities: Lead the end-to-end development and maintenance of data warehousing solutions aligned with business objectives. Serve on the on-call support rota, ensuring data availability and compliance with operational resilience standards. Oversee solution delivery to ensure alignment with enterprise architecture and data governance principles. Advocate for and embed data security best practices in all data strategies and solutions. Contribute to data governance evolution and promote adherence to standardised data practices across the organisation. Act as a lead stakeholder on business initiatives that impact the data warehouse. Ensure data accuracy, consistency, and integrity across warehouse and source systems. Maintain and evolve the data dictionary and associated metadata for the warehouse and ETL systems. Mentor and support team members to build a high-performing, resilient data function. Keep up to date with industry developments and maintain relevant technical expertise. Complete all mandatory training within required timelines. Provide ad-hoc support to the data management team as needed. Essential Skills & Experience: Experience working with UK mortgage data/lending data, including new lending, securitisations, and portfolio onboarding/offboarding. Strong background in data warehouse development using: Microsoft SQL Server T-SQL Power BI SSRS, SSIS, SSAS Azure DevOps Performance tuning techniques In-depth, hands-on knowledge of SQL Server and modern data warehousing practices. Proven experience applying the Kimball methodology for data warehouse design. Solid understanding of the software development lifecycle and QA standards. Strong verbal and written communication skills. Proven ability to accurately interpret and translate business requirements into technical solutions. Experience working within Agile development teams. Comprehensive knowledge of the full mortgage data lifecycle from enquiry through redemption. Background in financial services and a working knowledge of relevant regulations (e.g. Consumer Duty, Treating Customers Fairly); training provided as required. Desirable Skills: Experience with Azure-based data warehouse structures and migration projects. Familiarity with Azure Synapse Analytics. TPBN1_UKTJ
Lead Data Warehouse Developer employer: Develop
Contact Detail:
Develop Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Data Warehouse Developer
✨Tip Number 1
Network with professionals in the lending and mortgage industry. Attend relevant meetups or webinars to connect with potential colleagues and learn about the latest trends, which can give you an edge in interviews.
✨Tip Number 2
Familiarise yourself with the specific technologies mentioned in the job description, such as Microsoft SQL Server and Azure DevOps. Consider setting up a small project or contributing to open-source projects to demonstrate your hands-on experience.
✨Tip Number 3
Prepare to discuss your experience with the Kimball methodology and how you've applied it in past roles. Be ready to provide examples of how you've successfully led data warehousing projects that align with business objectives.
✨Tip Number 4
Stay updated on the latest regulations in the financial services sector, particularly those affecting the mortgage industry. Being knowledgeable about Consumer Duty and Treating Customers Fairly will show your commitment to compliance and governance.
We think you need these skills to ace Lead Data Warehouse Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience in the lending or mortgage industry. Emphasise your skills in data warehouse development, particularly with Microsoft SQL Server and relevant tools like Power BI and SSIS.
Craft a Strong Cover Letter: In your cover letter, explain why you are passionate about the role and how your background aligns with the company's needs. Mention specific projects or experiences that demonstrate your expertise in data warehousing and governance.
Showcase Technical Skills: Clearly outline your technical skills related to data warehousing, including your experience with Azure DevOps and performance tuning techniques. Use specific examples to illustrate your proficiency in these areas.
Highlight Leadership Experience: Since this is a lead position, be sure to highlight any previous leadership roles or mentoring experiences. Discuss how you've supported team members and contributed to high-performing teams in your past roles.
How to prepare for a job interview at Develop
✨Showcase Your Industry Knowledge
Make sure to highlight your experience in the lending or mortgage industry during the interview. Discuss specific projects you've worked on that relate to UK mortgage data, as this will demonstrate your understanding of the sector and its unique challenges.
✨Demonstrate Technical Expertise
Be prepared to discuss your hands-on experience with Microsoft SQL Server and other relevant technologies like Power BI and Azure DevOps. You might be asked to solve a technical problem or explain your approach to data warehouse design, so brush up on your technical skills and methodologies, especially the Kimball methodology.
✨Communicate Clearly
Strong verbal and written communication skills are essential for this role. Practice explaining complex technical concepts in simple terms, as you may need to translate business requirements into technical solutions. This will show your ability to bridge the gap between technical and non-technical stakeholders.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities and decision-making process. Think about past experiences where you had to ensure data accuracy, consistency, and integrity, and be ready to discuss how you handled those situations.
