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