Senior ETL Developer - Supply Chain & Infrastructure (Remote)

FERGUSON

21h • Remote

About The Position

Since 1953, Ferguson has been a source of quality supplies for a variety of industries. Together We Build Better infrastructure, better homes and better businesses. We exist to make our customers’ complex projects simple, successful, and sustainable. We proactively solve problems, adapt and grow to continuously serve our customers, communities and each other. Ferguson, a Fortune 500 company, is proud to provide best-in-class products, service and capabilities across the following industries: Commercial/Mechanical, Facilities Supply, Fire and Fabrication, HVAC, Industrial, Residential Trade, Residential Building and Remodel, Waterworks and Residential Digital Commerce. Ferguson has approximately 36,000 associates across 1,700 locations. Ferguson is a community of proud associates who operate with the shared purpose of building something meaningful. You will build a career that you are proud of, at a company you can believe in. Join Our Supply Chain Solutions & Infrastructure Team! This role is part of Supply Chain Solutions & Infrastructure (SCS&I)—the team that powers Ferguson’s supply chain through innovative technology. We design, build, and support the applications that keep our operations running smoothly, from order management and fulfillment to inventory and warehouse automation using conveyors and robotics. As a Senior ETL Developer, you’ll play a critical role in designing and implementing data integration solutions that enable accurate, timely, and actionable insights across our supply chain. You will work closely with cross-functional teams to extract data from multiple sources, transform it to meet business requirements, and load it into enterprise systems and data warehouses. Your work will ensure data consistency, quality, and availability for reporting and analytics.

Requirements

• 5+ years of experience in ETL development and data integration.
• Strong knowledge of ETL tools (Databricks required; SSIS required; Azure Data Factory preferred).
• Proficiency in SQL for data manipulation and validation.
• Experience with data modeling and relational database concepts.
• Familiarity with Azure cloud infrastructure and SaaS solutions.
• Knowledge of data quality, cleansing, and transformation techniques.
• Strong analytical and problem-solving skills.
• Excellent communication skills, including technical documentation.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).

Nice To Haves

• Experience with Python or scripting languages for automation.

Responsibilities

• Design, develop, and maintain ETL workflows using tools such as SSIS and Azure Data Factory.
• Extract data from diverse sources (databases, APIs, flat files) and transform it according to business rules.
• Perform data analytics with the use of Databricks.
• Load data into target systems including data warehouses and operational databases.
• Optimize ETL processes for performance, scalability, and reliability.
• Collaborate with business analysts and stakeholders to translate requirements into technical specifications.
• Implement data quality checks and ensure integrity across systems.
• Develop and maintain documentation for ETL processes and data flows.
• Provide support for ETL jobs and troubleshoot issues to maintain high availability.
• Work with Azure cloud services for data integration and storage.
• Contribute to best practices for data integration, governance, and automation.

Benefits

• At Ferguson, we care for each other. We value our well-being just as much as our hard work. We are committed to a holistic approach towards benefits plans and programs that support the mental, physical and financial well-being of our associates. Our competitive offering not only includes benefits like health, dental, vision, paid time off, life insurance and a 401(k) with a company match, but our associates also enjoy additional meaningful and inclusive enhancements that are adaptable to their diverse situations and needs, including mental health coverage, gender affirming and family building benefits, paid parental leave, associate discounts, community involvement opportunities and more!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees