Connecting to LinkedIn...

Data Warehouse Manager

Job Title: Data Warehouse Manager
Contract Type: Permanent
Location: Theale, Berkshire
Industry:
Salary: Negotiable
REF: RC/P/Datawarehouse_1638211118
Contact Name: Rohit Chavda
Contact Email: Rohit.Chavda@projectpeople.com
Job Published: about 2 months ago

Job Description

Data Warehouse Manager

Permanent

Location: Theale

The Role:

To own, drive and develop the Data warehouse team in production of BAU data loads, storage, DR, reporting and outbound data, remodelling Client's values and behaviours and acting as an outward ambassador for the BI Team. Be the authority and provide leadership and guidance on database management, development, architecture, future design considerations, performance improvements and monitoring. Develop and apply best practice and expertise knowledge in all areas under remit of ownership, creating and delivering a defined strategic roadmap for data warehouse future.

Responsibilities:

  • Provide leadership to the data warehouse team, accountable for managing team workload and stakeholder expectations.
  • Develop and refinement of pipeline of work to deliver all aspects of issues, reporting and development in an efficient and effective fashion, aligned to critical business timeframes and deadlines.
  • Lead the team to build strategic objectives and plan in line with BI roadmap.
  • Collaborate with senior stakeholders within the business and the rest of the BI team to understand future team requirements and plan accordingly.
  • Be an ambassador for the data warehouse team across the business through appropriate meetings around BAU and projects.
  • Provide leadership to the data warehouse team, accountable for managing team workload and stakeholder expectations.
  • Develop and refinement of pipeline of work to deliver all aspects of issues, reporting and development in an efficient and effective fashion, aligned to critical business timeframes and deadlines.
  • Manage, oversee 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 and deliver business efficiencies.
  • Lead the 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.
  • Be the overall authority, drive and assist team with design high of level ETL architecture for overall data migration, data models, data mappings, business logic and data cleansing methods.

Skills Required:

  • Team leadership and development
  • MSSQL/ MS SQL Azure experienced
  • Database developer experienced
  • 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

Project People is acting as an Employment Agency in relation to this vacancy.