Data Modeller

🔒 Confidential Employer
Posted 16 October 2026
LOCATION
Edinburgh
TYPE
Full-time
LEVEL
Mid-Senior level
CATEGORY
Technology
This role is not offered with visa sponsorship, though the employer is a licensed UK sponsor

SKILLS

Data Modelling SQL Dimensional Modelling Cloud Platforms Data Governance Stakeholder Management Databricks Data Vault

FULL DESCRIPTION

Data Modeller

Company: [Employer hidden — view at passion-project.co.uk] | Location: Edinburgh (Hybrid) | Job Type: Permanent | Contact: Gary Simpson - [contact hidden]

The Role

  • Design and maintain conceptual, logical and physical data models.
  • Work with business and technical stakeholders to define and document data requirements.
  • Develop enterprise-wide data models that support operational, analytical and reporting needs.
  • Support data architecture and governance initiatives.
  • Ensure data models align with business strategy, regulatory requirements and data standards.
  • Collaborate with Data Engineers, Architects, Analysts and Business Intelligence teams.
  • Contribute to data migration, transformation and integration projects.
  • Promote best practices in data modelling, metadata management and data quality.
  • Provide guidance and mentoring to junior team members where required.
  • Support clients throughout the full project lifecycle, from discovery through to implementation.

Required Experience

  • Proven experience as a Data Modeller within complex enterprise environments.
  • Strong understanding of conceptual, logical and physical data modelling techniques.
  • Experience designing data models for data warehouses, data lakes and modern cloud data platforms.
  • Expertise in dimensional modelling methodologies, including star and snowflake schemas.
  • Strong SQL skills and experience working with relational databases.
  • Experience with data modelling tools such as ERwin, ER/Studio, Sparx EA or similar.
  • Knowledge of data governance, metadata management and data quality frameworks.
  • Experience working with cloud-based platforms such as Azure, AWS, Google Cloud or Snowflake.
  • Excellent stakeholder management and client-facing skills.
  • Strong analytical, problem-solving and communication abilities.

Desirable Experience

  • Experience with Databricks and modern lakehouse architectures.
  • Knowledge of Data Vault modelling methodologies.
  • Experience supporting Master Data Management (MDM) initiatives.
  • Exposure to data engineering, ETL/ELT and integration technologies.
  • Experience within Financial Services or other highly regulated sectors.

Personal Attributes

  • A confident consultant with excellent client-facing skills.
  • Collaborative and able to work effectively both independently and within teams.
  • Proactive, self-motivated and solutions-focused.
  • A strong communicator with excellent presentation skills.
  • Creative in their approach to solving complex data challenges.
  • Passionate about continuous learning and professional development.
  • Comfortable working in dynamic and fast-paced project environments.
Sign up free — access 45,000+ UK sponsor-licensed jobs