Sr. Data Architect - Enterprise Data & Analytics

Job Posting:

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.

Ferguson has an exciting opportunity for a Data Architect to join the Enterprise Data & Analytics team within the Ferguson Technology organization. As a Sr. Data Architect, you will be working in a dynamic and transformative organization with the goal of both developing new capabilities while also maturing existing systems and processes. This role is accountable for data architecture and mapping, specifically concerning data ingestion, modeling, enrichment, and automation.

**This position may be remote or hybrid in accordance with company policy.**

Duties and Responsibilities:

• Translate complex enterprise data business, functional, and technical requirements into end-to-end architectural designs including data integration and governance.
• Design resilient and extensible approaches to support data orchestration, ingestion, and enrichment from a variety of disparate sources and formats
• Strong understanding of high-level enterprise architecture patterns for data ingestion, storage, processing, and syndication.
• Ensure compliance to enterprise data standards, metadata management, security, business semantics, data modeling and information lifecycle management

Qualifications and Requirements:

• 3+ years of overall data-related experience with a strong emphasis on data engineering or modeling preferred.
• Experience writing and troubleshooting SQL queries is required.
• Experience with other high level languages is highly desirable, with an emphasis on common data analysis languages like Python or R is preferred.
• Experience performing EDA activities on both structured (tabular) and semi-structured (document) data, including assessing data quality and completeness via data profiling and summarizing and reporting on those findings.
• Experience creating and utilizing standardized data architecture documentation like data source definitions, source-to-target mappings, and entity relationship diagrams
• Experience in building batch or real time ETL pipelines with an emphasis on data processing standardization and reusability.
• Experience architecting and delivering solutions in a cloud platform (Azure, AWS, and/or GCP) with an emphasis on data orchestration and enrichment. Experience on Azure is preferred.
• Experience with traditional RDBMS solutions like SQL Server, Oracle, Postgres, and/or MySQL is required.
• Experience with big data platforms like Azure Synapse, Databricks, Snowflake, Amazon Redshift, and/or Google BigQuery is preferred.
• Experience with NoSQL databases like Azure Cosmos, Amazon DynamoDB and/or MongoDB is desirable.
• Experience working with data scientists and machine learning engineers applying machine learning models is desirable.
• Experience with real time/near real time data platforms like Azure Event Hubs, Apache Kafka, and/or Amazon Kinesis is desirable

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!

-

Pay Range:

-

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.

-

-

Estimated Ranges displayed are Monthly for Salaried roles OR Hourly for all other roles.

-

This role is Bonus or Incentive Plan eligible.

-

Ferguson complies with all wage regulations. The starting wage may be higher in certain locations based on local or state wage requirements.

-

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.

Equal Employment Opportunity and Reasonable Accommodation Information