Senior Data Architect - US

mSupply; United States; Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401(k) plan with company contributions

Life insurance & short-term disability

Job summary

mSupply is seeking a Senior Data Architect to define and govern data architecture standards, master data strategy, and data modeling practices for its enterprise data platform built on Microsoft Fabric, dbt, and Power BI. You will lead the golden record strategy, entity resolution, and stewardship workflows while partnering with Data Engineering on pipelines and integrations.

The role requires 7+ years in data architecture or related fields, strong SQL and cloud data platform experience, and the

Qualifications

• Bachelor’s degree or equivalent practical experience in a related field.
• 7+ years in data architecture, data engineering, or data management with 3+ years in modeling/governance.
• MDM design experience including entity resolution, match/merge, and stewardship workflows.
• Strong SQL and experience with dbt; cloud data platforms and lakehouse/data warehouse patterns.
• Ability to communicate complex architecture to technical and non-technical stakeholders.

Responsibilities

• Lead architecture and governance for enterprise Product MDM and golden record strategy.
• Define enterprise data standards, reference models, and integration patterns.
• Design canonical data models for product, customer, supplier, and location domains.
• Establish data quality rules, validation, and stewardship workflows.
• Collaborate with Data Engineering on pipelines, dbt models, and medallion layers.
• Define data contracts and change management for source-to-platform schemas.
• Support integration of new sources during acquisitions and onboarding.
• Advance data governance, cataloging, lineage, and stewardship roles.
• Present architectural decisions and roadmaps to senior leadership.

Skills

Data architecture

Data modeling

SQL

MDM

Cloud platforms

Stakeholder communication

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

dbt

Microsoft Fabric

Azure Synapse Analytics

Azure Data Factory

Splink/Informatica MDM/Reltio

Job description

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.

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.

Job Summary

The Senior Data Architect defines and governs data architecture standards, master data strategy, and data modeling practices that underpin mSupply’s enterprise data platform. This role is the authoritative voice on how data is structured, integrated, governed, and consumed, ensuring architectural coherence as the company scales through organic growth and acquisitions. The platform is built on Microsoft Fabric, dbt, and Power BI.

Job Duties & Responsibilities

• 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.

Qualifications

Required

• 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.

Preferred

• 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.

Physical Demands & Work Environment

This is a full-time position. Duties are primarily performed in an office or remote work environment.

• 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

What We Offer

• 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

Equal Employment Opportunity & Pre-Employment Requirements

mSupply is an Equal Opportunity Employer. We make employment decisions without regard to sex, age, race, color, creed, religion, national origin, citizenship or immigration status, sexual orientation, gender identity or expression, disability, genetic information, marital status, veteran or military status, or any other status protected by applicable federal, state, or local law. #mSupply We are committed to providing reasonable accommodations for qualified individuals with disabilities and to applicants with sincerely held religious beliefs. To request a reasonable accommodation, please contact [e-mail]. Final offers of employment may be contingent upon completion of job-related pre-employment checks and screenings permitted by law. For roles that require operation of a company vehicle, a Motor Vehicle Record (MVR) check may also be conducted. This employer participates in E-Verify to confirm employment eligibility in the United States.