Data Modeler
New Exciting role for Data Modeller
Location: London (Hybrid – 2 days onsite)
Contract: 6 Months
IR35 Status: Inside IR35
The Role
We are seeking an experienced Data Modeller to define and design the foundational data structures that enable scalable, insight-driven digital ecosystems. You will play a key role in shaping data architectures across complex transformation programmes, ensuring data models support integration, analytics, and AI-driven decision-making.
Working with modern cloud platforms and high-quality datasets, you will collaborate closely with engineering, analytics, and architecture teams to build secure, scalable, and well-governed data solutions that drive business value.
Your Profile
Essential Skills & Experience
- Strong experience designing conceptual, logical, and physical data models on cloud platforms (ideally GCP)
- Hands-on expertise with BigQuery, including performance optimisation (partitioning, clustering, cost efficiency)
- Proven experience with data modelling techniques: 3NF, dimensional (Kimball), Data Vault, and Lakehouse patterns
- Ability to translate complex domain requirements (e.g., Customer, Payments, Risk, Finance) into scalable models
- Experience creating data products with trusted definitions (facts, dimensions, conformed dimensions)
- Strong understanding of data governance, metadata management, lineage, and data quality frameworks
- Proficiency in data modelling tools such as ER/Studio, ERWin, PowerDesigner, or similar
- Experience managing model versioning, artefacts (ERDs, schema scripts), and change control
- Knowledge of GCP services (BigQuery, Dataflow, Pub/Sub, Cloud Storage) and data ingestion patterns
- Strong SQL skills and experience in data profiling and validation