£50000 - £520000 per annum + Benefits
Job description

This is a fantastic opportunity for a Data Warehouse Developer / SQL Developer to use the data warehouse and complex sources to develop reporting base tables and views to support Business Partners in organisational reporting sources and the Data Science team in their analysis and visualisation reporting base. You will act as an expert on technical matters and on complex data sets available to the organisation.

What will you be doing in this role?

  • Your role as Data Warehouse Developer will be to analyse, understand, and interpret highly complex data from multiple sources to produce requisite base for reporting layer to support the Business Partners and the Data Science team
  • You're going to be building extremely complex T-SQL code including the use of dynamic SQL to reduce the complexities from reporting layer used by Business Partners and the Data Science team
  • Your remit includes maintaining development of database objects within DevOps using integrated development environment
  • You'll conduct periodic audits of various database objects to ensure that the delivery layer meets organisational reporting demands
  • As the Data Warehouse Developer you will also participate in scoping and understanding the transition of CRM migration between the current system and other systems that the business is migrating to
  • You will identify and solve a range of problems within our current data object delivery
  • You'll also act as an expert on the data systems within the organisation
  • Your role will also involve developing the organisational data mappings and data flows using specialist ERD tools and maintaining organisational data catalogue using specialist tools
  • You will manage the data engineering delivery infrastructure for the business including SQL databases and data warehouse objects
  • You'll work with the IT team to plan and coordinate data engineering deployment and upgrades
  • The Data Warehouse Developer will be responsible for the ongoing performance of database objects
  • As well as this, you will lead on the development and maintenance of the database systems including the underlying design, inform on the ETL processes, and understand data mats design and existing reporting layers
  • Your remit will include coordinating the definition process for Data Engineering standards, guidelines, and principles for all Data Engineering design and solutions within the organisation and you will be responsible for ensuring they are implemented
  • You'll review new datasets and data sources and assess implications for improving the delivery of the base reporting layer

What do you need to apply for this role?

  • Ability to collate, analyse and interpret extremely complex data sources
  • Proven ability explain complex analytical methods to non-analytical people
  • Ability to deliver documentations for complex data flows
  • Ability to manage a workflow and achieve short deadline
  • Intermediate Level of MS Excel, Access, Word, Outlook, Visio and SharePoint
  • Experience of managing multiple databases and DBA knowledge
  • Experience of using ERD tools (e.g. Erwin) to map Data Flows and create a Data Catalogue
  • Experience of designing, developing and managing data warehouses or other complex relational databases
  • Experience of designing, developing and managing ETL Processes
  • Experience of using Power BI and creating reports/analyzing data using it
  • Experience of working with and combining data contained within different data sources
  • Extensive experience of complex SQL code to include development of scripts, functions, procedures, views and dynamic SQL
  • Experience of using and implementing SSRS and SSIS
  • Experience of maintaining database back end processes such as jobs, backups and linked servers

More about Goodman Masson

With a team of over 190 and growing every day, Goodman Masson is one of London’s specialist Finance and Technology recruitment businesses... Read more

Posted on: 13 June 2022
Closed date: 04 July 2022 at 08:57
Job ref: BBBH120390
Tags: IT