GCP Senior Data Modeller/Business Architect

Avance Consulting; City of Edinburgh; On-site; GBP 45,000 - 70,000; Full time

Job summary

An established industry player is looking for a skilled Data Modeller to lead the migration of on-premises applications to innovative GCP Data Products. In this exciting role, you will create and optimize data models, ensuring they align with business requirements and enterprise standards. Your expertise in tools like ER Studio and Google Cloud Platform will be crucial in guiding data governance and enhancing data accessibility. Join a forward-thinking team dedicated to transforming data solutions and making a significant impact in the cloud landscape.

Qualifications

• Experience in data modelling for cloud migration and application reimagining.
• Proficiency in enterprise data modelling techniques and governance processes.

Responsibilities

• Drive data modelling aspects of solution design to meet business needs.
• Create and develop logical and physical data models optimized for performance.

Skills

Data Modelling

Advanced SQL

Python

Unix Shell Scripting

ER Studio

Google Cloud Platform

Tools

BigQuery

SSIS

Kafka

Job description

Job Title: Data Modeller

We are seeking an experienced data modeller to assist in the migration and reimagining of on-premises applications and data models into GCP Data Products.

Key Responsibilities:

1. Drive and ensure that data modelling aspects of solution design meet business requirements.
2. Create conceptual data models aligned with the Enterprise Data Model.
3. Develop logical data models and schemas.
4. Design physical data models and schemas optimized for performance and access.
5. Define mappings between physical and logical data models.
6. Guide Data Models through the governance process.
7. Register GCP Data Products in Collibra.
8. Apply enterprise data modelling techniques such as de-normalised views and star schemas.

Key Skills, Knowledge, and Experience:

• Proficiency in ER Studio.
• Knowledge of Google Cloud Platform components like GCS buckets, BigQuery, Kafka, etc.
• Experience with advanced SQL, SSIS packages, Python, and Unix Shell scripting.

* Free services are subject to limitations.