Lead Data Integration Engineer

Job description

About Ferguson:

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 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 Ferguson’s Enterprise Data & Analytics team as an Azure Data Engineer and play a pivotal role in advancing our data-driven initiatives. In this role, you will design, develop, and implement scalable data solutions using innovative technologies such as Azure Data Factory, Databricks, Cosmos DB, and Azure Pipelines.

Collaborating with multi-functional teams, you’ll streamline data workflows, optimize performance, and ensure seamless data integration across the enterprise.

This opportunity is ideal for a meticulous, problem-solving professional passionate about building innovative, cloud-based data solutions to support business growth.

Duties and Responsibilities:

• Architect, develop, and deploy scalable software solutions for data integration and management using tools such as Azure Data Factory, Databricks, Cosmos DB, and Azure Pipelines.
  
  
• Build and maintain ETL pipelines to facilitate efficient data extraction, transformation, and loading processes.
  
  Ensure workflows are optimized for performance and scalability across large datasets.
• Write high-quality, maintainable code following industry standard methodologies.
  
  Participate actively in code reviews to uphold coding standards and provide constructive feedback to peers.
• Work closely with data engineers, analysts, and business collaborators to collect requirements and translate them into technical solutions.
  
  Ensure that solutions meet business needs and drive value.
• Identify and resolve performance bottlenecks in data pipelines and existing applications.
  
  Provide solutions for optimizing query performance and enhancing data processing efficiency.
• Ensure data solutions adhere to governance, security, and compliance standards.
  
  Implement mechanisms to monitor and enforce data quality and security policies.
• Provide ongoing support for deployed data systems, including monitoring, debugging, and resolving incidents.
  
  Contribute to the continuous improvement of system stability and reliability.
• Partner with the data architecture team to align solutions with enterprise data strategies and ensure proper implementation of data modeling, warehousing, and integration standards.
• Maintain comprehensive documentation for software designs, data workflows, and technical processes.
  
  Encourage collaborative learning among team members through the development and maintenance of technical guides and resources.
• Stay informed about advancements in Azure technologies, ETL platforms, and data engineering tools.
  
  Propose and implement improvements to existing systems to leverage new technologies and methodologies.

Qualifications and Requirements:

• Bachelor’s degree or equivalent experience in Computer Science, Information Technology, or a related field.
  
  Equivalent practical experience in data engineering will also be considered.
  
  ETL Developer.
• Hands-on experience with Azure Data Factory, Databricks, Cosmos DB and Azure Pipelines.
• Good understanding of software development principles, including version control, CI/CD pipelines, and containerization (e.G., Docker).
• Demonstrable experience in building and managing ETL processes, including data cleansing, transformation, and integration from diverse sources.
• Exceptional analytical and problem-solving skills, with the ability to analyze complex datasets and optimize data workflows.
• Good interpersonal and communication skills, with the ability to convey technical concepts to both technical and non-technical audiences.
  
  
• Solid focus on accuracy, quality, and consistency in data handling, with a dedication to continuous improvement.
• Proactive in learning new technologies and methodologies in data engineering and eager to adapt to evolving business and technical environments.
• Familiarity with Azure cloud services beyond data engineering, including Azure SQL, Azure Synapse Analytics, and Azure DevOps.
• Experience with data modeling, performance tuning of SQL queries, and working in Agile environments.
  
  Knowledge of data visualization tools like Power BI is a plus.

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!

Required Skill Profession

Computer Occupations