Azure ETL Engineer — Real-Time Data, Onsite Mexico

Traka (Assa Abloy); Región Centro; On-site; MXN 480,000 - 720,000; Full time

Job summary

ASSA ABLOY is seeking an experienced ETL Developer in Guadalajara to design, implement, and optimize ETL pipelines using Azure Data Factory and SSIS, integrating ERP data into data lakes, and migrating on-prem solutions to Azure.

The role requires strong MSSQL expertise, PySpark, Databricks, and real-time streaming knowledge. You will collaborate with data architects and ensure data quality for SaaS products, while working onsite in Mexico.

Qualifications

• Bachelor’s degree in Computer Science/Engineering with IT focus.
• 4+ years of IT experience focused on data warehousing, ETL development, and data modeling.
• 2+ years of data engineering with Azure services.
• 2+ years of DB development using MS SQL.
• Azure certification preferred; exposure to Microsoft Fabric is a plus.

Responsibilities

• Design and implement ETL processes using Azure Data Factory and SSIS.
• Build end-to-end data pipelines with orchestration and monitoring.
• Develop real-time data streaming solutions with Azure Stream Analytics and Event Hub.
• Migrate on-premises data solutions to Azure and optimize SQL queries and pipelines.
• Collaborate with data architects and stakeholders on data models and structures.
• Ensure data quality and reliability across SaaS data products.

Skills

MS SQL

Azure Cloud

Schema design

Data modeling

Python

PySpark

Databricks

SSIS

Azure Data Factory

Azure Databricks

SQL tuning

Communication

Multitasking

Problem solving

Education

Bachelor’s degree in Computer Science/Engineering

Tools

SQL Server

SSIS

Azure Data Factory

Azure Databricks

Databricks

Azure Stream Analytics

Microsoft Fabric

Job description

ASSA ABLOY is seeking an experienced ETL Developer in Guadalajara to design, implement, and optimize ETL pipelines using Azure Data Factory and SSIS, integrating ERP data into data lakes, and migrating on-prem solutions to Azure.

The role requires strong MSSQL expertise, PySpark, Databricks, and real-time streaming knowledge. You will collaborate with data architects and ensure data quality for SaaS products, while working onsite in Mexico.