Data Engineer at LPL Financial developing Python - based ETL pipelines. Collaborating with cross - functional teams to ensure reliable data delivery and optimizing pipeline performance.
About the role
- Senior Data Engineer at Keyrus focusing on data solutions and projects to drive performance. Collaborating with teams globally to enhance data transformation and governance processes.
Responsibilities
- 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 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, 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
- 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 build 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.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Engineer developing scalable data pipelines for ETL/ELT processes using GCP services. Collaborating with team members to optimize data workflows and ensure data integrity.
Data Governance Engineer in Fintech developing a formal cyber data governance framework. Collaborating with cyber security, analytics, and platform engineering teams on metadata and lineage capabilities.
Junior Data Engineer role at Allegro, focusing on developing ETL/ELT pipelines and processing large datasets. Collaborate with cross - functional teams for data quality and reporting.
Data Engineer at Concept Reply developing innovative data - driven solutions in IoT. Collaborating with teams to unlock the potential of data and cloud computing.
Data Engineer creating and managing data pipelines for critical data solutions at S&P Global. Collaborating on enterprise - scale data processing in a supportive, innovative environment.
Data Engineer supporting and evolving data environment in cloud migration. Maintain and optimize existing databases while designing modern data solutions with cross - functional collaboration.
Senior Data Engineer responsible for data pipeline projects at Suprema Gaming. Focus on batch and streaming data solutions while collaborating with business teams.
Senior data leader managing the enterprise data architecture at Breakthru Beverage. Leading high - performing teams in data engineering and defining modern data strategies.
Data Engineer at Equinix implementing data architecture solutions for scalability and analytics. Collaborating with teams to design data pipelines and maintain data models for business objectives.