Data Modeller – Dimensional Modelling / 3NF / ERwin

GIOS Technology; Greater London; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

GIOS Technology Limited is seeking a data modelling specialist in London with expertise in conceptual, logical, and physical data models. You will work with SQL Server, Oracle and PostgreSQL, and leverage ERwin/ER/Studio to shape data warehouses and governance.

You will collaborate with architects, engineers and stakeholders to translate business requirements into robust data structures, ensuring scalable and compliant data designs in a hybrid London setting.

Qualifications

• Proven experience designing conceptual, logical and physical data models.
• Prowess in relational and dimensional modelling (3NF, Star, Snowflake).
• Strong SQL and RDBMS knowledge (SQL Server, Oracle, PostgreSQL).
• Experience with data modelling tools such as ERwin and ER/Studio.

Responsibilities

• Translate business requirements into efficient data structures and models.
• Collaborate with architects, engineers and stakeholders to deliver data solutions.
• Support data warehousing, ETL/ELT processes, data quality and governance.

Skills

Data modelling

Dimensional modelling

SQL & RDBMS

ERwin & ER/Studio

Data warehousing

ETL/ELT

Data governance

Cloud platforms familiarity

Tools

ERwin

ER/Studio

Job description

Location: London, UK – Hybrid (2–3 days onsite)

• Proven experience designing conceptual, logical and physical data models.
• Strong hands-on experience with relational and dimensional data modelling, including 3NF, Star and Snowflake schemas.
• Excellent knowledge of SQL and RDBMS, including SQL Server, Oracle and PostgreSQL.
• Experience using data modelling tools such as ERwin and ER/Studio.
• Strong understanding of data warehousing, ETL/ELT processes, data quality and data governance.
• Ability to translate business requirements into efficient data structures and collaborate with architects, engineers and stakeholders.
• Familiarity with Azure, AWS or GCP cloud platforms is an advantage.