Lead Data Architect / Modeler with MDM / Reference Data- Remote EST

Role 2: Senior Data Architect / Data Modeler Working Title: Senior Data Architect / Data Modeler - Investment Data, MDM & Enterprise Data Architecture Role Summary Seeking a senior data architect / data modeler to support enterprise data architecture and database design across complex investment-data initiatives. This role has been recalibrated from a general Sr. Data Analyst profile to a true data architecture and data modeling role. The primary requirement is deep data modeling capability: conceptual, logical, and physical modeling; entity relationships; database design; and the ability to turn business needs into scalable data structures. Investment management experience is valuable, but it is not the primary screen. The most important requirement is proven success creating data models and data architecture for large enterprise environments. Experience with master data management and S&P EDM / Markit EDM is highly desirable. Core Mission Receive business requirements and translate them into conceptual, logical, and physical data models that support enterprise-scale data solutions. Create database designs and data architecture deliverables that can be used by engineering, data management, EDM/MDM, and business teams. Mentor team members and business/data partners on modeling principles, entity relationship thinking, data definitions, and design discipline. Support reference data, MDM, investment data, and enterprise data delivery initiatives with clear, reusable models and design artifacts. Help improve data delivery strategy by bringing disciplined modeling and architecture capability into complex, ambiguous data programs. Key Responsibilities Develop conceptual, logical, and physical data models from business requirements, source data analysis, business processes, and downstream consumption needs. 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. Required Experience 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. Preferred / Plus Experience Financial services, investment management, asset management, wealth management, OCIO, custody, or buy-side vendor experience. Knowledge of fund instruments, mutual funds, CITs, fund pricing, ABOR, IBOR, PBOR, TBOR, custodial data, portfolio data, pricing data, and investment operations data. Experience with MDM/reference data platforms, especially S&P EDM / Markit EDM, including EDM implementations, MDM use cases, and reference data lifecycle management. Experience with State Street Alpha, Charles River, Aladdin, FactSet, Bloomberg, Eagle, GoldenSource, or other trading/investment data management platforms. Experience with Erwin, ER/Studio, dbdiagram/DB Studio, Visio, PowerPoint, Excel, Word, or similar modeling/documentation tools. Certifications such as CFA, CAIA, or CIPM are helpful but not required.Estimated Min Rate: $56.00Estimated Max Rate: $80.00What’s In It for You?We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh’s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh’s extensive talent community that will provide you with access to Yoh’s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)Health Savings Account (HSA) (for employees working 20+ hours per week)Life & Disability Insurance (for employees working 20+ hours per week)MetLife Voluntary BenefitsEmployee Assistance Program (EAP)401K Retirement Savings PlanDirect Deposit & weekly epayrollReferral Bonus ProgramsCertification and training opportunitiesNote: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.Visit to contact us if you are an individual with a disability and require accommodation in the application process.For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.By applying and submitting your resume, you authorize Yoh to review and reformat your resume to meet Yoh’s hiring clients’ preferences. To learn more about Yoh’s privacy practices, please see our Candidate Privacy Notice: Safe During Your Job SearchFraudulent recruiting communications have become increasingly common. Emails from Yoh recruiters will only come from an @yoh.com email address. Yoh will never ask candidates to pay fees, purchase equipment, send gift cards, or transfer funds as part of the recruiting or hiring process. If you receive a communication that appears suspicious or requests payment, contact Yoh directly before responding or sharing personal information.Reference: BH-399584