Data Engineer (Snowflake & Data Pipelines)SQL / PYTHON
Interested in this role You can find all the relevant information in the description below.
Company: Prize Placements | Location: [Hertfordshire / Remote / Hybrid] | Type: Permanent | Reports to: [Head of Data / Engineering Manager]
About the Role
We are looking for a hands-on Data Engineer to own and develop backend data pipelines. This is a backend engineering role: you will ingest data from a wide range of sources, load it reliably into Snowflake, and make sure it is fresh, monitored and trustworthy.
Key Responsibilities
- Design, build and maintain robust ELT/ETL pipelines that load data into Snowflake from REST APIs, databases, flat files (CSV/JSON) and third-party platforms.
- Develop Python-based ingestion, automation and ETL scripts, including API integrations and scheduled jobs.
- Configure and manage managed or open-source connectors using Fivetran and/or Meltano/Singer (or comparable tooling).
- Write and optimise advanced SQL in Snowflake, including transformations, performance tuning and data modelling.
- Implement pipeline monitoring, logging, alerting and error handling, including data freshness and data health checks.
- Troubleshoot pipeline failures, investigate data quality issues and carry out root-cause analysis.
- Use Git and sound version-control practices (branching, code review, documentation) across all pipeline code.
- Automate operational tasks with Bash/shell scripting where appropriate.
- Contribute to architecture decisions, including the potential future evolution of our backend platform toward Azure / Microsoft Fabric.
- Document data sources, pipelines and operational runbooks.
Essential Skills & Experience
- SQL (advanced): ideally strong Snowflake SQL experience.
- Python (strong): particularly data ingestion, working with APIs, automation and ETL scripting.
- Snowflake: strong hands-on experience.
- ETL/ELT tooling: hands-on experience with Fivetran and/or Meltano/Singer, or comparable ETL/ELT technologies.
- Integrations: solid experience with REST APIs, JSON, CSV and database integrations.
- Bash/Shell scripting: working knowledge.
- Git / version control: day-to-day working experience.
- Operational monitoring: experience with pipeline monitoring, logging, error handling and data freshness/health monitoring.
Desirable Skills
- Experience with dbt. xgikmsk
- Knowledge of Azure and/or Microsoft Fabric, relev...
Remote working/work at home options are available for this role.
Data Engineer (SQL, Python, Snowflake, Data Pipelines) - Hybrid/Hertfordshire - £65,000 + 20% Bonus employer: Prize Placements Careers
Join a dynamic team as an Air Conditioning / Refrigeration Engineer in Sutton, where your expertise will be valued and rewarded with a competitive salary and a supportive work environment. Our company fosters a culture of professional growth, offering ongoing training and development opportunities, while providing you with the tools and resources needed to excel in your role. Enjoy the benefits of working in a diverse range of commercial settings, all while being part of a company that prioritises employee satisfaction and career advancement.
