Datawarehouse Manager. Build from scratch. Telecoms.

Reading Permanent £70,000 - £80,000
  • Build a new DW from scratch.
  • Leave legacy within Telecoms giant.

About Our Client

The client is a world-class telecoms business that are in need of a major transformation. The client has a unique opportunity for a DW Architect to come, design & build a Datawarehouse from scratch,

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 expert knowledge in all areas under the remit of ownership, creating and delivering a defined strategic roadmap for the data warehouse future.

Provide leadership to the data warehouse team, accountable for managing team workload and stakeholder expectations.

Develop and refine a 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.

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.
  • 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

The Successful Applicant

The current infrastructure is Microsoft focused, with MS SQL and SQL Azure, however, you will be given full licence to choose and advise on the best tools and tech stack going forward.

Candidates from all industry backgrounds are encouraged to apply, however, a mixture of environments will carry a distinct advantage as you will be best placed to advise on the best fit for business needs.

Experience within the design, Database Installation, configuration, maintenance, monitoring, backups and recoveries is mandatory.

What's on Offer

In return you will be given a great benefits package which includes a lucrative bonus scheme, excellent benefits and the opportunity to work remotely.

CVs are under review now!

Contact
Amir Malik
Quote job ref
JN-012022-4579883
Phone number
+44 (0)207 269 6239

Job summary

Sector
Technology
Subsector
Data Warehousing
Industry
Technology & Telecoms
Location
Reading
Contract type
Permanent
Consultant name
Amir Malik
Consultant phone
+44 (0)207 269 6239
Job reference
JN-012022-4579883