ETL Developer

ASSA 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 Responsibilities  A 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…