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

East Lothian  ‐ Remote
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Data Modeling Databases Data Warehousing Logical Data Models Normalization Processes Physical Data Models Agile Methodology BigQuery Business Requirements Governance IT Service Management Python (Programming Language) Shell Script SQL Databases SQL Server Integration Services Google Cloud Data Ingestion Collibra Apache Kafka

Description

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:

  • An experienced Data Modeller to help shape migration/reimagining of on-prem applications and Data Models into GCP Data Products
  • 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.

    Start date
    ASAP
    Duration
    6 months
    From
    Project Recruit
    Published at
    09.05.2025
    Project ID:
    2877415
    Contract type
    Freelance
    Workplace
    100 % remote
    To apply to this project you must log in.
    Register