Data Engineer (SQL, Python, Data Pipelines)
Summary
Hands-on data engineer who designs, builds, and operates ELT/ETL pipelines into Snowflake using Python, Fivetran/Meltano connectors, and advanced SQL, working with analysts and BI teams rather than building dashboards. Permanent hybrid role (up to 3 days WFH) paying £65–70k plus a 20% bonus.
Salary: £65,000 - 70,000 per year
Requirements:- Advanced SQL, ideally with strong Snowflake SQL experience
- Strong Python skills, particularly for data ingestion, API integrations, automation, and ETL scripting
- Strong hands-on experience with Snowflake
- Hands-on experience with Fivetran and/or Meltano/Singer, or comparable ETL/ELT technologies
- Solid experience integrating REST APIs, JSON, CSV files, and databases
- Working knowledge of Bash or shell scripting
- Day-to-day experience with Git and version control
- Experience with pipeline monitoring, logging, error handling, and data freshness and health monitoring
- Desirable: experience with dbt
- Desirable: knowledge of Azure and/or Microsoft Fabric
- Desirable: basic Power BI skills
- Strong problem-solving skills and attention to detail
- An ownership mindset and comfort operating the systems you build
- Clear communication skills, including explaining technical issues to non-technical stakeholders
- A pragmatic approach, with a bias toward automation and maintainable code
- Design, build, and maintain ELT/ETL pipelines that load data into Snowflake from REST APIs, databases, flat files, 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 tools
- Write and optimise advanced Snowflake SQL for transformations, performance tuning, and data modelling
- Implement pipeline monitoring, logging, alerting, error handling, and data freshness and health checks
- Troubleshoot pipeline failures, investigate data quality issues, and perform root-cause analysis
- Use Git and sound version-control practices, including branching, code review, and documentation
- Automate operational tasks with Bash or shell scripting where appropriate
- Contribute to architecture decisions, including the potential future evolution of our backend platform toward Azure or Microsoft Fabric
- API
- Azure
- Backend
- Bash
- ETL
- Fabric
- Fivetran
- Git
- JSON
- Power BI
- Python
- REST
- SQL
- Snowflake
- dbt
- Cloud
More:
At Prize Placements, we are hiring a hands-on Data Engineer for a permanent backend engineering role based in Hertfordshire, with remote or hybrid working options. You will own and develop reliable data pipelines, working closely with analysts and BI colleagues who consume the data; building dashboards and reports is not the focus. The role reports to the Head of Data or Engineering Manager. We offer a salary of £65,000 plus a 20% bonus (£13,000), an excellent pension scheme, 25 days of annual leave rising to 28 days within three years, private medical cover, and flexible working, including up to three days working from home per week.
last updated 44 week of 2026