Data Warehouse Manager

Data Warehouse Manager

Location: Remote (occasional in-person meetings, travel expenses covered)
Salary: £55,000 - £60,000 per annum (pro rata)
Hours: Full-time, 37.5 hours per week
Reports to: Head of IT
Contract: Inside IR35

About the Role
We are seeking an experienced Data Warehouse Manager to lead our data warehouse operations and data team, which includes roles such as BI Analysts, Data Engineers, and Power BI Gateway specialists. This position has been re-established to support a team restructure and address current operational needs due to a recent managerial resignation.
This hands-on role will be pivotal in designing and developing our data warehouse, enhancing data interoperability, and ensuring reliable data structures for impactful data analysis and reporting. You'll also lead our transition to cloud-based data capabilities, focusing on high-quality data management to support decision-making within our healthcare centres and workforce.

Key Responsibilities

1. Leadership & Team Management: Oversee the day-to-day operations of the Data Team, including BI Development, Data Engineering, and Information Systems.
2. Data Development: Design, build, and manage dimensionally modeled data warehouses, ETL routines, and integrations for data exchange.
3. Power BI & Reporting: Lead dashboard and report development, empowering stakeholders with accurate data insights.
4. Project Leadership: Act as a technical lead on data warehouse projects, including a new cloud-based data warehouse implementation aligned with our data strategy.
5. Data Governance & Collaboration: Establish data standards, work with cross-functional teams, and maintain data governance practices.
6. Documentation: Produce and maintain clear documentation for system developments, project specifications, data flows, and data dictionaries.

Requirements

1. Education: Degree in a relevant field or equivalent experience.
2. Experience: Strong knowledge of Microsoft BI tools (Power BI, SSIS, SSAS, SSRS).
   Expertise in Power BI development, SQL, and Data Warehousing principles.
   Proven experience with Microsoft Azure data capabilities, SQL Server, and T-SQL.
   Experience in matrix management environments and cross-functional collaboration.
3. Skills: Exceptional communication and relationship management abilities.
   High attention to detail and problem-solving skills.
   Customer-centric approach with a focus on creating actionable data insights.
   Ability to explain complex data concepts to non-technical audiences.

Additional Details
Work Environment: Remote, with occasional travel for meetings.
Flexibility: Willing to work outside standard hours as needed.
Driving License: Full driving license and access to a vehicle for business travel.

This is an exciting opportunity for a visionary data professional passionate about harnessing data to drive organizational success. If you’re ready to take on a leading role within a supportive team, we’d love to discuss the details with you.
Apply Now to join us in shaping the future of our data capabilities!