Data Modeller

Experience modelling data in Snowflake or a comparable modern cloud warehouse/lakehouse

Business entity discovery

Conceptual and domain data modelling

Interaction, dependency and data-flow modelling

Logical data modelling

Physical and dimensional data design

Canonical and semantic modelling, including shared business measures and definitions

Data product schema and data contract modelling

Metadata management, business glossary and data catalogue integration

Source-to-target mapping and transformation logic

Strong SQL and data querying capability

Use of established modelling tools and repositories, with the ability to maintain versioned, reusable artefacts

The type of candidate that we’re looking for:

We’re looking for an experienced Data Modeller who can work across business and technology teams to understand key concepts, relationships and definitions, and turn them into clear, practical models that people can genuinely use. You’ll have experience across conceptual, logical and physical data modelling, with a good understanding of how these support data products, analytics and modern data platforms.

You’ll be naturally collaborative and comfortable working with domain experts, architects, analysts and engineers to build a shared understanding of data across the organisation. Experience with Snowflake or similar cloud data platforms, SQL, data catalogues, metadata, source-to-target mapping and modelling tools will be useful. Above all, we’re looking for someone who can combine attention to detail with a pragmatic mindset, communicate complex ideas simply and create models that remain useful as the organisation evolves.

Critical Skills

Data Literacy

Systems Thinking

Storytelling

Nurture Relationships

Team Working

Should you choose to use AI tools to support your application, we ask that you do this thoughtfully. We encourage you to ensure your application reflects your own voice, experience, and motivations. We value authenticity and want to understand your individual strengths and perspectives.

At Baillie Gifford, we are committed to fostering an inclusive and respectful culture in which each of our colleagues can thrive and develop. We believe that our clients are best served by a diverse workforce with the experiences, ideas and perspectives that this brings.

If you are currently working at Baillie Gifford as an employee or contractor please apply to this job from the firm's Workday internal career site.