Datawarehouse Manager/Lead-Permanent-Theale

Datawarehouse Manager/Lead

We are hiring a Datawarehouse Manager/Lead for one of our clients who is the leading UK mobile infrastructure services company. Looking for someone to own, drive and develop the Datawarehouse team in production of BAU data loads, storage, DR, reporting and outbound data, remodelling values and behaviours and acting as an outward ambassador for the BI Team.

Salary: Up to £65,000 + 15% annual bonus, 30 days paid holidays, PMI, life assurance, Wellness benefit

Location: Theale/Hybrid - from the new year 1-2 days in the office ideally

JOB DESCRIPTION:
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.
• 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.

Be the overall authority, drive and assist team with:

• Manage and assist in integration of new data sources into the data warehouse in a timely fashion to allow reporting and data storage.
  Design high of level ETL architecture for overall data migration, data models, data mappings, business logic and data cleansing methods.
• Designing and scheduling complex SSIS Packages, PowerShell scripts for transferring data from multiple data sources to SQL Server.
• Data ingestion into the data warehouse
• Data validation, reconciliation and data quality measurement and improvements. Both in storage and report production
• Data backup and storage
• Development of new data integrations from additional and expanding data sources to blend data into current dataset for reporting
• Performance tuning of all stages of data life cycle: ingestion, storage and reporting using appropriate keys/tables/views/SQL/relationships etc
• Issue route cause analysis, ownership and solutions
• Testing and implementation of changes
• Providing support to other projects as required and working together with data and other teams
  

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

Technology Stack:

• Cloud Technologies: Microsoft Azure
• SQL Query Analyser, Web Services, SQL Profiler, Bulk Copy Program (BCP)
• Scripting Languages: PowerShell, JavaScript, JQuery, VBScript, batch scripts.
• Other (non MSSQL) database tools and technologies
• Azure DevOp

Please apply via this ad in the first instance or send a CV with covering note or contact me on 07587743762 or Balla@projectpeople.com

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