ETL Developer

Record UK Ltd; Región Centro; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Descripción de la vacante

ASSA ABLOY is seeking an experienced ETL Developer to design and implement data integration pipelines using Azure Data Factory, SSIS, and Databricks in Guadalajara. You will build real-time data streams, optimize data models, and ensure data quality while migrating on-premises solutions to Azure.

The role requires 4+ years of IT experience with a focus on data warehousing and ETL development, strong MS SQL and Python skills, and collaboration with data architects to support SaaS products.

Formación

• 4+ years of Information Technology experience with a focus on data warehousing, ETL development, and data modeling.
• 2+ years of data engineering experience with a focus on Azure services.
• 2+ years of DB development experience using MS SQL.

Responsabilidades

• ETL Development: design and implement ETL processes using Azure Data Factory and SSIS.
• Data Pipelines & Orchestration: design end-to-end data pipelines with orchestration and monitoring.
• Microsoft Fabric: work with Fabric components to build modern data solutions.
• Fabric Optimization: optimize workloads across Fabric environments.
• Real-Time Data Solutions: develop real-time streaming solutions with Azure Stream Analytics or similar.
• Big Data Processing: use PySpark and Databricks for large-scale processing.
• Collaboration and Modeling: collaborate with data architects to model data structures.
• ERP Integration: integrate ERP systems into data lakes.
• Optimization: tune SQL queries and data pipelines for performance.
• Data Quality: implement data quality checks and monitoring.
• Cloud Migration: migrate on-prem data to Azure.
• Continuous Learning: stay updated on Azure features.

Conocimientos

MS SQL

Azure Cloud Services

Schema design

Data modeling

Python

Analytics

Communication

Educación

Bachelor's degree in Computer Science/Engineering

Herramientas

SSIS

Azure Data Factory

Azure Databricks

Databricks

PySpark

Fabric (Lakehouse, Data Warehouse, Pipelines)

Descripción del empleo

ETL Developer# ETL DeveloperASSA ABLOY is a global leader in access solutions, dedicated to shaping the future of security and convenience. With a rich heritage spanning over 150 years, ASSA ABLOY has built a reputation for delivering innovative and reliable locking and access control solutions. ASSA ABLOY's cutting-edge technologies ensure safety, security, and seamless user experiences. With a commitment to sustainability and customer satisfaction, ASSA ABLOY continues to drive advancements in access solutions for a safer and more connected world.**What you will be doing**We are looking for an experienced ETL Developer to design and implement data integration solutions using tools like Azure Data Factory, SSIS, and Databricks. The role involves building scalable ETL pipelines, real-time data streaming solutions, and optimizing data models for performance and reliability.Key responsibilities include integrating ERP systems into data lakes, migrating on-premises solutions to Azure, and ensuring data quality through rigorous checks and monitoring. Strong expertise in MSSQL, Azure Cloud Services, and data processing, along with excellent communication and multitasking skills, is essential for this dynamic role.This is an onsite role based in Guadalajara, Mexico.Summary of ResponsibilitiesA key member of the development team, this position focuses on designing, implementing, and optimizing ETL processes, data integration, and modeling to enhance data reliability and quality for SaaS products.* ETL Development: Design and implement ETL processes using Azure Data Factory and SSIS to extract, transform, and load data from diverse sources efficiently.* Data Pipelines & Orchestration: Strong experience in designing end-to-end data pipelines, including orchestration, dependency management, and monitoring using Azure Data Factory or similar tools.* Microsoft Fabric: Work with Microsoft Fabric components such as Lakehouse, Data Warehouse, and Pipelines to build modern, unified data solutions.* Fabric Optimization: Optimize workloads across Fabric (Lakehouse/Warehouse) environments for performance, scalability, and efficient data processing.* Real-Time Data Solutions: Develop real-time data streaming solutions with Azure Stream Analytics and Azure Event Hubs to support analytics and reporting.* Big Data Processing: Leverage PySpark and Databricks for large-scale data processing, ensuring scalability and high performance.* Collaboration and Modeling: Work with data architects and stakeholders to design and maintain data models and structures for efficient storage and retrieval.* ERP Integration: Implement seamless integration of ERP systems into data lakes, ensuring data flow and accessibility.* Optimization: Monitor and optimize SQL queries and data pipelines to enhance performance and minimize latency.* Data Quality: Implement data quality checks and monitoring systems to ensure data integrity and accuracy.* Cloud Migration: Participate in migrating on-premises data solutions to Azure, following best practices for security and compliance.* Continuous Learning: Stay updated on Azure features and data engineering practices to contribute to team improvements.**What we are looking for** This role requires expertise in MS SQL, Azure Cloud Data Services, schema design, and modeling tools, along with strong analytical, communication, and multitasking skills to thrive in a dynamic, fast-paced environment.Education* Bachelor’s degree in Computer Science/EngineeringExperience* 4+ years of Information Technology experience with a focus on data warehousing, ETL development, and data modeling* 2+ years of experience in data engineering, with a focus on Azure services* 2+ years of DB development using MS SQLPreferred Qualifications* Proficient in SQL Server, SSIS, and Azure SQL Database* Strong programming skills in Python* Hands-on experience with PySpark and distributed data processing, including performance tuning and optimization in Databricks/Fabric environments* Experience working with manufacturing or industrial data (ERP, shop-floor systems, IoT data) is an added advantageTechnical Knowledge and/or Abilities* Proficient with Azure Data Factory, Azure Databricks, and Azure Stream Analytics* Strong understanding of real-time data processing and data streaming concepts* Strong understanding of data warehousing concepts including dimension modeling, ETL architecture, slowly changing dimensions (SCD), and data lifecycle management* Familiar with data modeling techniques (Star Schema, Snowflake Schema)* Azure certification (e.g., Azure Data Engineer Associate) preferred; exposure to Microsoft Fabric (Lakehouse, Data Warehouse, Pipelines, and OneLake architecture) is a strong plus* Experience with SSIS or equivalent ETL tools for analyzing, designing, and developing ETL packages* Skilled in T-SQL, PL/SQL, and a programming language* Expertise in stored procedures, SQL performance tuning, and database query optimization* Ability to analyze SQL performance, load, and concurrent use issues in complex architectures* Excellent problem-solving, attention to detail, and communication skills* Flexibility to work overtime or weekends to meet deadlines* Ability to document processes and workflows for future reference**We are the ASSA ABLOY Group** Our people have made us the global leader in access solutions. In return, we open doors for them wherever they go. With nearly 63,000 colleagues in more than 70 different countries, we help billions of people experience a more open world. Our innovations make all sorts of spaces – physical and virtual – safer, more secure, and easier to access.As an employer, we value results – not titles, or backgrounds. We empower our people to build their career around their aspirations and our ambitions – supporting them with regular feedback, training, and development opportunities. Our colleagues think broadly about where they can make the most impact, and we encourage them to grow their role locally, regionally, or even internationally.As we welcome new people on board, it’s important to us to have diverse, inclusive teams, and we value different perspectives and experiences.Application due2026-08-31FunctionIT, Telecom & InternetExperience levelMid-senior levelOffice presenceOnsiteLocationGuadalajara, Jalisco, Mexico