Senior Snowflake Data Engineer

🌍 About Keyrus

Keyrus is a global consulting and technology company focused onmaking data matter — truly matter — from a human perspective.

Founded in 1996, Keyrus operates in28+ countries across 5 continents, with more than3,300 people worldwide. Our strength comes from combining deep expertise inData & Analytics, AI, Digital, and Management Consulting with a strong understanding of business realities.

Data is never the goal in itself.
We use data toshape understanding, design meaningful experiences, and enable better, real-life decisions.

At Keyrus, we also believe companies have a responsibility beyond performance. Through ourFoundation and ESG initiatives, we actively contribute to sustainability, inclusion, and positive societal impact.

#OneTeamOneKeyrus

🎯 The Role

As aSenior Data Engineer, focused on Snowflake, you will work at the intersection ofdata, technology, and business, helping our clients turn complexity into clarity and insights into impact.

You will collaborate with multidisciplinary teams in an international environment and contribute to projects that driveperformance, innovation, and sustainable growth.

📍Job location: London, UK (Hybrid, 3 days on-site)
🕒Contract type: Permanent
🗓Target start date: May 2026
⏰Working hours: Full-time (40h/week)
💵Compensation:£58k to£87k gross/year

Note: All applications must be submitted in English.

💥 Your Impact

In this role, you will:

• 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 usingSnowflake,Fivetran,Gong REST APIs, andSnowpipe.

• ConfigureAWS S3 raw landing zones and Snowflake External Stages to ensure a durable, immutable raw data layer.

• Deal with semi-structured data and expertly manageJSON/VARIANT payloads in Snowflake, implementing "schema-on-read" patterns to protect against upstream API changes.

• Architect complex dbt modelsto parse, flatten, and normalise 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, includingEngagement Scores, Sentiment Trends, and Churn Risk.

• LeverageSnowflake Cortex AI for predictive scoring and surfacing insights.

• Maintain Governance and Securityby implementingRole-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

⚡ What Makes This Role Challenging

• You will work incomplex, evolving client environments

• You are expected to balancedelivery quality with pragmatism

• You will collaborate with diverse profiles across functions and cultures

• Autonomy increases with seniority — so does responsibility

👤 What We’re Looking For

Must-haves

• 8+ years of experiencein data engineering

• Proven experience inSnowflake (expert level: Snowpipe, Access History, Lifecycle Tags, Cortex AI, External Stages).

• Strong hands‑on experience withdbt (expert in modular modelling, documentation, testing).

• Ability to integrate the deployment pipeline using git based tools.

• Experience in building ingestion pipelines usingAWS S3,Fivetran,Snowpipe, andREST APIs.

• Expertise in Cloud-based architecture (e.g. Azure, AWS)

• Strong analytical and problem‑solving skills, especially in handlingJSON/VARIANT and schema‑on‑read patterns.

• AdvancedSQL 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 inEnglish

Nice-to-haves

• Familiarity withDatabricks for data engineering, notebook workflows, or distributed processing

• Experience handlingCI/CD pipelines for data workloads (e.g., GitHub Actions, GitLab, Azure DevOps, or similar)

• Knowledge ofgovernancepractices, including PII handling, RBAC, RLS, and data cataloguing

• Understanding of reverse ETL concepts and tools

• Experience withData Viztools for analytics and dashboarding (e.g. Qlik, Power BI)

• Experience inconsultingenvironments andmentoring

• Ability to championbest practicesand keep up with innovations and trends on the data landscape.

💰 How Our Salary Ranges Work

At Keyrus, salary ranges reflectdifferent levels of mastery and impact within the same role — not different job titles.

• Bottom of the range
  You meet the core requirements and will need ramp-up time and support.

• Middle of the range
  You are fully autonomous from Day 1 and deliver consistently.

• Top of the range
  You are a reference for the role, mentor others, and raise the bar for the team.

Final offers are based onexperience, autonomy, scope, and market context, and are discussed transparently during the process.

🎁 What We Offer at Keyrus UK

• Competitive holiday allowance

• Private Medical & Dental Insurance (Bupa)

• Group Life Insurance

• Gym & fitness discounts viaPluxee (Sodexo)

• On-site gym access at our London office

• Access tolifestyle discounts (travel, retail, entertainment & more) viaPluxee (Sodexo)

• Auto-enrolment pension scheme with Aegon.

• Training & Development via KLX (Keyrus Learning Experience)

• Strong focus oncareer development and internal mobility.

• Electric & hybrid car scheme viaTusker

• Annual discretionary bonus, based on individual and company performance

• Referral bonus for introducing new colleagues.

💙 Why Keyrus?

Joining Keyrus means joining:

• Amarket leader in Data Intelligence

• A company wherepeople, trust, and diversity are core values

• An environment that valuesownership, flexibility, and innovation

• A place where different backgrounds and perspectives are not just welcomed = they are essential

We believe diversity drives better thinking, stronger teams, and better outcomes.
Everyone belongs at Keyrus.

♿ Equal Opportunity Statement

We are committed to building an inclusive workplace and encourage applications from all backgrounds, regardless of race, ethnicity, gender identity, sexual orientation, age, disability, or any other protected characteristic.