Senior Data Engineer – Snowflake

Keyrus

Senior Data Engineer at Keyrus specializing in Snowflake data solutions. Collaborating with global teams to deliver impactful projects in data engineering.

Posted 5/16/2026full-timeLondon • 🇬🇧 United KingdomSenior💰 £58,000 - £87,000 per yearWebsite

Tech Stack

Tools & technologies

AWSAzureCloudPythonSQL

About the role

Key responsibilities & impact

Understand client needs and lead delivery end‑to‑end — proposing solutions that solve real business problems across ingestion, transformation, governance, and activation
Build and manage scalable pipelines using Snowflake, Fivetran, Gong REST APIs, and Snowpipe
Configure AWS S3 raw landing zones and Snowflake External Stages to ensure a durable, immutable raw data layer
Deal with semi-structured data and expertly manage JSON/VARIANT payloads in Snowflake, implementing "schema-on-read" patterns to protect against upstream API changes
Architect complex dbt models to parse, flatten, and normalize VARIANT data into structured tables
Implement logic to merge issuer entities, contact records, and learner profiles across disparate systems to create a "Golden Record"
Build semantic layers for predictive metrics, including Engagement Scores, Sentiment Trends, and Churn Risk
Leverage Snowflake Cortex AI for predictive scoring and surfacing insights
Maintain Governance and Security by implementing Role-Based Access Control (RBAC), PII masking (Dynamic Data Masking), and Row-Level Security (RLS) across the Snowflake environment
Support clients in their data and digital transformation journeys

Requirements

What you’ll need

8+ years of experience in data engineering
Proven experience in Snowflake (expert level: Snowpipe, Access History, Lifecycle Tags, Cortex AI, External Stages)
Strong hands-on experience with dbt (expert in modular modelling, documentation, testing)
Ability to integrate the deployment pipeline using git based tools
Experience in building ingestion pipelines using AWS S3, Fivetran, Snowpipe, and REST APIs
Expertise in Cloud-based architecture (e.g. Azure, AWS)
Strong analytical and problem-solving skills, especially in handling JSON/VARIANT and schema-on-read patterns
Advanced SQL skills (Jinja2 templating is a plus) and working experience with Python for API interactions
Demonstrate strong ownership and work independently, taking responsibility for full-project delivery
Ability to communicate clearly with both technical and non-technical stakeholders
Fluency in English.

Benefits

Comp & perks

Competitive holiday allowance
Private Medical & Dental Insurance (Bupa)
Group Life Insurance
Gym & fitness discounts via Pluxee (Sodexo)
On-site gym access at our London office
Access to lifestyle discounts (travel, retail, entertainment & more) via Pluxee (Sodexo)
Auto-enrolment pension scheme with Aegon
Training & Development via KLX (Keyrus Learning Experience)
Strong focus on career development and internal mobility
Electric & hybrid car scheme via Tusker
Annual discretionary bonus, based on individual and company performance
Referral bonus for introducing new colleagues.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data engineeringSnowflakedbtAWS S3FivetranREST APIsSQLPythonJSONVARIANT

Soft Skills

analytical skillsproblem-solving skillsownershipindependencecommunication skills