Data Warehouse Manager
Reading - Hybrid
Perm
Main purpose of the role
Lead and support the Datawarehouse team in production of BAU data loads, storage, DR, reporting and outbound data. Be the authority and give guidance on database management, development, architecture, future design considerations, performance improvements and monitoring.
Develop and apply best practice in above areas creating and delivering a roadmap for data warehouse future.
Working closely in collaboration with teams across Organisation 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. Developing /managing team and pipeline of work to deliver all aspects of issues, reporting and development in a timely fashion.
Work with team to build objectives and plan in line with BI roadmap. Lead, develop and mentor a forward-looking customer centric Data Warehouse Team
Work with the business and the rest of the BI team to understand future requirements and plan accordingly.
Represent and promote interests of 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 team to operate in and across specialist functions such as Data Engineering
Work with team to deliver best practice database design to deliver the requirements of the business
Manage and assist in 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 the solutions that fulfil the Business information needs and align with the Data strategy and vision.
Monitor Azure costs and proactively look for ways of optimizing the data warehouse to reduce spend.
Be authority on database architecture and design for current and future development.
Implement and maintain access to data warehouse and databases using Role Based Access Controls (RBAC) principles.
Required
Team leadership and development
MSSQL/ MS SQL Azure
Database developer
Database architecture and design including pros and cons of relevant schemas/structure etc
All aspects of MSSQL stack: SSIS, SSRS, SSMS etc
Database Installation, configuration, maintenance, monitoring, backups and recoveries
Stakeholder management
Bulk Copy Programme
SQL ProfilerDesirable
Telecoms Background
Project Manager experience
Scripting Languages - PowerShell, JavaScript, JQuery, VBScript, BatchScript
Azure DevOps
To apply for the Data Warehouse Manager please send your CV to
Project People is acting as an Employment Agency in relation to this vacancy
The latest news, articles, and resources, sent to your inbox weekly.
Job Title: Data AnalystLocation: Wath (Rotherham), near SheffieldType: Hybrid/Remote with monthly on-site meetingsExperience: Strong experience in data analysis and ETL processesDomain: Data Strategy and Data Warehouse DevelopmentMy client, a leading provider of security and facility services, is seeking a Data Analyst to support ETL development, improve data quality, and enhance...
Rotherham
Job Title: Data AnalystLocation: Wath (Rotherham), near SheffieldType: Hybrid/Remote with monthly on-site meetingsExperience: Strong experience in data analysis and ETL processesDomain: Data Strategy and Data Warehouse DevelopmentMy client, a leading provider of security and facility services, is seeking a Data Analyst to support ETL development, improve data quality, and enhance...
Rotherham
About ourTeam:The Global Data and Analytics team provides centralized support for data and business intelligence capabilities throughout the SAGE enterprise We industrialize datasets into our global data warehouse We enable access to data using scalable business intelligence solutions We standardize and consolidate customer data to support marketing activities and analysisCould...
SAGE Publishing London
Data Manager - Birmingham, West Midlands - hybrid workingto 70k plus excellent benefitsWe’re looking for an experienced Data Manager skilled in Arbor MAT MIS to lead data-driven insights that support data performance and improvement. This role involves analysing and managing data, developing efficient reporting processes, and supporting decision-making across their...
Birmingham
Job Overview:Are you able to shape the way an organisation captures and utilises its data to inspire change?We are seeking an innovative and passionate individual with a track record of leading a data insights function to join Arms global IT department. Using your outstanding visualisation skills, you will be responsible...
ARM Cambridge
Job Overview:Are you the right candidate for this opportunity Make sure to read the full description below.Are you able to shape the way an organisation captures and utilises its data to inspire change?We are seeking an innovative and passionate individual with a track record of leading a data insights function...
ARM Farnham
