Azure Data Engineer (SQL/Python)
We help companies modernize business operations, adopt intelligent automation, deliver real-time performance insights and connect the enterprise – accelerating the impact of digital transformation. Founded in 1987 and recognized as a trusted advisor, HSO is one of the world’s top business solution and implementation partners, large enough to serve, small enough to care. We are 100% dedicated to Microsoft technology, with practices that offer our clients a complete set of Microsoft cloud solutions from a single global partner. HSO is a proven global leader with unique delivery capabilities offered from our dedicated Microsoft practices in more than 31 offices across the Americas, Europe, Australia and Asia.HSO is a Gold Certified partner since 2002 and since 2006 has been a part of the Microsoft Dynamics Inner Circle, a prestige reserved for just 1% of Microsoft partners worldwide. Within HSO you’ll work with Microsoft Dynamics 365, Azure cloud platform and our unique, industry-specific solutions.About the role:HSO, a top business solution and implementation partner, is seeking a highly motivated Azure Data Engineer with strong knowledge in SQL/Python to join its dynamic and innovative team, working on a high scale and international projects together with our globally diverse team. The successful candidate for this role will be at the forefront of delivering crucial insights to our clients, leveraging their expertise in Azure, SQL, and Python to create transformative solutions, working with the latest tools in the Data Engineering area. As an Azure Data Engineer you will: Design and develop business intelligence solutions: infrastructure, tools and reports as well as integrations with different data sources. Design and build efficient pipelines to get data from different source systems like D365 F&O, CE, Salesforce. Use Azure Data Factory (ADF) or Synapse to create multiple complex pipelines and activities using both Azure and On-Prem data stores for full and incremental data loads. Perform data and query optimization, query profiling, and query performance monitoring tools and techniques. Develop data quality and validation procedures to ensure the accuracy and reliability of data. Implement data security and privacy measures to ensure compliance with regulations and industry best practices. Create and maintain business requirements and other technical documentation. Stay up-to-date with the latest Azure and Python technologies and trends and learn and pass relevant Microsoft exams (e.g. DP-203: Data Engineering on Microsoft Azure).