Lead Data Architect: Investment Data & MDM Expert

Yoh,-A-Day-; Boston (MA); Remote; USD 8,954,000 - 11,021,000; Full time

Benefits offered by this job

Equal Opportunity Employer

Job summary

Yoh, a Day & Zimmermann company, is seeking a Senior Lead Data Architect/Data Modeler to support enterprise data architecture in large investment management environments. The role emphasizes conceptual, logical, and physical data modeling, ER diagrams, and MDM/reference data expertise.

Experience with S&P EDM / Markit EDM and strong mentorship capabilities are highly valued. Candidates should be able to translate business needs into scalable data structures and collaborate across data

Qualifications

• 10+ years of data architecture, data modeling, enterprise data analysis, database design, or MDM/reference data experience.
• Deep experience creating conceptual, logical, and physical data models with entities, attributes, and relationships.
• Strong SQL and relational database experience (Oracle/SQL Server or equivalent).

Responsibilities

• Translate business requirements into conceptual, logical, and physical data models for enterprise-scale solutions.
• Create ER diagrams, data definitions, keys, hierarchies, and design artifacts for engineering teams.
• Reverse-engineer large datasets to identify entities, relationships, and data quality gaps.
• Define data structures, mappings, transformation logic, metadata, and governance needs for implementations.
• Mentor team members on modeling principles and data design practices.

Skills

Data modeling

Data architecture

SQL

MDM

Tools

Erwin

ER/Studio

Visio

Excel

PowerPoint

Word

Job description

Yoh, a Day & Zimmermann company, is seeking a Senior Lead Data Architect/Data Modeler to support enterprise data architecture in large investment management environments. The role emphasizes conceptual, logical, and physical data modeling, ER diagrams, and MDM/reference data expertise.

Experience with S&P EDM / Markit EDM and strong mentorship capabilities are highly valued. Candidates should be able to translate business needs into scalable data structures and collaborate across data