Description The OpportunityWe are supporting a majordata platform transformation within a banking environment , moving from a legacy SQL Server and SSIS-based setup to a modern, scalable architecture built ondbt, Dagster, and OpenShift . This role is not about maintaining existing systems. It is aboutrebuilding a critical data platform from the ground up , with direct impact onrisk, trading PnL, and core financial data flows . We are looking for ahands-on Senior Data Engineerwho can take ownership of complex migration workstreams and deliver reliably in a regulated, high-stakes environment.What You Will DoYou will play a central role in theend-to-end migration and modernisationof the data platform. Platform Transformation Translate legacy ETL logic from SSIS and stored procedures into modernELT pipelines using dbt ImplementData Vault 2.0 structuresincluding Raw Vault and Business Vault Builddatamarts and curated datasetsfor downstream analytics and reportingOrchestration & Infrastructure Design and operate workflows usingDagster , including scheduling, dependencies, and recovery mechanisms Deploy and run data workloads onOpenShift / Kubernetes environmentsEvent-Driven Data Processing Enablenear real-time data processingusing Kafka-triggered pipelines Integrate with upstream data lake environments and external data providersData Quality & Validation Establish robustdata validation and reconciliation processes Implement automated testing and monitoring using dbtOperational Ownership Support production pipelines and resolve incidents when required Create clear documentation and ensure operational readiness Continuously improve performance, reliability,



and maintainabilityWhat You Will DoYou will play a central role in theend-to-end migration and modernisationof the data platform.Platform Transformation Translate legacy ETL logic from SSIS and stored procedures into modernELT pipelines using dbt ImplementData Vault 2.0 structuresincluding Raw Vault and Business Vault Builddatamarts and curated datasetsfor downstream analytics and reportingOrchestration & Infrastructure Design and operate workflows usingDagster , including scheduling, dependencies, and recovery mechanisms Deploy and run data workloads onOpenShift / Kubernetes environmentsEvent-Driven Data Processing Enablenear real-time data processingusing Kafka-triggered pipelines Integrate with upstream data lake environments and external data providersData Quality & Validation Establish robustdata validation and reconciliation processes Implement automated testing and monitoring using dbtOperational Ownership Support production pipelines and resolve incidents when required Create clear documentation and ensure operational readiness Continuously improve performance, reliability, and maintainabilityRequirements What You BringTechnical Expertise Strong experience withSQL Server and T-SQL , including performance optimisation Proven hands-on experience withdbtin production environments Solid experience withworkflow orchestration tools , ideally Dagster Practical knowledge ofData Vault 2.0 modelling concepts Experience working withcontainer platforms such as OpenShift or Kubernetes Familiarity withevent-driven architectures and KafkaDomain Experience Experience working withfinancial data , ideally in banking or trading environments Understanding ofrisk and PnL data structuresis a strong advantageWorking Style Strong ownership mindset with the ability to work independently Structured, pragmatic, and delivery-focused Comfortable operating in complex and regulated environments Clear communicator across both technical and business stakeholdersWhat Success Looks LikeWithin the first months, you will have: Delivered initialData Vault structures and migrated datasetsinto the new platform Establishedstable, event-driven pipelines Ensureddata consistency and validationbetween legacy and new systems Contributed to aproduction-ready, scalable data platform

📌 Senior Data Engineer (San Juan del Río)
🏢 Avacone
📍 San Juan del Río