DWH Developer

Updated: about 1 month ago
Location: United Kingdom,
Job Type: FullTime
Deadline: 24 May 2021

Job Profile IT - Application Development
Contract Type Permanent

Job Purpose

The successful candidate will be responsible for developing data warehouse, ETL and database components in the BPP Architecture. Ensuring all work is carried out to the highest standard following industry best practices following the BPP SDLC process. To contribute to and be responsible for the continuous change and Never Stand Still attitude of the IT Department and business as a whole.

Key Responsibilities:

  • Estimate, Develop, Unit test and Document of all data warehouse, ETL, application and general database related components in line with BPP Architecture.
  • Taking ownership of the data warehouse development and support in the data layers of the warehouse, these being staging replica, third normal form and marts layers.
  • Acting as an SME on all the ETL jobs and data feeds, including design, development, scheduling and monitoring.
  • Design data models and contribute to the BPP Architecture as required to support the BI / MI reporting platforms and other key platforms such as Salesforce.
  • Performance tuning of database components and ETL jobs/feeds as required.
  • Producing ad-hoc data extracts, data patches and data uploads as required.
  • Contribute to the development team and squad on all activities during the sprint including development of user stories and defects, peer code reviews/feedback, backlog requirements refinement, QA validation, releases, deployment, sprint review and retrospective sessions.
  • Ensure all development is carried out in line with the BPP SDLC, coding standards and guidelines.
  • Identifying root cause of productions issues and defects, recommending paths to resolve, and fixing where appropriate.
  • Providing continual support to business-critical applications, components and processes, and assist application support, service desk and other relevant teams where needed.
  • Liaise with the business, QA and other relevant teams to clarify and

Department Technology - Development
Vacancy location UK, Home Based, Home Based

Candidate Criteria

Essential

  • Qualified to BSc/BA level with a highly technical, programming or a Computer Science related degree
  • Significant experience in a similar development role

Demonstrable skills in the following areas;

  • Oracle PL/SQL and/or T-SQL
  • Experience of Oracle, MS SQL, MySQL
  • Solid experience of ETL technologies such as Informatica Power Center, SSIS, Talend etc.
  • Experience of designing, ERDs and modelling
  • Experience of data analysis and lineage models
  • Experience of Unix/Linux and shell scripting
  • Solid understanding of RDBMs and N-tier architecture
  • Transactional Databases (OLTP)
  • Analytical Databases (OLAP)
  • Business-focused with the ability to quickly understand a problem or situation and develop an approach to drive forward solutions.
  • Demonstrable ability to apply relevant industry and process standards to all tasks undertaken.
  • Dedicated to ensuring own technical skills and specialisations are kept up to date in line with industry developments
  • Effective communication skills suitable for the management of and liaison with departmental staff and senior management, both on a one to one and one to many basis.
  • A strong team player, willing to share knowledge, drive ideas and solutions and provide quality information

Desirable

  • Experience of AWS, Azure and cloud platforms
  • Solid understanding of RDBMs and N-tier architecture
  • Transactional Databases (OLTP)
  • Analytical Databases

Employment Details

Contract Hours 37.50
FTE 1.00
Salary Competitive


View or Apply

Similar Positions