Senior Data MDM Engineer

MDM Data Engineer

This role is responsible for designing and maintaining scalable, cloud-native data pipelines and integrations that centralize data across a large, fragmented enterprise system landscape in support of a Master Data Management mission.

•Build and maintain ETL/ELT pipelines to extract, transform, and load data from 20 enterprise systems into a central data architecture

•Develop, deploy, and optimize APIs to enable seamless data access for analytics, reporting, and operational systems

•Work within Microsoft Dynamics to understand system structure, pull data, and build integrations against it

•Create and define cost centers by standardizing attributes across all enterprise systems to establish a consistent data language across the organization

•Write Python code daily as the primary language for data engineering tasks across the team

•Leverage AWS services, primarily S3 for data storage and Lambda for event-driven functions, to support cloud-native workflows

•Incorporate AI tools into day-to-day engineering work and continuously identify process improvement opportunities

•Collaborate within a small, pod-based team structure alongside a tech lead, data engineer, BA, UX, and PM

Minimum Requirements

•3-10 years of overall experience in data engineering, data architecture, or a closely related role

•3 years of hands-on Python programming experience

•3 years of experience building and managing ETL/ELT data pipelines

•Proficiency with AWS services, specifically S3 and Lambda

•Strong SQL skills with the ability to write performant queries across various data stores

•Experience designing and integrating APIs into data workflows

•Resume profile reflecting a 70/30 split, data engineering background with some developer or application-building crossover

Preferred Qualifications

•Experience with Snowflake or other modern data stack tools such as dbt or Databricks

•Familiarity with Microsoft Dynamics or similar enterprise platforms

•Background in MDM, sales data, or sales analytics environments

•Broader programming or application development experience, including having built an application end to end

•Familiarity with machine learning pipelines or AI-driven analytics workflows

•AWS certifications, such as AWS Solutions Architect

•Experience with Infrastructure as Code tools like Terraform or AWS CloudFormation