Senior Engineer, Data

About mSupply mSupply is North America’s leading distributor of OEM repair parts and equipment, serving professionals in the appliance, HVAC, plumbing, commercial kitchen and pool/spa industries. Headquartered in St. Louis, MO, mSupply is a multi-billion dollar enterprise offering an extensive product range, industry expertise and seamless service. With more than 2,000 associates across the U.S. and Canada, mSupply’s family of brands delivers with speed, reliability and precision through its branches, distribution centers and extensive fleet of delivery vehicles. Shipped orders reach 93% of U.S. customers via next-day ground delivery and 100% within two days. For more information, visit mSupply.com.   The Senior Data Engineer designs, builds, and operates mSupply’s enterprise data platform on Microsoft Fabric. Working within a medallion architecture (Bronze, Silver, Gold) using dbt, this role owns pipeline reliability, data quality, and operational health from source system ingestion through delivery into analytics-ready datasets that power BI, data science, and AI capabilities.   You will own the end-to-end pipeline lifecycle for a platform that integrates data from multiple ERP systems, operational tools, and third-party sources across three major business verticals. This is not a maintenance role. mSupply is actively acquiring new businesses, and every acquisition means new source systems to onboard. If you want to build pipelines that matter in a fast-moving, high-impact environment, this is the role.    Job Duties & Responsibilities Design, build, and maintain ELT/ETL pipelines that ingest data from ERP systems, operational tools, APIs, and third-party providers into Microsoft Fabric. Own pipeline reliability and operational health across all medallion layers, ensuring data freshness, completeness, and accuracy. Develop and maintain dbt models, tests, and documentation to enforce data quality standards and transformation traceability across the platform. Build and optimize Fabric Pipelines, Notebooks, and Dataflows for orchestration, scheduling, error handling, and retry logic. Monitor and troubleshoot pipeline failures, data quality anomalies, and performance bottlenecks with proactive alerting and observability. Collaborate with Data Scientists and ML/AI Engineers to build and maintain feature pipelines and curated Gold layer datasets. Support new source system onboarding as the company acquires new business units, developing repeatable ingestion patterns that accelerate time-to-value. Implement and maintain CI/CD pipelines for dbt and Fabric workloads, including version control, automated testing, and deployment automation. Optimize query performance, storage costs, and compute utilization across the Fabric environment. Qualifications Required Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience. 5+ years of experience in data engineering, analytics engineering, or data platform roles with production pipeline ownership. Strong proficiency in SQL and Python for data transformation, pipeline development, and automation. Hands-on experience with modern ELT/ETL frameworks and data transformation tools such as dbt. Experience designing and operating data pipelines in cloud-based environments (Azure, AWS, or GCP). Solid understanding of data modeling concepts, dimensional modeling, and medallion or multi-layer data architectures. Experience with version control (Git), CI/CD practices, and automated testing for data workloads. Preferred Experience with Microsoft Fabric, Azure Synapse Analytics, or Azure Data Factory. Familiarity with Power BI, Direct Lake, SQL Analytics Endpoints, and OneLake. Experience integrating data from ERP systems (Eclipse, Business Central, or similar) and operational platforms (ServiceTitan or similar). 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: We prioritize your well-being from day one with a comprehensive benefits package that includes: 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.   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 careers@msupply.com.   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. Apply To This Job