W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9tb3jzb24vanbnl2jhbm5lci1kzwzhdwx0ltmuanbnil1d

Home

Database Developer

  • Location

    Warrington, Cheshire

  • Sector:

    Developer

  • Job type:

    Contract

  • Salary:

    Negotiable

  • Contact:

    Lorraine Ryan

  • Contact email:

    lorraine.ryan@morson.com

  • Job ref:

    169845LR_1572525547

  • Published:

    13 days ago

  • Duration:

    5m initially

  • Expiry date:

    2019-11-07

  • Start date:

    ASAP

  • Client:

    #

We have an exciting contract opportunity for a BI DATA WAREHOUSE DEVELOPER to be based either in Warrington or Cumbria in the Nuclear Industry

The successful Candidate will help with design and build of a greenfield BI Datawarehouse to support strategic planning


ROLE PURPOSE

Design and Implementation of a SQL 2016 database for extracting and storing business data from multiple business systems to provide a data warehouse upon which strategic business planning models can be constructed

To work with the rest of the team to develop data models and to support the creation of dashboards and reports

Ensuring all work is appropriately documented

Develop and document data management processes

Automate transactional data flows to support the Corporate Planning capability including developing schema and data validation techniques

Manage metadata inventory to ensure data quality, ownership, lineage and currency is maintained


QUALIFICATIONS AND EXPERIENCE

Essential Skills

Professional experience of working with the Microsoft SQL software stack (2016 or above

Proven experience with ETL (extract, transform, load) software, such as SSIS, FME and Alteryx

Have an awareness of Inmon and Kimball data models

Relevant Degree or postgraduate qualification or relevant work based experience

Data modelling and data migration

Good communication skills with the ability to advise others using technical knowledge

Data workflow and process design and implementation experience

Requirements gathering and refining

We would require Security Clearance to BC, SC or DV level, either existing or the ability to undergo Security Clearance

The role can be based either at Risley in Warrington or Whitehaven in Cumbria