What you'll doWe are seeking an experienced Data Engineer. The role involves designing ingestion pipelines, optimizing query performance, and ensuring data quality, governance, and cost efficiency at scale (50–300 TB workloads).
Key Responsibilities
- Migration Strategy & Execution
- Design and implement data ingestion pipelines to extract data from Oracle into GCS/Iceberg.
- Migrate and modernize existing Oracle schemas, partitions, and materialized views into Iceberg tables.
- Define CDC (Change Data Capture) strategies using custom ETL.
- Data Lakehouse Architecture
- Configure and optimize Trino clusters (coordinator/worker, Helm charts, autoscaling).
- Design partitioning, compaction, and clustering strategies for Iceberg tables.
- Implement schema evolution, time-travel, and versioning capabilities.
- Performance & Cost Optimization
- Benchmark Trino query performance vs Oracle workloads.
- Tune Trino/Iceberg for large-scale analytical queries, minimizing query latency and storage costs.
- Data Quality, Metadata & Governance
- Integrate Iceberg datasets with metadata/catalog services (Postgre/Hive Metastore, or Glue).
- Ensure compliance with governance, observability, and lineage requirements.
- Define and enforce standards for unit testing, regression testing, and data validation.
- Collaboration & Delivery
- Support existing reporting workloads (regulatory reporting, DWH) during and after migration.
- Document architecture, migration steps, and provide knowledge transfer.
Why we should decide on you
- 5 + years of experience
- Prior experience migrating financial/regulatory datasets.
- Experience with Regulatory Reporting or similar enterprise workloads.
- Familiarity with large-scale performance benchmarking and cost modelling.
Required Skills & Experience
- Core Expertise:
- Strong hands-on experience with Trino/Presto, Apache Iceberg, and Oracle SQL/PLSQL.
- Proven experience with data lakehouse migrations at scale (50 TB+).
- Proficiency in Parquet formats.
- Programming & Tools:
- Solid coding skills in Java, Scala, or Python for ETL/ELT pipeline development.
- Experience with orchestration (Spark).
- Familiarity with CDC tools, JDBC connectors, or custom ingestion frameworks.
- Cloud & DevOps:
- Strong background in GCP (preferred) or AWS/Azure cloud ecosystems.
- Experience with Kubernetes, Docker, Helm charts for deploying Trino workers.
- Knowledge of CI/CD pipelines and observability tools.
- Soft Skills:
- Strong problem-solving mindset with ability to manage dependencies and shifting scopes.
- Clear documentation and stakeholder communication skills.
- Ability to work in tight delivery timelines with global teams.
Why you should decide on us
- Let’s grow together, join a market leading SaaS company – our agile character and culture of innovation enables you to design our future.
- We provide you with the opportunity to take on responsibility and participate in international projects.
- In addition to our buddy-program, we offer numerous individual and wide-ranging training opportunities during which you can explore technical and functional areas.
- Our internal mobility initiative encourages colleagues to transfer cross functionally to gain experience and promotes knowledge sharing.
- We are proud of our positive working atmosphere characterized by a supportive team across various locations and countries and transparent communication across all levels.
- Together we're better - meet your colleagues at our numerous team events.
To get a first impression, we only need your CV and look forward to meeting you in a (personal/virtual) interview!Recognizing the benefits of working in diverse teams, we are committed to equal employment opportunities regardless of gender, age, nationality, ethnic or social origin, disability, and sexual identity.Are you interested? Apply now!https://www.regnology.netR&D_N_2025_02R&D_N_2025_03Apply for this job now
About Us
Regnology is a leading international provider of innovative regulatory, risk, and supervisory technology solutions (RegTech, RiskTech, and SupTech), of AEOI and tax reporting products, as well as of services along the Regulatory Value Chain for financial services. Regnology has been a partner for banks and regulators for 25 years. Until the end of 2020, the company was part of BearingPoint group and operated under the name BearingPoint RegTech. Since the sale of the RegTech business to private equity firm Nordic Capital, the company has been independent. In June 2021, the company joined forces with Vizor Software and recently changed its name to Regnology. In total, Regnology serves more than 7,000 financial services firms with reporting solutions. At the same time, the company enables more than 50 regulators and tax authorities on five continents to collect data from 34,000 firms in 60 countries. Regnology has a total workforce of over 770 employees at 17 office locations in 12 countries.Any questions? Feel free to get in touch:recruiting@regnology.net
