Sr. Azure Data Engineer - REMOTE
Ferguson is North America’s leading value-added distributor across residential, non-residential, new construction and repair, maintenance, and improvement (RMI) end markets. Spanning 34,000 suppliers and more than one million customers, we deliver local expertise, value-added solutions, and the industry’s most extensive portfolio of products. From infrastructure, plumbing, and appliances, to HVAC, fire protection, fabrication, and more, we make our customers’ complex projects simple, successful, and sustainable.
The Senior Azure Data Engineer is part of a team accountable for the successful delivery of Ferguson’s Master Data Management Customer technology. The engineer will carry out the activities responsible for the design and configuration of the Customer MDM in Reltio. The ideal candidate will be well versed in Cloud based technologies such as AWS, Azure Cloud and GCP with experience in Databricks and Azure Data Factory. Knowledge in data integration, data quality, project life cycle phases, and best practices is expected. Furthermore, we expect you to work as a team with other developers through code reviews, pair programming, and technical leadership. Your passion will lead to our customers success!
Duties and Responsibilities:
Work with Users, and Business Analysts to understand and translate functional requirements to technical design.
Analysis and resolution of sophisticated data relationships and data cleansing/profiling scenarios.
Hands-on configuration experience of hierarchies, entity types, attributes, relationships, and crosswalks in an MDM.
Solid understanding of high-level enterprise architecture patterns for data ingesting, storing, processing, and publishing
Experience configuring Out-of-the-box and Custom Cleanse Functions within an MDM.
Experience configuring External matches, and their usage to profile the incoming data for new sources.
Configuration and usage of advanced queries, Workflow management, User Management, and UI Config. Experience with LCA configuration for customizations.
Strategic problem solver - somebody who can conceptualize and lead the engineering of an MDM project.
Experience in designing master data (Customer Master, Product Master, etc.) hierarchies and reference data preferred.
Expert in Cloud & Data Technology and the market trends within Azure and AWS ecosystems.
Work with project management to develop the overall implementation solution, roadmap and plan.
Advanced Reltio experience desired but not required in areas of RIH (Reltio Integration Hub), Reltio L1, L2, L3 configuration layers, Reltio APIs, Reltio Open Collaboration System, etc.
Qualifications and Requirements:
7+ years of overall IT experience
Experience with hands-on implementation of Master Data Management (MDM) solutions using one of the major MDM platforms (Reltio Customer 360 - preferred, Informatica MDM, Stibo Systems)
5+ years’ Experience working as either: Software Engineer/Data Engineer: query tuning, performance tuning, troubleshooting, and debugging big data solutions.
Experience using and designing solutions on cloud infrastructure and services, such as AWS, Azure, or GCP
Experience with Development Tools for CI/CD, Unit and Integration testing, Automation and Orchestration, REST API, BI tools, and SQL Interfaces.
Expert level experience developing designs, data specific crosswalks and end user training documents.
History working with Databricks, Cloud Data Platforms, BI, Data Warehousing, Data Lakes, Data Science & Predictive Analytics
Expert in building Databricks notebooks in extracting the data from various source systems and perform data cleansing, data wrangling, data ETL processing and loading to AZURE SQL DB.
Expert in developing JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data.
Expert in using Databricks with Azure Data Factory (ADF) to compute large volumes of data from different sources.
Performed ETL operations in Azure Databricks by connecting to different relational database source systems.
Solid grasp of environment management, release management, code versioning, and deployment methodologies.
Familiarity with platform authentication patterns (SAML, SSO, OAuth).
Experience using a No SQL database such as Mongo or Cosmos is a plus.
Experience using development tools like JSON, Postman, Terraform, etc. is a plus.
Experience working in both a Waterfall and Agile environments.
Work directly to collaborate and mentor team members in differing levels across the world.
Be a subject matter expert and a go-to team member that makes valuable contributions daily.
Be willing to focus and contribute to seeking information, when needed.
Ferguson is dedicated to providing meaningful benefits programs and products to our associates and their families—geared toward benefits, wellness, financial protection, and retirement savings. Ferguson offers a competitive benefits package that includes medical, dental, vision, retirement savings with company match, paid leave (vacation, sick, personal, holiday, and parental), employee assistance programs, associate discounts, community involvement opportunities, and much more!
Actual pay rate may vary depending upon location. The estimated pay range for this position is below. The specific rate will depend on a candidate’s qualifications and prior experience.
-$6,805.95 - $11,921.25
Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.
This role is Bonus or Incentive Plan eligible.
The Company is an equal opportunity employer as well as a government contractor that shall abide by the requirements of 41 CFR 60-300.5(a), which prohibits discrimination against qualified protected Veterans and the requirements of 41 CFR 60-741.5(A), which prohibits discrimination against qualified individuals on the basis of disability.
Ferguson Enterprises, LLC. is an equal employment employer F/M/Disability/Vet/Sexual Orientation/Gender Identity.