GCP Senior Data Modeller/Business Architect/GCP Data Analyst/SME

Our client, a leading global supplier for IT services, requires experienced GCP Senior Data Modeller/Business Architect/and GCP Data Analyst/SME to be based in their client's offices in London or Edinburgh, UK.

This is a hybrid role, and you may be able to work some days remotely.

This is a 6 month temporary contract, to start ASAP.

Day rate: Competitive Market rate.

The client is looking for:

1. An experienced Data Modeller to help shape migration/reimagining of on-prem applications and Data Models into GCP Data Products
2. An experienced Data Analyst to analyse the existing Database or Data Warehouse jobs and work with Data Modeler in designing the Data Products on GCP

Key Responsibilities:

GCP Senior Data Modeller/Business Architect:

• Drive and ensure that data modelling aspects of solution design meet the business requirements
• Create conceptual data models and align to Enterprise Data Model
• Create logical data models and schemas
• Create physical data models and schemas that support performance and access requirements
• Define the mappings between physical and logical data models
• Help the designed Data Models take through the governance process
• Register the GCP Data Products in Collibra

GCP Data Analyst/SME:

• Back trace the Database or Data Warehouse jobs and prepare STTM (Source-To-Target Mapping) sheets
• Identify the source and downstream systems corresponding to system in scope of migration/re-imagination
• Identify the data ingestion and data consumption patterns and define the target state requirements
• Help the Data Modeler in designing Enterprise Data Products

Key Requirements:

• Knowledge in ER Studio
• Knowledge of Google Cloud Platform (including components such as GCS buckets, BigQuery, Kafka etc)
• Knowledge of enterprise data modelling techniques such as de-normalised views, star schemas etc
• Knowledge of Data de-normalization and normalization techniques
• Knowledge in Advanced SQL, SSIS packages, Python and Shell Scripting
• Should understand the Data Model terminology (Conceptual Data Model, Logical Data Model, Physical Data Model)
• Experience in Agile Methodology
• Client facing and team member skills

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.