Lead Senior Data Engineer – Snowflake

🕒 April 28

🏢🏡 London – Hybrid

💵 £58k - £87k / year

⏰ Full Time

🟠 Senior

🚰 Data Engineer

🇬🇧 UK Skilled Worker Visa Sponsor

This company has sponsored UK Skilled Worker visas in the past.

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Keyrus

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1996

🤝 B2B

B2B • Data Analytics • Consulting

Keyrus is an international company passionate about leveraging data to make impactful changes in life, society, and the future. With a presence in 18 countries, Keyrus is dedicated to creating meaningful careers for its employees by fostering excellence, trust, creativity, kindness, and fun. Specializing in data analytics, data advisory, and management, Keyrus provides vendor-agnostic solutions and continuous training opportunities through its KLX platform. The company also emphasizes a healthy work-life balance with a range of benefits, including sports events, healthcare plans, and an inclusive work culture. Keyrus is committed to openness and transparency to maintain positive workplace relationships and is driven to innovate and influence the digital future.

📋 Description

• 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

• 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

• 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.