Data Warehouse Expert

Reference:

MDPSR/DataWarEx/53

Sector:

Strategy & Architecture

Salary:

Competitive

Town/City:

Wiltshire

Contract Type:

Contract

Closing Date:

22/11/2019

Amazing 12 month contracted role for a proven Data Warehouse Expert required to:

  1. Architect, design, implement and document an on-premise central data repository for data integration and MI, and a number of MI focused data marts, using Microsoft database technologies.
  2. Design and implement a data dictionary for the data repository and data marts
  3. Design and document the data models, transformations and mapping rules and coding
  4. Ensure that best practices are used across solutions, using a range of approaches to meet the requirements in the most appropriate way.
  5. Keep stakeholders engaged and up to date on progress.
  6. Develop data integration and interfaces between the data repository, Data Marts and the systems and services that need to interface with them.
  7. Development and integration testing of interfaces, managing corrective actions and version control of interfaces and database structures
  8. Understanding our data and what & how the data is being used
  9. Define enterprise architectures for Data Warehouse, Master Data/Reference Data, data standards and integration for data
  10. Responsible for the definition of data architecture components for information management solutions to facilitate storage, integration, usage, access, and delivery of data assets across the enterprise
  11. Define and lead work packages that deliver elements of an information management solution e.g. data models, data structure, data warehouse, data mart, ETL service, operational data store
  12. Design the conceptual and logical data architecture for our data (operational and strategic) as well as documenting databases, interfaces and data movement realting to the data repository, the data marts and interfaces with other systems.
  13. Document the data architectures
  14. Design the data integration architecture based on solution requirements e.g. real-time, near realtime, batch etc.
  15. Create and implement a data management strategy for achieving and maintaining high levels of data quality
  16. Engage with stakeholders and business teams to understand their specific information needs.
  17. Ensure that new systems and/or applications adhere to existing data management practices policies and procedures
  18. Ensure designs are scalable to allow for future growth

Suitable candidates must have SC Clearance.