Senior MDM Engineer

Job description

Who We Are HIKE2 is an advisory and innovation partner helping organizations design and build what’s next. We work with complex and regulated industries, including law firms, financial services, insurance, professional services, and high-growth SaaS companies, to modernize operating models and embed data, automation, and AI into the core of how work gets done. Our clients aren’t just upgrading technology. They are rethinking workflows, activating governed AI, and designing environments where humans and intelligent systems work side by side. We believe meaningful transformation happens when strategy, data, design, and engineering move together. Siloed initiatives don’t scale. Real progress requires clarity of vision, strong data foundations, responsible governance, and disciplined execution. Our teams bring deep industry expertise, human-centered design, and advanced data and cloud capabilities to architect secure, scalable solutions built for real-world complexity. From modern data platforms to AI-enabled workflows and enterprise automation, we help organizations move from experimentation to measurable impact. We thrive in change and move from blank slate to working systems. We care deeply about outcomes, trust, and building long-term partnerships. We don’t just implement technology. We help design the future of work. The Role HIKE2 is hiring a senior Master Data Management Engineer for its data and integration practice. You will architect and build resolved identity and relationship foundations for financial services clients. Own the end-to-end MDM and relationship-graph architecture on an engagement, from data modeling through integration, data quality, and governance. Design and configure match and merge logic, survivorship and trust rules, validation rules, and golden-record management. Build entity resolution, the golden record, and the graph, along with the pipelines that feed them and syndicate trusted master data back to consuming systems. Establish the data-quality baseline and the survivorship and stewardship operating model, including steward workflows and issue queues. Define the identity seam between the client identity platform and the MDM layer, turning an authenticated claim into a resolved party. Set engineering standards, document a repeatable delivery approach, and mentor and grow a small team. Collaborate with data governance, CRM and source-system owners, and business stakeholders, and translate complex MDM concepts for both technical and non-technical audiences. The following is the depth we expect. A strong candidate is hands-on across most of these areas, not familiar with them in theory. Identity resolution and matching Design and implement deterministic and probabilistic match logic, configuring match rules, thresholds, and trust scoring, and tuning them over time to balance false merges against missed matches. Weight strong identifiers such as tax ID and date of birth above shared attributes like name and address, and handle nicknames, transliteration, and address standardization. Build and maintain crosswalks between each source system's local key and the canonical party identifier. Golden record and survivorship Design golden, or best, record construction with attribute-level survivorship and trust rules that define which source wins per attribute and why, with full lineage. Implement merge, unmerge, split handling, and manage record consolidation safely in production. Establish validation rules and the golden-record lifecycle: create, update, retire. Party and relationship data modeling Model the party domain across person, legal entity, household, and account, with relationships, hierarchies, crosswalks, and reference data. Design the relationship graph ontology: households, beneficial ownership (UBO) chains, advisor-to-client, entity-to-account, collateral, and exposure, with effective dating so relationships are time-valid. Define measurable data-quality metrics and the minimum required attributes for each domain. Data quality and stewardship Build automated data profiling and a measured baseline for completeness, accuracy, consistency, and duplication. Implement data-quality rules, validation logic, and exception handling, and design steward workflows, issue queues, and dashboards that make stewardship efficient. Partner with governance to define master data policies, standards, and the stewardship operating model, and maintain data dictionaries per domain. Integration and pipelines Design inbound and outbound integration patterns to ingest source data and syndicate trusted master data back to operational, analytical, and reporting systems. Build ingestion and integration jobs, implement change data capture, and stand-up real-time resolve-and-lookup services with acceptable latency. Consume an authenticated claim from the identity platform and translate it to a resolved party identifier through the orchestration and integration layer. Cloud data platform Build on a modern cloud data stack, Azure preferred, using the medallion or lakehouse pattern across bronze, silver, and gold. Manage multiple environments (development, test, QA, production) with performance tuning, monitoring, and cost awareness. Graph engineering Implement the relationship graph on a property-graph store (Neo4j with Cypher, or Cosmos DB with Gremlin), keyed strictly on the canonical party identifier. Build graph queries and traversals for multi-hop questions such as UBO chains and advisor-to-borrower authorization, returning explainable, evidenced assertions with effective dates. Programming and platforms Strong SQL and proficiency in Python, with Java or .Net as needed to extend MDM platforms and build services. Hands-on with at least one enterprise MDM platform (Informatica MDM, Reltio, Semarchy, Ataccama, or Profisee) and the judgment to weigh build-lite on the existing stack against a packaged product. Comfortable with data governance and quality tool (for example Ab Initio or Collibra) and with workflow tooling. Security, governance, and regulatory Build for audit and regulatory review: full lineage, decision logs, and traceable survivorship. Apply KYC, AML, and beneficial ownership requirements under the Bank Secrecy Act and USA PATRIOT Act, and handle PII, tokenization, and access controls appropriately. Desired ExperienceTen to fifteen years in enterprise data engineering and architecture, with master data management delivered in production, not just designed. Demonstrated ability to both architect and build, having designed the system and then implemented it, not a design-only background. Financial services required, private and commercial banking strongly preferred, where a client is at once a person, an entity, a household member, and a borrower, and where party is a regulated, first-class concept. Proven physical MDM design with a party model, and experience resolving duplicated or unresolved entities upstream in identity. Familiarity with enterprise identity platforms, including Ping, and how digital identity binds to data identity. Experience building for audit in a regulated industry, having survived a real audit or examination. AI-assisted MDM: intelligent match scoring, automated survivorship suggestions, and anomaly flagging, kept governed, auditable, and validated before promotion to master. Experience with the systems common to banking estates: core banking (for example Fiserv), CRM (for example Salesforce), loan origination and servicing (for example Broadridge), and client due diligence (for example Fenergo). A track record of mentoring or leading a small engineering team, and consulting or client-facing delivery experience. Exposure to externalized authorization or relationship-based access control, where the graph supplies context and a decision point applies policy. Certifications Certifications are preferred, not mandatory. We value demonstrated, hands-on delivery above any credential, and a candidate certified on one platform who can clearly reason across others is stronger than one certification alone. A current certification in one or more of the following is a plus. MDM platforms Informatica: Professional or Practitioner certification in MDM, MDM SaaS or Cloud, or Informatica Data Quality (IDQ), and related Intelligent Data Management Cloud (IDMC) credentials. Reltio Certified Professional, for the Reltio Connected Data Platform. Semarchy xDM certification (Discovery or Practitioner). Ataccama ONE certification. Profisee certification, particularly for teams on the Microsoft and Azure stack. Cloud, data platform, and graph Microsoft Azure: Azure Data Engineer Associate (DP-203) or Azure Solutions Architect Expert, given our Azure-preferred stack. Databricks or Snowflake certification where the client stacks calls for it. Neo4j Certified Professional, or an equivalent graph credential, for the relationship graph work. Governance and adjacent Data governance or quality credentials such as Collibra Ranger, or the DAMA CDMP (Certified Data Management Professional). A recognized cloud security or privacy certification is a plus given the regulated setting. The salary range for this position is: $125,000-$175,000+k/annually. Actual compensation within the range will be dependent upon the individual's skills, experience, qualifications and location, and applicable employment laws. This range is exclusive of any bonuses or commissions. HIKE2 offers a wide range of benefits for full time employees which may include medical, dental, vision, 401k, holiday pay, vacation, personal and family sick leave, and more. Don’t meet every requirement? As an innovation consultancy, we recognize that talent is not always related to job history and skills come from valuable experiences that aren’t always shown on a resume. If you are excited to make a positive impact, but your experience doesn’t align perfectly, we encourage you to apply. You may be the right candidate for our organization, whether it be this role or another. Accommodation Statement We are committed to providing reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs throughout the hiring process. If you require an accommodation to complete the application or participate in the interview process, please let us know. BGC Notice Employment may be contingent upon successful completion of a background check, conducted in compliance with applicable federal, state, and local laws. For only those qualified applicants that are impacted by the Los Angeles County Fair Chance Ordinance for Employers, the Los Angeles' Fair Chance Initiative for Hiring Ordinance, the San Francisco Fair Chance Ordinance, San Diego County Fair Chance Ordinance, and the California Fair Chance Act, where applicable, arrest or conviction records will be considered for Employment in accordance with these laws. At HIKE2, we recognize that conviction records may have a direct, adverse, and negative relationship to responsibilities such as accessing sensitive company or customer information, handling proprietary assets, or collaborating closely with team members. We evaluate these factors thoughtfully to establish a secure and trusted workplace for all. US Citizenship Due to the nature of our client work, all applicants must reside in the U.S. and hold US Citizenship to be considered for employment. Hike2 cannot sponsor work authorizations or visas now or in the future. EEO Statement We are an equal opportunity employer and are committed to creating an inclusive environment for all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, national origin, age, disability, genetic information, protected veteran status, marital status, or any other status protected by applicable federal, state, or local law. Disclaimer This job description is not intended to be an exhaustive list of duties, responsibilities, or qualifications and may be modified at any time to meet business needs.