A large financial services organisation serving Benelux markets is consolidating its front-office analytics platform and needs a senior engineer to build and operate the data foundation. The role sits in the IT Front Data Team and focuses on building and running ETL/ELT pipelines using AWS Glue, S3 and Redshift, with heavy use of Python and advanced SQL to deliver reliable datasets for reporting and analytics.
The mission
The immediate work covers delivery for projects such as Transparency, Arizona and Verdi alongside BAU support. The technical landscape is an AWS-centric data platform: S3 as the data lake, Glue for transformation, Redshift for serving curated datasets, and orchestration to schedule and monitor pipelines. The outputs matter because these datasets feed regulatory reports, business intelligence and product analytics used across trading and front-office reporting.
Day to day you will design, implement and operate batch pipelines from ingestion to serving, own data models (dimensional and Data Vault patterns) for reporting, and tune complex SQL queries and Redshift performance. You will be responsible for production job reliability: troubleshooting failures, implementing fixes, coordinating releases and onboarding new data sources with source-system owners and business analysts.
Your responsibilities
- Design and deliver robust ETL/ELT data pipelines that deliver analytically ready datasets for reporting and BI
- Optimize and tune complex SQL queries and Redshift table designs to reduce run-times and cost
- Operate and monitor production jobs, perform root-cause analysis and implement permanent fixes to incidents
- Define and implement data models (dimensional and Data Vault) and maintain documentation for dataset consumers
- Collaborate with project managers, business analysts and source-system owners to translate requirements into data products
- Automate routine tasks and orchestration to improve reliability and reduce manual interventions
Your profile
Essential skills
- Proven track record as a senior BI / Data Engineer, 10+ years of professional experience in data engineering roles
- Strong hands-on experience with AWS Glue, AWS S3 and Amazon Redshift in production environments
- Expert-level SQL skills, able to write and optimise complex queries across large datasets
- Proficient in Python for data transformation, testing and automation
- Practical experience building and maintaining ETL/ELT pipelines and data ingestion workflows
- Experience with data modelling approaches such as dimensional modelling and Data Vault
- Able to work independently, prioritise work, and communicate clearly with technical and non-technical stakeholders