Data Warehouse Manager
Reading - Hybrid
Perm
Main Purpose of the Role
Lead and support the Data Warehouse team in production of BAU data loads, storage, DR, reporting, and outbound data. Be the authority and provide guidance on database management, development, architecture, future design considerations, performance improvements, and monitoring.
Develop and apply best practices in the above areas, creating and delivering a roadmap for the data warehouse's future.
Work closely in collaboration with teams across the organization and its third-party suppliers to ensure the efficient operation of the strategic information services and the delivery of the overall BI Team roadmap and project developments.
Key Responsibilities
Team and Task Management
* Lead the data warehouse team, managing workload and expectations to the business. Develop/manage team and pipeline of work to deliver all aspects of issues, reporting, and development in a timely fashion.
* Work with the team to build objectives and plans in line with the BI roadmap. Lead, develop, and mentor a forward-looking customer-centric Data Warehouse Team.
* Collaborate with the business and the rest of the BI team to understand future requirements and plan accordingly.
* Represent and promote the interests of the data warehouse team across the business through appropriate meetings around BAU and projects.
Delivery
* Manage and assist with BAU work and report production, including review and continual development of the daily and overall warehouse processes/controls to improve the performance and reliability of the system.
* Lead and manage the team to operate in and across specialist functions such as Data Engineering.
* Work with the team to deliver best practice database design to meet the requirements of the business.
* Manage and assist in the integration of new data sources into the data warehouse in a timely fashion to allow reporting and data storage.
* Drive the Data Warehouse team to deliver solutions that fulfill the business information needs and align with the data strategy and vision.
* Monitor Azure costs and proactively seek ways to optimize the data warehouse to reduce spending.
* Serve as the authority on database architecture and design for current and future development.
* Implement and maintain access to the data warehouse and databases using Role-Based Access Controls (RBAC) principles.
Required
* Team leadership and development
* MSSQL/MS SQL Azure
* Database development
* Database architecture and design including pros and cons of relevant schemas/structures
* All aspects of the MSSQL stack: SSIS, SSRS, SSMS, etc.
* Database installation, configuration, maintenance, monitoring, backups, and recoveries
* Stakeholder management
* Bulk Copy Program
* SQL Profiler
Desirable
* Telecoms background
* Project management experience
* Scripting languages - PowerShell, JavaScript, JQuery, VBScript, Batch Script
* Azure DevOps
To apply for the Data Warehouse Manager, please send your CV to (url removed).
#J-18808-Ljbffr