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.
- Collaborate with Platform and Backend Engineering teams on end-to-end data flows.
- Support experimentation with advanced analytics, feature engineering, and GenAI-driven insights.
Mandatory Skills & Experience
- 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 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.
#J-18808-Ljbffr
Data Engineer in Basildon employer: Ampstek
Ampstek is an exceptional employer that fosters a collaborative and innovative work culture, where your expertise in D365 Finance & Operations will be valued and nurtured. With a strong focus on employee growth, we offer continuous learning opportunities and the chance to work on impactful global projects, all while enjoying the vibrant atmosphere of our dynamic location.
