Senior Data Engineer: Real-Time ELT & Data Vault 2.0

Jobtailor; Ciudad de México; Presencial; MXN 900.000 - 1.200.000; Jornada completa

Descripción de la vacante

Jobtailor is seeking a data engineer to translate legacy ETL logic into modern ELT pipelines using dbt and to implement Data Vault 2.0 structures. You will build datamarts, operate Dagster workflows, and run workloads on OpenShift or Kubernetes, enabling near real-time processing with Kafka.

The role emphasizes ownership, independence, and delivery-focused work in complex, regulated environments, with a strong emphasis on data validation and documentation.

Formación

• Strong experience with SQL Server and T-SQL, including performance optimisation.
• Proven hands-on experience with dbt in production environments.
• Solid experience with workflow orchestration tools, ideally Dagster.
• Practical knowledge of Data Vault 2.0 modelling concepts.
• Experience working with container platforms such as OpenShift or Kubernetes.
• Familiarity with event-driven architectures and Kafka.
• Experience working with financial data, ideally in banking or trading environments.
• Understanding of risk and PnL data structures is a strong advantage.
• 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 stakeholders.

Responsabilidades

• Translate legacy ETL logic into modern ELT pipelines using dbt.
• Implement Data Vault 2.0 structures including Raw Vault and Business Vault.
• Build datamarts and curated datasets for downstream analytics and reporting.
• Design and operate workflows using Dagster, including scheduling, dependencies, and recovery mechanisms.
• Deploy and run data workloads on OpenShift / Kubernetes environments.
• Enable near real-time data processing using Kafka-triggered pipelines.
• Integrate with upstream data lake environments and external data providers.
• Establish robust data validation and reconciliation processes.
• Implement automated testing and monitoring using dbt.
• Support production pipelines and resolve incidents when required.
• Create clear documentation and ensure operational readiness.
• Continuously improve performance, reliability, and maintainability.

Conocimientos

SQL Server

T-SQL

Dbt

Dagster

OpenShift

Kubernetes

Kafka

Data Vault 2.0

Financial data

Herramientas

SQL Server

T-SQL

Dbt

Dagster

OpenShift

Kubernetes

Kafka

Descripción del empleo

Jobtailor is seeking a data engineer to translate legacy ETL logic into modern ELT pipelines using dbt and to implement Data Vault 2.0 structures. You will build datamarts, operate Dagster workflows, and run workloads on OpenShift or Kubernetes, enabling near real-time processing with Kafka.

The role emphasizes ownership, independence, and delivery-focused work in complex, regulated environments, with a strong emphasis on data validation and documentation.