Oracle Cloud ERP · 1 week ago
Senior MDM Data Engineer
Dallas, TX, United States
Full-time
Hybrid
Senior Level
$111K/yr - $148K/yr
5+ years expOracle Cloud ERP is at the forefront of transforming the future of technology in the financial industry, seeking curious and practical individuals to join their team. The Senior MDM Data Engineer will be responsible for designing, building, and operating data engineering pipelines that support the Master Data Management ecosystem across the enterprise.
Information Technology & Services
Responsibilities
Design, build, and maintain ingestion, standardization, match/merge preparation, and golden-record distribution pipelines that support Profisee and Snowflake MDM workflows
Develop and optimize batch, micro-batch, and real-time/streaming pipelines using AWS services (MSK/ Kafka, Lambda, Step Functions, S3, Glue) that support near real-time golden-record updates
Build robust pipelines to feed the feedback loop from Profisee golden records to downstream systems (e.g., operational apps, Snowflake EDW, integration layer, domain APIs)
Transform source-system attributes into canonical MDM domain-aligned schemas using Iceberg, or engineered transformations
Implement and maintain Profisee ingestion patterns, including entity configuration, match/merge logic, survivorship rule execution, and data validation pipelines
Build automated flows to promote golden records from Profisee into Snowflake and publish attribute changes to downstream platforms
Support MDM model changes by developing scalable pipelines that adapt to schema evolution and new mastered attributes
Partner with MDM Analysts and Data Stewards to translate governance rules into executable engineering logic
Implement data quality rule enforcement (completeness, conformity, integrity, consistency) as part of MDM pipelines using tools such as Great Expectations/Soda/Deequ or native SQL rules
Contribute to MDM metadata management, lineage capture, and integration with enterprise catalogs
Apply best practices for referential integrity, survivorship, deduplication, hierarchy management, and domain alignment
Establish reusable patterns for onboarding new MDM sources or domains
Partner with ingestion, integrated, and access layer engineering teams to ensure MDM-produced golden data is correctly consumed and traceable end-to-end
Work with Security, IAM, and DevOps to ensure secure, scalable delivery of MDM workloads
Provide technical guidance to junior engineers and serve as a subject-matter SME for MDM pipeline development
Contribute to Agile ceremonies, sprint planning, backlog refinement, and peer design reviews
Ensure MDM jobs, both batch and streaming meet SLAs
Support MDM incident triage, match conflicts, rule tuning, and schema evolution
Contribute to playbooks, runbooks, onboarding guides, and stewardship documentation
Evaluate Profisee feature releases, AWS enhancements, and architectural maturity opportunities
Monitor and continuously improve data quality and operational efficiency
Monitor and participate in the optimization of performance of the MDM Platform and related systems to meet evolving business demands
Stay current with emerging technologies and industry trends to drive innovation and best practices
Qualification
Required
5–10+ years in data engineering, with at least 3+ years supporting MDM platforms (preferably Profisee)
Bachelor's degree in information systems, Data Management, Computer Science, Business Analytics, or equivalent
Hands-on experience with Profisee MDM required
Experience delivering MDM solutions in AWS cloud environments is strongly preferred
Strong programming experience in Python, SQL, and data transformation frameworks (dbt, Spark, Glue)
Experience working with AWS data services including: S3, Glue, Lambda, Step Functions, DynamoDB, and API Gateway
Hands-on experience with event-driven mastering using: Kafka/MSK (preferred), Kinesis, or Event Bridge
Proficiency designing event-driven integrations, especially for operational data mastering
Advanced Snowflake experience (Streams/Tasks, Iceberg tables, RBAC)
Strong understanding of survivorship, matching algorithms, identity resolution, record lineage, and MDM best practices
Experience building CI/CD pipelines (GitHub Actions, CodePipeline, Bitbucket, etc.)
Proven experience defining DQ rules, profiling logic, and exception workflows
Experience designing and managing support and monitoring frameworks for 24x7 operational data systems
Strong communication skills and ability to work across business and IT stakeholders
Comfortable analyzing complex source data and resolving data quality/root cause issues
Ability to work in a fast-paced, federated data organization and navigate multi-domain alignment
Demonstrated ownership and a proactive, engineering-first mindset
Preferred
Cloud certifications (AWS Solutions Architect, AWS Data Analytics) preferred
MDM certifications are desirable
Financial Services Certifications preferred such as SIE Certification, Series-99 or similar
Technical Certifications preferred related to AWS Technology Stack
4–7 years in MDM, Data Quality, or Data Integration roles
Background in financial services, broker-dealer, or other regulated, data-intensive industries is preferred
Experience implementing streaming/event-driven data patterns is highly desirable
Experience integrating Profisee with Snowflake and AWS-native pipelines
Knowledge of streaming-based MDM updates and near-real-time mastering patterns
Exposure to canonical modeling in event-driven architectures
Familiarity with reconciling mastered data with downstream operational systems
Understanding of domain-driven design for large-scale data ecosystems
Benefits
Inclusive health, dental, vision and life insurance plans built to support diverse lifestyles, offer preventative care, and protect against hardship.
Easy access to mental health benefits to meet our team members and their families where they are.
20+ days of paid time off (PTO), paid holidays, and 2 paid wellness days to give our employees the time they need to stay close with their loved ones, recharge, and give back to their communities.
401(k) Savings plan with a generous company contribution (up to 5%), and access to a financial professional to offer our employees the opportunity to plan-ahead for a strong financial future well beyond their working years.
Paid parental leave to support all team members with birth, adoption, and foster.
Health Savings and Flexible Spending Account options to help you save money on healthcare, daycare, commuting, and more.
Employee Assistance Program (EAP), LifeLock, Pet Insurance and more.
Company
Oracle Cloud ERP
Oracle Cloud ERP is a software as a service, SaaS, solution for businesses to control and manage multiple facets of their business.
10001+ employees
Funding
Current Stage
Late StageCompany data provided by crunchbase