Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and own the Data Model to meet business needs and standards.
- Company: Hampshire Trust Bank, a specialist bank focused on helping UK businesses thrive.
- Benefits: Competitive pay, bonuses, private health insurance, and 25 days holiday.
- Why this job: Join a data-driven team and shape the future of banking with innovative solutions.
- Qualifications: Experience in Data Warehouse modelling and strong SQL skills required.
- Other info: Hybrid working model with excellent career growth and mentoring opportunities.
The predicted salary is between 43200 - 72000 £ per year.
Hampshire Trust Bank has a strong growth forecast for the years ahead, having achieved strong growth over recent years, and becoming a data driven business is identified as a key success criterion for achieving those forecasts on a cost-effective basis. The Bank is investing in becoming a data driven business and is in the process of migrating to a new data platform, comprising of a Snowflake data warehouse, Tableau reporting and analysis platform, and a new data governance operation. The working pattern for the role will be hybrid, with a minimum 50% of time spent in our London offices.
Responsibilities
- The Lead Data Architect will own the design of the Data Model, to ensure it meets business requirements, and aligns to agreed standards (e.g. Data Vault).
- Conceive and design the data structures and integrations that enable us to rapidly, efficiently and effectively deliver on the Bank's objectives.
- Ensure that data modelling (conceptual, logical, physical) is to a high standard across the organisation.
- Evaluate emerging technologies and recommend solutions aligned with business goals.
- Support the Bank in the execution of agreed control / governance methods and processes.
- Effectively collaborate with both IT and business stakeholders to understand how business processes translate into source system schemas, and the implications this has on the design of the Data Platform.
- Document detailed specifications for the ETL Developers to deliver against and run design assurance for numerous high-profile projects.
- Lead on the investigation of business data questions and problems to successfully determine the most effective solution for resolution and / or efficiency.
- Ensure communication of complex ideas and deliverables can be understood by non-technical colleagues across the Bank.
- Develop high and low level designs, including the overarching Data Platform Data Model.
- Mentoring of Data Platform Teams on data modelling methodologies and practices.
Qualifications
- Proven Data Warehouse modelling experience (Data Vault, Kimball, 3NF, etc.), possibly obtained in a different but complimentary role e.g. Data Engineer, Data Analyst.
- Analytical mind, critical thinker, and problem solver.
- Advanced SQL knowledge.
- Strong knowledge of modern data technologies, including Snowflake.
- Excellent stakeholder management skills, with a clear communication style.
- Strong analytical and problem-solving skills.
- Ability to trouble-shoot complex data and architecture issues.
About Hampshire Trust Bank
Hampshire Trust Bank is a specialist bank, staffed by experts focused on helping UK businesses realise their ambitions. We offer niche specialty lines, as a SME bank, targeting under-served segments. Our dedicated Wholesale Finance, Bridging Finance, Development Finance and Specialist Mortgages teams ensure that businesses receive the outstanding service, lasting relationships, integrity and expertise they need to prosper. We also provide savings accounts to individuals and businesses and since we lend to SMEs, our savers can be sure their money will help boost the British economy. Our vision is to be the go‑to bank in our chosen markets; to deliver positive customer outcomes, rewarding careers and great shareholder value through a high‑performing culture grounded in excellence and integrity.
Benefits
- Competitive remuneration.
- Discretionary annual bonus.
- Annual pay review.
- Private Medical Insurance (Bupa).
- Mental health & wellbeing support via YuLife & Bupa.
- 25 days annual leave (increasing with service) + Holiday Buy Scheme.
- Cycle to Work Scheme & Green Car Scheme.
- Enhanced family leave policies.
- Study support & professional memberships.
- Hybrid working (50/50).
- YuLife Rewards - lifestyle & retail discounts.
- Pension scheme - 8% employer contribution (noncontributory).
- Interest-free season ticket loan.
- Annual volunteering day & Net Zero employer commitment.
Lead Data Architect in City of Westminster employer: Hampshire Trust Bank
Contact Detail:
Hampshire Trust Bank Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Lead Data Architect in City of Westminster
✨Tip Number 1
Network like a pro! Reach out to current employees at Hampshire Trust Bank on LinkedIn. Ask them about their experiences and any tips they might have for landing the Lead Data Architect role. Personal connections can give you an edge!
✨Tip Number 2
Prepare for the interview by brushing up on your data modelling knowledge. Be ready to discuss your experience with Data Vault, Snowflake, and SQL. We want to see how you can apply your skills to help HTB become a data-driven business.
✨Tip Number 3
Showcase your problem-solving skills! Think of examples where you've tackled complex data issues in the past. We love candidates who can demonstrate critical thinking and effective solutions, especially in a banking context.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, it shows you’re genuinely interested in being part of the Hampshire Trust Bank team.
We think you need these skills to ace Lead Data Architect in City of Westminster
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Lead Data Architect role. Highlight your experience with data modelling and technologies like Snowflake, as well as any relevant projects that showcase your skills in a data-driven environment.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about becoming a part of Hampshire Trust Bank and how your background aligns with their goals of becoming a data-driven business.
Showcase Your Problem-Solving Skills: In your application, don’t forget to mention specific examples where you've tackled complex data issues or improved processes. This will demonstrate your analytical mindset and ability to deliver effective solutions.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity at Hampshire Trust Bank!
How to prepare for a job interview at Hampshire Trust Bank
✨Know Your Data Models
Make sure you brush up on your knowledge of data modelling techniques like Data Vault and Kimball. Be ready to discuss how you've applied these in past roles, as the interviewers will want to see that you can design a robust Data Model that meets business needs.
✨Showcase Your Stakeholder Skills
Prepare examples of how you've effectively collaborated with both IT and business stakeholders. Highlight your communication style and how you've translated complex data concepts into understandable terms for non-technical colleagues.
✨Demonstrate Problem-Solving Prowess
Be ready to tackle hypothetical data architecture issues during the interview. Think through your problem-solving process and be prepared to explain how you would approach troubleshooting complex data challenges.
✨Stay Updated on Emerging Technologies
Research the latest trends in data technologies, especially those relevant to Snowflake and Tableau. Show your enthusiasm for continuous learning and how you can leverage new tools to align with the bank's goals.
