Cetera Financial Group · 6 days ago
Senior MDM Data Engineer
Dallas, TX
Full-time
Hybrid
Senior Level
$111K/yr - $148K/yr
5+ years expCetera Financial Group is at the forefront of transforming technology in the financial industry, seeking innovative individuals to join their team. The Senior MDM Data Engineer will be responsible for designing and operating data engineering pipelines that support Master Data Management, integrating systems, and ensuring data quality and governance across the enterprise.
AdviceFinancial ServicesRetailRetirementWealth Management
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
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
Proven experience defining DQ rules, profiling logic, and exception workflows
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
Experience delivering MDM solutions in AWS cloud environments is strongly preferred
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
Advanced Snowflake experience (Streams/Tasks, Iceberg tables, RBAC)
Experience building CI/CD pipelines (GitHub Actions, CodePipeline, Bitbucket, etc.)
Familiarity with enterprise MDM domains: Party, Account, Security, Advisor, Transaction context, Hierarchy/Relationships
Understanding of metadata management and stewardship processes
Experience designing and managing support and monitoring frameworks for 24x7 operational data systems
Proven ability to establish incident management processes and escalation protocols
Strong background in optimizing ODS performance, availability, and reliability at scale
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
Cetera Financial Group
Cetera Financial Group is a privately-held, independent broker-dealer and investment adviser families.
1001-5000 employees
H1B Sponsorship
Cetera Financial Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (3)
2023 (5)
2022 (2)
2021 (2)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Genstar Capital
2023-10-04Private Equity
2018-07-17Acquired
Leadership Team
Michael Durbin
Chief Executive Officer
Dan Burkott
Chief Compliance Officer - Tax Channel
Recent News
2026-01-22
2026-01-07
2026-01-07
Company data provided by crunchbase