Data Warehouse Lead / Manager

  • Job Type: Full Time
  • Profession: IT and Business Change
  • Location: Northampton
  • Salary: Very competitive plus 38 days holiday and package

Apply for Data Warehouse Lead / Manager

Simply click the button below to apply for this position.


Data Warehouse Lead / Manager

Data Warehouse Lead / Manager


Band - SM1 / 8a / 8b

Salary - Very Competative plus package of 38 days holiday, pension and other benefits


Data Warehouse Lead


St Andrew’s is currently recruiting for a data warehouse lead; this is an amazing opportunity to lead the development team as part of a greenfield Data Warehouse project. You will lead a new and growing team where the focus is as much on the individual as it is on the skills they bring to the table and the ability to grow and mentor the skills of the individual team members. If you want to help our patients, be recognised for your success, be part of a team that works, has fun, bleeds and succeeds together, you have the right stuff and we would love to hear from you! We take our commitment of caring about patients and data very seriously. To perform to the best of our ability, we innovate and learn all the time.


The Data Warehouse Lead is a crucial position, requiring experience and expertise. You should be able to draw upon a wealth of knowledge to assist in dimensional modelling for schemas of various subject matters, from clinical to financial, from human resources to estates management. The Charity’s needs are great and you will work with the latest technology, providing solutions that address diverse needs.


You will get in from the start and lead the creation of Enterprise Data Warehouse as well as building the foundations to move into predictive analytics and self-serve business intelligence. We use the latest and greatest of the Microsoft stack and choice leading edge tools, while making no compromises in finding the right person to lead our team.


You should know the ins and outs of the Microsoft BI stack to help guide and direct the solutions proposed by the developers. You will have a keen eye for detail and documentation, making sure requirements is suitably documented, the data dictionary is correctly maintained, while keeping data governance top of the agenda. You will have the utmost respect for sensitive and confidential data, making sure all due security and precautions are taken in the handling, extraction and transformation of that data from consumption to presentation.


We are a charity that invests in our people, mentoring and coaching employees on their journey to help reach their potential. You will be working with a newly constituted crack team of technical, business and healthcare experts, using Agile Scrum and required to innovate at all levels.



Skills We Need


SQL Server 2016*

Team Foundation Server (TFS 2015)

SSAS Multidimensional


Agile/Scrum Methodologies

SSAS Tabular


Test Driven Development (TDD)



Continuous Integration (CI)








MSTest/Specflow/or similar


Dell Boomi



Test Automation








People We Need











Team Player

Service & Delivery focused

Quality Driven




*Must have as a minimum


As part of this new project within the Data, Insight and the IT department we are also looking to add more new people to the team and as a result are also looking to recruit talented passionate people for the following roles – Business Intelligence Manager, Data Quality Analyst, Data Warehouse Developers and a Data Warehouse Governance Analyst so please call on 01604 616624 if you might be interested in joining our team or pass on our details if you know others who might be interested.

St Andrew’s is the UK’s largest mental health charity. We are a unique organisation – with a positive, inclusive, welcoming culture that’s very much our own. We’re guided by shared values, defined by the people who work here and the patients we support. These values shape our behaviours and feed into everything we do.

 Benefits & Package

  • Pension
  • Sickness policy on par with the NHS
  • 38 days annual leave, increasing to 41 after 10 years' service
  • Life cover
  • Car lease scheme
  • Cycle to work scheme
  • Childcare vouchers
  • Healthcare cash plan
  • Free parking
  • Paid DBS application
  • Access to vocational qualifications