Senior Data Architect: MDM & Reference Data (Remote)

Yoh Services LLC; Boston (MA); Remote; USD 77,000 - 110,000; Full time

Benefits offered by this job

Medical Benefits (medical, Rx, dental,

Health Savings Account (HSA)

Life & Disability Insurance

MetLife Voluntary Benefits

Employee Assistance Program (EAP)

401K Retirement Savings Plan

Direct Deposit & weekly epayroll

Referral Bonus Programs

Certification and training

Job summary

Yoh Services LLC in Boston seeks a Senior Data Architect / Data Modeler to lead enterprise data architecture, data modeling, and MDM/EDM design for investment data initiatives. Deep modeling across conceptual, logical, and physical layers is required, with mentoring responsibilities for team members and business partners.

Strong SQL and relational database experience (Oracle/SQL Server) plus experience shaping data definitions and governance will help drive scalable data solutions in a large

Qualifications

• 10+ years of data architecture, data modeling, enterprise data analysis, database design, or MDM/reference data experience in large enterprise environments.
• Deep experience creating conceptual, logical, and physical data models, including entities, attributes, relationships, keys, hierarchies, normalization, cardinality, and data definitions.
• Ability to take business requirements and turn them into database designs and data architecture deliverables, not just BRDs, specs, or process documentation.
• Strong SQL and relational database experience, including Oracle, SQL Server, or comparable RDBMS environments.
• Experience analyzing complex enterprise datasets, reverse-engineering data entities and relationships, and identifying business concepts from data patterns.
• Experience with ETL concepts, data pipelines, mappings, transformation logic, data quality rules, metadata, lineage, and governance.
• Experience working in large, siloed organizations and navigating incomplete or ambiguous requirements.
• Ability to communicate complex data concepts clearly to business, data, and technology stakeholders.
• Experience mentoring others or elevating team capability around data modeling and data design.

Responsibilities

• Translate business requirements into conceptual, logical, and physical data models that support enterprise-scale data solutions.
• Create ER diagrams, entity relationship definitions, data definitions, attribute definitions, relationship cardinality, keys, hierarchies, and database design artifacts.
• Reverse-engineer large enterprise datasets to identify business concepts, data entities, relationships, patterns, gaps, and inconsistencies.
• Define data structures, mappings, transformation logic, data quality rules, reference data usage, metadata, lineage, and business rules needed to support implementation.
• Partner with business stakeholders, data management teams, EDM/MDM resources, engineers, and architects to align business meaning with technical design.
• Support master data management and reference data design, including universal identifiers, crosswalks, entity resolution, stewardship, quality, accuracy, and timeliness principles.
• Work with SQL and relational databases to analyze source data, validate assumptions, profile data, and support design decisions.
• Create data architecture and design documentation that is clear enough for engineering delivery and business validation.
• Mentor analysts, data partners, and stakeholders on how to move from requirements and business concepts to structured data models and database designs.
• Identify reference data gaps, data management gaps, business process gaps, and propose practical, phased recommendations.

Skills

Data modeling

Data architecture

SQL

Mentoring

Communication

MDM/EDM knowledge

Tools

Erwin

ER/Studio

dbdiagram/DB Studio

Visio

PowerPoint

Excel

Job description

Yoh Services LLC in Boston seeks a Senior Data Architect / Data Modeler to lead enterprise data architecture, data modeling, and MDM/EDM design for investment data initiatives. Deep modeling across conceptual, logical, and physical layers is required, with mentoring responsibilities for team members and business partners.

Strong SQL and relational database experience (Oracle/SQL Server) plus experience shaping data definitions and governance will help drive scalable data solutions in a large