Data Warehouse Engineer

Added: 27 October 2021

Job Location

Hersham, Surrey

Benefits

Private health care, annual performance-related bonus, 25 days annual leave (plus your Birthday) Life Insurance, pension scheme.

Requirements

As Qualco operates within the Financial Services Industry any employment offer is subject not only to the usual legal checks (Right to Work and Proof of Address) but also a clear DBS, adverse financial Employee Credit Check, Employee Electoral Role check plus references from previous employers over the last 10 years (where available).

Summary of position

The role will suit a talented individual, working within our IT team. The team is part of a small but rapidly expanding, ambitious Technology company; working within the Collections & Recoveries sector of the Financial Services Industry. Our clients range from Utilities and Telecoms companies, Banks and Lending companies and our aim is to use our expertise to empower our clients with innovative technology thereby improving their recoveries.

The Data Warehouse Engineer will lead the development of data warehouses and analytics platform as part of our service as a global Asset Management System that provides rich interface and functionalities for our customers.

Key responsibilities

Reporting to the Head of Analysis & Design the candidate will be required to:

  • Work closely with data analysts, data scientists and other data consumers within the business in an attempt to gather and populate the data warehouse table structure which is optimised to support reporting and analytics.
  • Develop, maintain, and support ETL processes.
  • Design, build and configure databases, data warehouses and analytics platform to meet business requirements
  • Work closely with senior stakeholders to understand business requirements for MI and reporting

Required skills/experience

The ideal candidate must be self-motivated with a proven track record in database and warehouse development.

In addition, the ideal candidate will have:

  • Architecture design of data warehouse and analytics platform
  • Cloud data architecture
  • Dimensional Data Modelling
  • Application skills: ETL SSIS, SQL, MDX
  • Excellent ETL skills
  • Excellent SQL database development skills
  • Power BI development
  • Excellent knowledge of databases and security best practices
  • Ability to produce documentation
  • Excellent support and troubleshooting experience
  • Excellent knowledge of all MS Office Products
  • And be an excellent communicator in English (Written and Verbal)

The following knowledge would be beneficial:

  • Data Science / Python / R
  • Knowledge of the Collections & Recoveries Industry
  • Understanding of Data Protection legislation and requirements of standard ISO27001 and ISO9001