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 Open Shift.
This role is not about maintaining existing systems.
It is aboutrebuilding a critical data platform from the ground up , with direct impact onrisk, trading Pn L, 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 onOpen Shift / 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 onOpen Shift / 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 Open Shift or Kubernetes
Familiarity withevent-driven architectures and KafkaDomain Experience
Experience working withfinancial data , ideally in banking or trading environments
Understanding ofrisk and Pn L 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 (Chihuahua)
🏢 Avacone
📍 Chihuahua