Snowflake Data Modeler/Lead Engineer - Snowflake AI & Semantic Modelling

Project overview

Snowflake Data Modeler/Lead Engineer - Snowflake AI & Semantic Modelling

Responsibilities

Experience Required

Experience with the COCO SDK or comparable context and agent integration frameworks is advantageous.

• Design, build and maintain enterprise-scale Snowflake data models and semantic layers.
• Implement Snowflake Cortex AI capabilities to support business analytics and AI-enabled data consumption.
• Develop and manage semantic models that enable AI tools and agents to access trusted, governed business data.
• Modify and extend existing semantic models as business definitions, reporting requirements and data structures evolve.
• Implement Cortex Analyst and Cortex Search capabilities in appropriate business use cases.
• Support agentic development and the integration of AI agents with Snowflake data, semantic assets, APIs and governed tools.
• Establish AI-ready data foundations through high-quality data products, metadata, lineage, governance and contextual enrichment.
• Develop reusable Finance measures and analytical definitions across Revenue, Spend and GL use cases.
• Lead technical design, code reviews, engineering delivery and collaboration with Finance and data stakeholders.
• Ensure data models are secure, performant, reliable, auditable and fit for enterprise use.
• Typically 10-15 years of experience across data warehousing, data modelling, data engineering or BI platforms.
• Strong, demonstrable hands-on Snowflake and advanced SQL experience.
• Proven delivery of Snowflake semantic models and AI-enabled data solutions.
• Practical implementation experience across the relevant Cortex and agentic capabilities.
• Experience translating complex business requirements into scalable data models and reusable analytical definitions.
• Strong communication skills and the ability to work independently with technical teams and business stakeholders.

Project details

UK - Fully Remote

Contract: 12 months, with possible extension

Up to £580 per day

IR35: Inside IR35 - contractors only

Role Overview

We are seeking an experienced Snowflake Data Modeler/Lead Engineer with strong hands-on experience in enterprise data modelling and critically, the practical implementation of Snowflake AI capabilities in real-world environments.

The successful candidate must be able to design and build robust data models while leveraging Snowflake AI features to develop, manage, modify and extend semantic models as business requirements evolve.

The client is particularly focused on experience across Snowflake Cortex AI, Cortex Analyst, Cortex Search, Agentic Development and Semantic Modelling. Candidates must be able to demonstrate how they have implemented these capabilities in live projects, rather than simply having theoretical knowledge or general exposure to AI.

The role will involve working closely with Finance and data stakeholders to deliver governed, AI-ready data models supporting Revenue, Spend, General Ledger (GL) and other financial reporting requirements.

Mandatory Technical Requirements

Candidates must demonstrate practical, hands-on experience in the following areas:

Finance and Business Domain

Experience working with Finance or regulated-industry data is highly desirable, particularly:

• Snowflake Cortex AI: Experience implementing Snowflake Cortex AI capabilities in real-world business scenarios.
• Cortex Analyst: Hands-on experience implementing or configuring Cortex Analyst for natural-language analytics and querying structured business data.
• Cortex Search: Practical experience implementing Cortex Search for enterprise search and retrieval use cases.
• Agentic Development: Experience developing or integrating AI agents with enterprise data platforms, semantic models, APIs or governed tools.
• Semantic Modelling: Proven ability to design, build, manage and maintain Snowflake semantic models, including entities, relationships, metrics and reusable business definitions.
• AI-driven semantic model development: Experience using Snowflake AI features and tools to create, refine, modify and extend semantic models in response to changing business requirements.
• Snowflake Engineering: Strong hands-on Snowflake experience, advanced SQL, data transformations, dynamic tables, views and performance optimisation.
• Enterprise Data Modelling: Experience designing logical, physical and dimensional models, including facts, dimensions, aggregates and hierarchies.
• Data Quality and Governance: Experience with data validation, reconciliation, metadata, lineage, access controls, security and auditability.
• General Ledger (GL) and financial reporting.
• Profit and Loss (P&L) measures.
• Revenue and Spend reporting.
• Finance measures, reconciliations and drill-down analysis.
• Source-to-target mapping, ETL/ELT pipelines and transformation logic.
• Start: flexible
• Location: United Kingdom, GB
• Rate: 73-73 EUR/h