Data Designer

Data Designer

Our client, a leading global supplier for IT services, requires Data Designer to be based at their client's office in London, UK.

This is a hybrid role - you can work remotely in the UK and attend the London office 3 days per week .

This is a 6+ month temporary contract to start ASAP

Day rate: Competitive Market rate

The Data Designer role supports the business by deciding what data should be ingested from source systems into the Enterprise Data Warehouse, and how this data should be transformed to make it suitable for consumption in reporting or other downstream systems.

The role is accountable for: analysing and documenting source systems' data as needed to meet the business requirements; determining the method and frequency for ingesting the data into the data warehouse; defining and documenting any data mapping, harmonisation, derivations, calculations, or other transformations required to make the data easy to use by the business; ensuring that the target data model is coherent and works in conjunction with the other data models in the data warehouse.

Key Responsibilities

• Designing data warehouse solutions driven by business demand.
• Understanding difficult solution requirements, working with the business to clarify them if necessary.
• Identifying and documenting the possible data sources that may be required and analyse/profile the data they contain; working with the source system and/or business experts to understand how the business processes create and update data.
• Creating and maintaining logical and physical data models for the data warehouse solutions, working with the Platform Data Architect to ensure they fit with the data roadmap and principles.
• Creating and updating source to target data mappings, defining transformations and calculations, and capturing metadata (eg attribute definitions, datatypes, PII classification, etc.) working with the Platform Principal Data Designer to make sure they are in line with our principles and conventions.
• Supporting Data Engineers in the implementation of the designs.
• Supporting Quality Engineers in the testing of the data warehouse objects.
• Providing guidance to junior members of the team on data modelling and/or technical best practices.
• Supporting the wider team with other ad-hoc design or analysis work.

Key Requirements

Essential Skills:

• 5-7 years of experience as a data modeller/data architect, with proven experience in modelling high-complexity data
• Data quality management experience
• Data life cycle management experience
• Experience in working with non-tabular data and event-based data processing
• Advanced-level SQL querying
• Strong attention to detail
• A collaborative approach to work

Desirable Skills:

• Experience of non-tabular data and event-based data processing.
• Understanding of data life cycle management.
• Experience of working with data in Databricks.

Due to the volume of applications received, unfortunately we cannot respond to everyone.

If you do not hear back from us within 7 days of sending your application, please assume that you have not been successful on this occasion.