Senior Data Modeller: Star/Snowflake Schemas & Governance

eTeam; Greater London; Hybrid; GBP 77,000 - 85,000; Full time

Job summary

eTeam is seeking a Data Architect in London with 8+ years of experience to design and implement data models and schemas. The role requires on-site collaboration with architects, engineers, and analysts to deliver robust data solutions and governance.

Hybrid working 2–3 days on-site weekly. The ideal candidate will have strong SQL/RDBMS knowledge, experience with data warehousing, ETL/ELT, and familiarity with cloud platforms (Azure/AWS/GCP).

Qualifications

• Strong expertise in data modelling techniques (3NF, dimensional modelling).
• Proficiency in SQL & RDBMS (SQL Server, Oracle, PostgreSQL, etc.).
• Experience with data modelling tools (ERwin, ER/Studio).
• Knowledge of data warehousing and ETL processes.
• Familiarity with cloud platforms (Azure/AWS/GCP) is a plus.
• Strong analytical and problem-solving skills.
• Good stakeholder communication.
• Attention to detail and data accuracy.

Responsibilities

• Design conceptual, logical, and physical data models
• Build optimized relational and dimensional (star/snowflake) schemas
• Translate business requirements into efficient data structures
• Ensure data quality, integrity, and governance standards
• Collaborate with architects, engineers, and analysts on data solutions
• Support ETL/ELT design and data integration
• Maintain data documentation, metadata, and data dictionaries

Skills

Data modelling

SQL & RDBMS

Strong analytical skills

Attention to detail

Stakeholder communication

Tools

ERwin/ER/Studio

ETL/ELT tools

Job description

eTeam is seeking a Data Architect in London with 8+ years of experience to design and implement data models and schemas. The role requires on-site collaboration with architects, engineers, and analysts to deliver robust data solutions and governance.

Hybrid working 2–3 days on-site weekly. The ideal candidate will have strong SQL/RDBMS knowledge, experience with data warehousing, ETL/ELT, and familiarity with cloud platforms (Azure/AWS/GCP).