Lead Data Architect

Lead Data Architect

Full-Time 48000 - 72000 £ / year (est.) No home office possible
H

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 supporting UK businesses.
  • Benefits: Competitive salary, bonuses, private medical insurance, and 25 days annual leave.
  • Why this job: Join a growing bank and lead the transformation into a data-driven business.
  • Qualifications: Experience in Data Warehouse modelling and strong SQL skills required.
  • Other info: Hybrid working model with excellent career development opportunities.

The predicted salary is between 48000 - 72000 £ per year.

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.

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 incoming Lead Data Architect will own the design of HTB's Data Model, to ensure it meets business requirements, and aligns to agreed standards. The working pattern for the role will be hybrid, with a minimum 50% of time spent in our London offices.

Key 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.
Required Skills & Experience
  • 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.
  • Detail orientated in designing robust, scalable data models.
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 (non‑contributory).
  • Interest‑free season ticket loan.
  • Annual volunteering day & Net Zero employer commitment.

Lead Data Architect employer: Hampshire Trust Bank

Hampshire Trust Bank is an exceptional employer, offering a dynamic work environment where innovation and integrity are at the forefront. With a strong commitment to employee growth, competitive benefits including private medical insurance, and a hybrid working model, we empower our team to thrive while contributing to the success of UK businesses. Join us in our London office and be part of a data-driven transformation that not only enhances your career but also supports the British economy.
H

Contact Detail:

Hampshire Trust Bank Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Lead Data Architect

✨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 make a huge difference!

✨Tip Number 2

Prepare for the interview by brushing up on your data modelling skills. Be ready to discuss your experience with Data Vault and Snowflake, and how you can contribute to HTB's goal of becoming a data-driven business. Show them you mean business!

✨Tip Number 3

Don’t forget to showcase your problem-solving abilities! Think of examples where you've tackled complex data issues in the past. This will demonstrate your analytical mindset and how you can add value to the team.

✨Tip Number 4

Finally, 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 HTB family. Let’s get you that job!

We think you need these skills to ace Lead Data Architect

Data Warehouse Modelling
Data Vault
Kimball
3NF
Analytical Skills
Critical Thinking
Problem-Solving Skills
Advanced SQL Knowledge
Snowflake
Stakeholder Management
Communication Skills
Data Modelling Methodologies
ETL Development
Detail Orientation
Mentoring

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 way that aligns with our needs.

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about becoming a data-driven business and how your background makes you the perfect fit for our team at Hampshire Trust Bank.

Showcase Your Problem-Solving Skills: In your application, don’t just list your skills—give examples of how you've tackled complex data issues in the past. We love seeing analytical minds at work, so share those success stories!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets into the right hands and shows us you’re serious about joining our team!

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 your practical experience and understanding of these concepts.

✨Showcase Your Analytical Skills

Prepare to demonstrate your analytical mindset and problem-solving abilities. Think of specific examples where you've tackled complex data issues or improved processes, as this will highlight your critical thinking skills that are essential for the Lead Data Architect role.

✨Communicate Clearly

Since you'll be working with both technical and non-technical stakeholders, practice explaining complex ideas in simple terms. This will show that you can bridge the gap between IT and business, which is crucial for the role.

✨Familiarise Yourself with Emerging Technologies

Stay updated on modern data technologies, especially Snowflake and Tableau. Be prepared to discuss how these tools can align with business goals and how you've used them in previous projects to drive success.

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

H
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>