{bc}
paycor

Senior Data Architect - US

mSupply
Remote, USA
Full-time
Senior · 7+ years experience
Remote
Discovered 1 weeks ago
Microsoft FabricdbtSQLAzureAWSGCP
Free

Job Fit Check

Base Career helps you apply smarter for this job.

?%
Ready to Scan

Key skills for this role

Microsoft FabricdbtSQL
Smart Apply

Full Job Posting

About mSupply™

mSupply is a North American distributor of OEM repair parts and equipment serving the appliance, HVAC and plumbing industries. Headquartered in St. Louis, the company combines industry expertise with a broad product selection and a national distribution network.

With 2,000 employees across the United States and Canada, mSupply delivers speed and reliability at scale, with a vast product inventory and same-day shipping. Its family of brands is focused on making sure customers always get the Right Products. Right Now.™ For more information, visit mSupply.com.

Lead the architecture and implementation of the enterprise Product MDM solution, defining the golden record structure, match key strategy, entity resolution rules, and survivorship logic across multiple source systems.

Define and maintain enterprise data architecture standards, reference models, and design patterns for data integration, modeling, and master data governance.

Design canonical data models for master data domains (product, customer, supplier, location), ensuring consistency, extensibility, and alignment with business semantics.

Establish data quality rules, validation frameworks, and stewardship workflows for master data, including probabilistic matching, deduplication, and human-in-the-loop review processes.

Partner with Data Engineering to translate architectural designs into pipeline patterns, dbt model structures, and medallion architecture layer definitions (Bronze, Silver, Gold).

Define and enforce data contracts between source systems and the data platform, specifying schema expectations, quality thresholds, and change management protocols.

Support acquisition data onboarding by defining repeatable patterns for mapping, profiling, and integrating new source systems into the enterprise data model.

Drive data governance maturity including data cataloging, lineage documentation, classification standards, and stewardship role definitions.

Communicate architectural decisions, tradeoffs, and roadmap recommendations to senior leadership in clear, business-relevant terms.

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.

7+ years of experience in data architecture, data engineering, or data management roles, with at least 3 years focused on data modeling and architectural governance.

Demonstrated experience designing and implementing MDM solutions, including entity resolution, match/merge logic, and data stewardship workflows.

Deep expertise in data modeling (conceptual, logical, physical), dimensional modeling, and enterprise data integration patterns.

Strong proficiency in SQL and experience with modern data transformation tools such as dbt.

Experience with cloud-based data platforms (Azure, AWS, or GCP) and lakehouse or data warehouse architectures.

Proven ability to communicate architectural decisions and tradeoffs to both technical teams and senior business stakeholders.

Experience with Microsoft Fabric, Azure Synapse Analytics, or Azure Data Factory.

Familiarity with probabilistic matching tools or frameworks (Splink, Informatica MDM, Reltio, or similar).

Experience integrating data across multiple ERP systems (Eclipse, Business Central, or similar) in a multi-business-unit environment.

Background in wholesale distribution, supply chain, HVAC, plumbing, or related B2B sectors.

Experience or demonstrated ability using AI-powered tools (e.g., code assistants, LLMs, AI-augmented workflows) to accelerate work and improve outcomes.

Primarily sedentary work with extended periods at a computer

Ability to communicate effectively in person, by phone, and through virtual collaboration tools

Occasional standing, walking, and movement during meetings or travel

Ability to travel periodically for business needs, including visits to distribution centers, suppliers, or industry events

Office environment with standard business equipment such as computers, phones, and conferencing tools

Medical, dental, vision, and prescription coverage effective immediately

401(k) plan with company contributions

Life insurance and short-term disability coverage

HSA/FSA options and an Employee Assistance Program (EAP)

Paid time off, including vacation, holidays, and personal days

Weekly pay, employee discounts, and more

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at mSupply