[Remote] Azure Data Engineer

Note: The job is a remote job and is open to candidates in USA. Legrand has an exciting opportunity for an Azure Data Engineer to join their Information Technology Team. This role will lead the design, development, and optimization of enterprise data platforms on Azure, working closely with business and analytics teams to deliver scalable data solutions that enable data-driven decision-making.ResponsibilitiesDesign and implement scalable data platforms using Azure (ADLS, Azure SQL, Microsoft Fabric)Build and optimize ETL/ELT pipelines using Fabric pipelines, notebooks (PySpark/Spark SQL), and Azure Integration Services (ADF, Logic Apps, Event Grid, Service Bus)Implement Medallion Architecture (Bronze, Silver, Gold) and Lakehouse design patternsDevelop and maintain data models (dimensional, star/snowflake where applicable)Integrate data from heterogeneous sources (ERP, APIs, flat files, streaming sources, MDM/PIM systems)Develop data processing solutions for large-scale structured and unstructured datasetsEnable Power BI datasets and semantic models to support reporting and analyticsImplement CI/CD pipelines and DevOps practices using Azure DevOps, GitHub, RepoEnsure data quality, governance, lineage, and security using tools such as Microsoft PurviewCollaborate with Product Owners, Scrum Masters, and stakeholders to translate business requirements into technical solutionsLead performance tuning, optimization, and troubleshooting of data pipelines and queriesLeading cloud migration and modernization initiatives, including legacy system transitions (SSIS, Tabular, Multidimensional cubes)Drive adoption of modern data architecture principles and best practicesCollaborate with team members and contribute to establishing engineering standards and reusable frameworksProvide ongoing production support and operational maintenance, including monitoring data pipelines, troubleshooting issues, optimizing performance, and ensuring data reliability and availability across the platformAbility to manage multiple priorities effectivelySupport data team in the IT systems impact assessment when there is a data change requestsSkills8+ years of experience in data engineering, data warehousing, and analytics6+ years of experience in cloud transformation initiatives5+ years hands-on experience with Microsoft Azure data platform3+ years hands-on experience with Azure Fabric / lakehouse architectureDesign and implement scalable data platforms using Azure (ADLS, Azure SQL, Microsoft Fabric)Build and optimize ETL/ELT pipelines using Fabric pipelines, notebooks (PySpark/Spark SQL), and Azure Integration Services (ADF, Logic Apps, Event Grid, Service Bus)Implement Medallion Architecture (Bronze, Silver, Gold) and Lakehouse design patternsDevelop and maintain data models (dimensional, star/snowflake where applicable)Integrate data from heterogeneous sources (ERP, APIs, flat files, streaming sources, MDM/PIM systems)Develop data processing solutions for large-scale structured and unstructured datasetsEnable Power BI datasets and semantic models to support reporting and analyticsImplement CI/CD pipelines and DevOps practices using Azure DevOps, GitHub, RepoEnsure data quality, governance, lineage, and security using tools such as Microsoft PurviewCollaborate with Product Owners, Scrum Masters, and stakeholders to translate business requirements into technical solutionsLead performance tuning, optimization, and troubleshooting of data pipelines and queriesLeading cloud migration and modernization initiatives, including legacy system transitions (SSIS, Tabular, Multidimensional cubes)Drive adoption of modern data architecture principles and best practicesCollaborate with team members and contribute to establishing engineering standards and reusable frameworksProvide ongoing production support and operational maintenance, including monitoring data pipelines, troubleshooting issues, optimizing performance, and ensuring data reliability and availability across the platformAbility to manage multiple priorities effectivelySupport data team in the IT systems impact assessment when there is a data change requestsStrong experience with Azure Integration Services: Logic Apps, Function Apps, Service Bus, Event Grid, API ManagementProgramming: PySpark, Spark SQL, Python, SQLNotebook-based development (Databricks / Fabric)Infrastructure-as-code (Terraform, ARM templates, Bicep)Data Architecture: Medallion architecture, Lakehouse concepts, 3NF, Data warehouse, Dimensional modelingIntegration: REST APIs, JSON, XML, OData, event-driven architecturesDevOps: Azure DevOps (ADO), GitHub, JenkinsCI/CD pipelines, version control, automationReporting: Power BI, Semantic ModelsStrong communication and ability to engage with business and technical stakeholdersAbility to translate business requirements into scalable technical solutionsStrong analytical and problem-solving skillsExperience working in Agile/Scrum environmentsProactive and adaptable, with the ability to deliver results in evolving environmentsProven ability to collaborate across cross-functional teamsDemonstrates excellent interpersonal skills with a balanced, collaborative communication styleExperience with 3rd party development partnersBachelor's degree required, preferably in technical disciplineMicrosoft certifications in Azure or FabricPrior experience in manufacturing, supply chain, or distribution domainsBenefitsMedical, dental, and vision coverageA high employer 401K matchPaid time off (PTO) and holiday payShort-term and long-term disability benefit plansAbove-benchmark paid maternity and parental leaveBonus opportunities in accordance with the Company’s incentive plansPaid time off to volunteerAn active/growing Employee Resource Group networkCompany OverviewFounded more than 25 years ago Focal Point, a brand of Legrand, is a Chicago-based architectural lighting and integrated acoustical systems manufacturer. It was founded in 1994, and is headquartered in Chicago, Illinois, USA, with a workforce of 501-1000 employees. Its website is https://www.focalpointlights.com/.Company H1B SponsorshipFocal Point, LLC has a track record of offering H1B sponsorships, with 1 in 2024, 1 in 2023, 2 in 2021. Please note that this does not guarantee sponsorship for this specific role.