Ampstek
Snowflake Data Engineer

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Job Title: Snowflake Data Engineer
Location: Basildon, UK
Work Mode: Fully Onsite
Contract Duration: Long-term engagement until 31 July 2027, based on performance
Role Summary
We are looking for an experienced Snowflake Data Engineer / Risk & Data Engineer to support the development and scaling of data platforms for risk, fraud intelligence, analytics, and regulatory reporting.
The ideal candidate will be a strong hands-on individual contributor with proven production experience in Snowflake, AWS, large-scale data pipelines, and real-time or near-real-time data processing. This role will focus on scaling and optimizing existing data platforms rather than purely greenfield development.
You will work closely with Risk, Product, Backend, and Platform Engineering teams to build data pipelines, analytical models, and fraud intelligence capabilities supporting MRV/MRD platforms.
Key Responsibilities
- Design and develop Snowflake-based data models for fraud detection, monitoring, and regulatory reporting.
- Build, maintain, and optimize ETL/ELT pipelines using Snowpipe, Streams, Tasks, and Stored Procedures.
- Develop scalable real-time and batch data pipelines.
- Work with event-driven and message-based technologies such as Kafka and/or Amazon SQS.
- Partner with Risk and Fraud stakeholders to implement rule-based and analytical fraud detection logic.
- Ensure strong data quality, lineage, monitoring, auditability, and governance across data workflows.
- Perform advanced SQL performance tuning and Snowflake warehouse optimization.
- Optimize data platform scalability, performance, and cost.
- Work with dbt for data transformation and modelling workflows.
- Implement CI/CD-driven data engineering workflows using GitHub, AWS DevOps, or Azure DevOps.
- Collaborate with Platform and Backend Engineering teams on end-to-end data flows.
- Support experimentation with advanced analytics, feature engineering, and GenAI-driven insights.
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Mandatory Skills & Experience


Get help with your application
Your very own career expert that helps elevate your application to the next level.
- 4+ years of hands-on Snowflake development experience.
- Strong experience in Snowflake data modelling and transformation workflows.
- Strong hands-on experience with:
- Snowpipe
- Streams
- Tasks
- Stored Procedures
- Advanced SQL skills, including performance tuning and query optimization.
- Strong experience optimizing Snowflake warehouses, performance, and cost.
- Production experience with AWS data platforms and pipelines.
- Hands-on experience with Kafka and/or Amazon SQS.
- Experience with ETL/ELT pipelines at scale.
- Experience with dbt for data transformation workflows.
- CI/CD and version control experience using GitHub, AWS DevOps, or Azure DevOps.
- Strong understanding of:
- Data Quality
- Data Lineage
- Data Monitoring
- Data Governance/Auditability
- Exposure to Fraud, Risk, Compliance Analytics, or other rule-driven analytical systems.
- Experience with Python and/or Java for data processing or integration.
- Experience scaling and optimizing existing production data platforms.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London