Master data engineer

The Master Data Engineer owns the accuracy, consistency, and governance of Marco’s core master data by building and running the pipelines that create it - across ERP, CRM, Microsoft Fabric data warehouse, and other system repositories. This role sets and enforces Marco’s formal data ontology in partnership with the data architecture team, and turns raw operational data into governed, machine-readable master data through engineered pipelines rather than manual review alone. The Master Data Engineer partners directly with Finance, Sales, Procurement, Internal Systems, and Business Unit leadership to keep master data clean, de-duplicated, pipeline-delivered, and thoroughly documented for aligned data definitions across the organization.

ESSENTIAL FUNCTIONS:

• Design, build, and maintain automated data pipelines (Microsoft Fabric Dataflows Gen2, notebooks/PySpark, SQL) that consolidate and reconcile master data across e-Automate, Salesforce, and Marco’s Fabric data warehouse.
• Serve as the primary engineer and steward of core master data domains — customer, item/equipment, vendor, and location — ensuring pipelines enforce accuracy, completeness, and de-duplication at the source, not after the fact.
• Define and enforce Marco’s formal data ontology, MDM standards, naming conventions, and business rules, implemented as automated validation and match/merge/survivorship logic within pipelines.
• Partner with the data architecture team to model business concepts and real-world entity relationships, turning raw data into machine-readable, query able knowledge.
• Lead recurring data quality audits and build automated profiling and reconciliation jobs across ERP, CRM, and Fabric repositories; engineer remediation workflows for ancillary data that lives outside core systems.
• Build and maintain the intake and approval workflow for create/change/merge/deactivate requests on master records as a governed, auditable process, partnering with requesting departments to validate before load.
• Document data governance standards, field definitions, lineage, and stewardship procedures in a living data dictionary; publish self-serve documentation that lets business users understand the data they use.
• Partner with the BI/reporting function to catch master data quality issues via automated checks before they reach downstream dashboards and reports.
• Train and support cross-functional teams (Sales, Service, Procurement, Finance) on master data intake standards and the technical and business impact of poor data quality.
• Track and report data quality and pipeline KPIs (duplicate rate, completeness, accuracy, cycle time, pipeline SLA) to the Director of Enterprise Data and Analytics.

QUALIFICATIONS:

• Bachelor’s degree in computer science, information systems, or a related field, or equivalent practical experience.
• 7+ years of experience in data engineering, master data management, or a related data-operations role, including experience setting standards or leading initiatives with minimal supervision.
• Strong proficiency in Python (including PySpark) and SQL for pipeline development, data profiling, validation, and reconciliation.
• Hands-on experience building and maintaining pipelines in Microsoft Fabric (Dataflows Gen2, notebooks, Lakehouse) or a comparable modern data platform (Databricks, Snowflake).
• Hands-on experience integrating MDM processes with ERP and/or CRM platforms (e-Automate, Salesforce, or comparable systems).
• Experience designing match/merge/survivorship logic and automated data quality rules.
• Working familiarity with AI-assisted engineering tools (e.g., Claude, Copilot) for pipeline development and documentation.
• Excellent attention to detail, documentation habits, and written/verbal communication with both technical and non-technical stakeholders.
• Demonstrated ability to lead cross-functional data governance and engineering initiatives and influence stakeholders without formal authority.

Pay Range: $80,796 - $125,234 annually

The pay range listed for this position is based on candidate's skill level, experience, relevant licenses, and educational background. For detailed information about our benefits, please visit our careers page at www.marconet.com/careers.

Location: This is a remote-eligible position, however, Marco Technologies requires employees to reside within one of the following states: DE, FL, IA, IL, IN, KY, MD, MI, MN, MO, ME, NE, ND, NJ, PA, RI, SD, TX, WI

Application Deadline: Applications are continuously accepted until the position has been filled.