Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Master Data Reference Architect

$70 - $75 per hour

Artech LLC

Job Description

Job Description

Job ID: 112479-1
Title: Master Data Reference Architect
Duration: 6+ months with possible extension
Location: Remote or Chicago, IL
Pay Range: $70- $75/hr

Summary
We are seeking a senior architect to own master and reference data architecture for the Firm. This is a strategic, hands-on role that defines the canonical model for the Firm's core business entities - what each entity means, which system is authoritative for it, and how entities relate - and implements that model in the Firm’s MDM platform - Profisee, so that every function depending on those entities works from the same trusted data.
Enterprise Information Architecture
· Define and maintain the canonical model for the Firm's core business entities, establishing agreed definitions for each entity, its attributes, its identifiers, its lifecycle and its permitted values
· Work with business subject matter experts across each domain to document current process and data structures, and model how they align to the canonical model or reveal where it must evolve
· Work with source system DBAs and application owners to document physical schemas, keys and constraints, and ground crosswalks and canonical identifiers in how those systems actually store and enforce data
· Work with the teams building Fabric semantic models to validate that dimensions and hierarchies function as intended in production reporting, and adjust the canonical model where downstream structure or grain requires it
· Model the relationships that cross domain boundaries, where most enterprise data ambiguity originates: timekeeper to matter to client to billing arrangement to revenue attribution; matter to practice group to organizational hierarchy; person to role to office to cost center
· Designate the authoritative source for each entity and attribute, and document the crosswalks that reconcile source system keys and conventions into canonical identifiers
· Resolve semantic conflicts between source systems and business functions, driving agreement on a single definition rather than accommodating parallel versions
Master Data Design
• Configure the canonical model in Profisee as entity and attribute structures, hierarchies and cross-entity dependencies, in non-production, for engineering promotion
• Determine, for each domain, whether the mastered record writes back to source systems or flows one-directionally into OneLake and reporting, and design the Profisee model to match that pattern
• Design how cross-domain relationships are implemented and enforced in Profisee — cardinality, referential integrity and cascade behavior on merge, update or retirement — so relationships stay valid as golden records change
• Define match, merge and survivorship logic that produces defensible golden records, and the attribute-level quality expectations that govern them
• Design how client and organization master records are matched and enriched against external data sources — Bloomberg, S&P, FactSet and comparable providers — to strengthen corporate hierarchy and ultimate parent accuracy for conflicts checking and relationship visibility. Define the golden record lifecycle — creation, merge, unmerge and retirement — and how each state change is communicated to downstream consumers and preserved in history
• Design the attribute-level security and visibility model for sensitive master data — financial terms, confidential client relationships, restricted personnel information — aligned to the Firm's ethical wall and information barrier requirements
• Advise on stewardship decisions the model requires, for MDM engineering to implement as workflow & Specify the publication contract for mastered data to consuming systems and OneLake
Reference Data Architecture
• Establish the reference data architecture for the Firm's controlled vocabularies and code sets — Matter classification schemes (Client taxonomies), practice and industry classifications, currencies, locations and geographies, etc.
• Design the temporal model for reference data and hierarchies, including effective dating, versioning and as-of semantics, and define whether and how historical reporting restates when a structure changes
• Design and maintain the mappings between equivalent code set values across the Firm's systems, so that differing local values resolve to a single governed value without requiring every source system to change how it records them
• Model multilevel hierarchies and alternate rollups, allowing the same underlying structure to support different views for finance, practice leadership and client reporting without duplicating the source
• Design the change control model for reference data: how values are proposed, approved, versioned, deprecated, rather than deleted, and communicated to affected systems and reports
• Specify distribution patterns that make governed reference data available to operational systems as well as analytics, so that consuming applications use the authoritative list rather than maintaining private copies
Required Qualifications
• More than 10 years in data architecture and data modeling on large-scale enterprise data platforms
• Demonstrated ownership of an enterprise or cross-domain information model — defining core entities, attributes, relationships and authoritative sources, and driving organizational agreement on those definitions
• Strong conceptual and logical modeling capability, including normalized and dimensional modeling, and the ability to translate complex domain hierarchies into clean, durable structures
• Hands-on configuration experience with Profisee or a comparable multidomain MDM platform, including entity and attribute modeling, match and merge, survivorship and hierarchy management
• Demonstrated design of reference data architecture as a discipline in its own right — code set governance, effective dating and versioning, alternate hierarchy rollups, external code set crosswalks and change control
• Working knowledge of Client Fabric and OneLake, sufficient to specify publication contracts and analytics-ready structures rather than to engineer the platform
• Advanced SQL & Demonstrated ability to operate as a design authority across team boundaries — producing specifications engineering teams can build from, and reaching durable decisions with senior business stakeholders
Preferred Qualifications
• Experience in a law firm or professional services environment
• Experience with Client Purview or a comparable catalog and glossary platform, including glossary design and lineage curation
• Experience designing conformed dimensions and hierarchies consumed by Power BI
• Experience establishing data ownership in a partnership or federated organization

Skills: Client Power BI, Client Fabric, Master Data Management (MDM)
Experience Required: 8-10

Company Benefits & Culture
•    Inclusive and diverse work environment
•    Opportunities for professional growth and development
•    Comprehensive health and wellness benefits
Vacancy posted 21 days ago
Similar jobs that could be interesting for youBased on the Master Data Reference Architect in Chicago, IL vacancy
  • $132.23k - $176.31k

     ...the AI‑powered world, connecting people, data, and applications through our expansive fiber...  ...The Senior Lead Marketing Data Platform Architect is responsible for defining, governing,...  ...more information on these checks, please refer to the Post Offer section of our FAQ... 
    Suggested
    Full time
    Temporary work

    Lumen

    Chicago, IL
    3 days ago
  •  ...exceptional service. We are seeking an experienced Data Architect to lead the data architecture strategy for our Securities...  ...Expertise in data modeling, data governance, metadata management, reference/master data, and data quality frameworks. ~ Experience designing... 
    Suggested
    H1b
    Worldwide
    Flexible hours

    Northern Trust

    Chicago, IL
    13 days ago
  •  ...University. Job Summary The Lead Data Architect sets the architecture for how the University...  .... Sets architecture standards and reference patterns; designs principles for data...  ...Owns the technical architecture for master data for identity, so one person resolves... 
    Suggested
    Work experience placement
    Work at office

    University of Chicago

    Chicago, IL
    12 hours ago
  •  ...Job Description Small Chicago-based builder/ developer seeks a master framer/builder. The projects are scattered throughout the...  ...benefits to the right candidate. Please reply with your resume, references, and availability. Company Description We are looking to... 
    Suggested
    Part time
    Work at office

    Construction Company

    Chicago, IL
    9 days ago
  • $129.2k

     ...Description Are you a Master's student interested in machine learning, natural language processing, computer vision, automated reasoning, or robotics? We are looking for skilled scientists capable of putting theory into practice through experimentation and invention,... 
    Suggested
    Full time
    Internship
    Work at office
    Relocation
    Relocation package

    Amazon

    Chicago, IL
    3 days ago
  •  ...RESPONSIBILITIES The law enforcement and security community provide a wide range of critical services to every part of the Navy. As a Master-at-Arms you may: Provide security and physical protection for service members Train fellow Sailors in security and shore... 
    Part time
    Overseas

    U.S. Navy

    Chicago, IL
    4 days ago
  •  ...WiproContact: Meghana GorusuCompany: SRI Tech SolutionsJob Title: AWS Data Architect (Finance & Capital Markets)Location: Chicago, IL (2-3 days...  ...regulatory reporting.Familiarity with time-series data, reference/master data, and real-time analytics.PreferredExposure to Delta... 
    2 days per week
    3 days per week

    SRI Tech

    Chicago, IL
    12 hours ago
  • $168.5k - $206k

     ...Information Job Title Principal Data Architect Job ID 108701 Work Areas Analytics...  ...Develop as-is and to-be architectures, reference models, migration options, and...  ...data architecture, data modernization, Master Data Management, Data Office design, and... 
    Permanent employment
    Full time
    Work at office
    Local area

    Bain & Company

    Chicago, IL
    3 days ago
  • $175k - $205.9k

    Are you ready to make an impact?West Monroe is seeking a Data Architect, Google Cloud Platform (GCP) to design and deliver scalable, cloud...  ...client relationships.Practice DevelopmentDevelop reusable reference architectures, accelerators, standards, and delivery methodologies... 
    Local area
    Immediate start
    Flexible hours

    West Monroe Partners

    Chicago, IL
    2 days ago
  • $196k - $235k

     ...Summary:We are seeking a hands-on Principal Data Architect to transform JLL's data consumption...  ....Required QualificationsBachelor's or Master's degree in Computer Science, Engineering...  ...establishing architecture standards, reference architectures, and technical guardrails... 
    Full time
    Local area
    Remote work

    Jones Lang LaSalle

    Chicago, IL
    3 days ago
  • $193k - $236k

     ...bigger, and build better tomorrows for all.Master Data Management (MDM) - Principal (Vacant...  ...graph, and AI-ready data ecosystems* Architect enterprise-wide mastering strategies spanning...  ..., product, supplier, location, and reference data domains* Leverage AI, machine... 
    Temporary work
    Work at office
    Local area

    Slalom

    Chicago, IL
    2 days ago
  •  ...Data/Senior Data Architect You are a data/senior data architect who designs enterprise data fabric...  ...analytics and AI and you can define the reference architectures and integration...  ...experience Bonus points if: You have a Master's degree in a relevant field You... 
    Work experience placement
    Work at office
    Local area

    Hackajob

    Chicago, IL
    2 hours ago
  •  ...Job Role- Data Atchitect Location- Chicago, US (preferred but no restriction for good candidate) We are seeking a Data Architect with strong experience in Microsoft Azure, PostgreSQL with Apache AGE, graph databases, and knowledge graph development. The role will... 

    Excelerate Technologies

    Chicago, IL
    1 day ago
  •  ...people, shareholders, partners, and communities.You Are:A senior data architecture leader with deep experience in enterprise data...  ...systems, and analytics platforms.Create reusable mapping frameworks, reference architectures, accelerators, and implementation patterns that... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Chicago, IL
    1 day ago
  •  ...MUST BE A US CITIZEN OR GC Holder We are looking for a Data Architect with heavy Databricks experience for a Fortune 500 logistics customer...  ...Required Experience & Qualifications ~ Bachelor's or Master's degree in Computer Science, Engineering or a related technical... 
    Remote work

    Xinova Group

    Chicago, IL
    12 days ago
  •  ...Principal Data Modeller | Credit / Financial Data Contract Chicago | Hybrid / flexible...  ...role requires a senior data modeller/architect to take ownership of a complex financial...  ...data (credit, risk, markets, or reference data) Ability to work in messy environments... 
    Contract work
    Flexible hours

    Intelix.AI

    Chicago, IL
    12 days ago
  •  ...as you are in a whiteboard session with architects. You shape complex deals, craft executive...  ...problems to agentic AI outcomes; use data‑backed storytelling to secure executive...  ...Technical Leadership & ArchitectureDefine reference architectures and patterns for agentic workflows... 

    Avanade

    Chicago, IL
    4 days ago
  • $49 - $85 per hour

    Join a hands-on Data Architect opportunity focused on designing and building a modern data integration platform for batch, micro-batch, and real-time data. This role is ideal for a technical builder who enjoys solving complex data challenges across cloud, on-premises,... 
    Hourly pay

    Horizontal Talent

    Chicago, IL
    3 days ago
  •  ...Job Description Job Description Job Title: Senior Data Architect and Engineer Primary Location: Chicago Loop! Position Type:...  ...a background check, which may include but is not limited to reference checks, education verification, employment verification, drug... 
    Visa sponsorship

    Talentfish

    Chicago, IL
    6 days ago
  • $132.9k - $199.3k

    OverviewMcGuireWoods LLP is seeking a Data Architect to join our IT team. The Data Architect is responsible for the design and technical architecture of the Firm’s Data Lakehouse environment and ensures that data is appropriately structured, integrated, and available to... 
    Remote work

    McGuireWoods

    Chicago, IL
    4 days ago
  • $140k - $170k

     ...Research Platform Architect The Federal Reserve Bank of St. Louis is seeking a Research Platform Architect to lead the technical vision...  ..., researchers, students, and developers worldwide. The Data Architect will lead the design and modernization of the data architecture... 
    Full time
    Worldwide
    Flexible hours

    Federal Reserve System

    Chicago, IL
    3 days ago
  • * Responsible for ensuring that the data management and governance frameworks are in place and adhered to * Responsible for Architecting Data engineering pipelines including data acquisition, Ingestion, management, processing, publishing by leveraging various AWS services... 

    United IT Solutions

    Chicago, IL
    3 days ago
  • $170k - $210k

     ...We are looking for a visionary and hands-on Senior Data Architect to lead our data modeling, integration patterns, and semantic dataset initiatives. In this role, you will be the bridge between traditional data engineering and cutting-edge AI systems. You will work... 
    Contract work
    Temporary work
    Remote work
    Flexible hours

    EPAM Systems Inc

    Chicago, IL
    4 days ago
  •  ...Role: Data Migration ArchitectType: FulltimeLocation: Hybrid (Chicago)JD: Results-driven OpenText Documentum D2 & Data Migration Architect with deep expertise in designing, executing, and optimizing complex enterprise content migrations. Proven track record of successfully... 
    Shift work

    AppLab Systems Inc

    Chicago, IL
    1 day ago
  • $179.4k - $204.7k

     ...disciplines, such as Ops, Modeling, and Data Engineering. In this role, you'll be expected...  ...systems Preferred Qualifications: ~ Master's or Doctoral Degree in Computer Science,...  ...work within one of these locations, and refers to the amount Capital One is willing to... 
    Full time
    Part time
    H1b
    Local area

    Capital One

    Chicago, IL
    1 day ago
  • $147k - $260.7k

     ...like you and that’s why there’s nowhere like RSM.Solution Architect - Data Solutions ArchitectThe Solution Architect - Data Solutions...  ...medallion consumption layers.Establish integration standards for master/reference data synchronization and change-data-capture strategies.... 
    Full time
    Contract work
    Work experience placement
    Internship
    Work at office
    Local area

    RSM International

    Chicago, IL
    2 days ago
  • $179.4k - $204.7k

     ...disciplines, such as Ops, Modeling, and Data Engineering. In this role, you'll be expected...  ...systems Preferred Qualifications: ~ Master's or doctoral degree in computer science,...  ...work within one of these locations, and refers to the amount Capital One is willing to... 
    Full time
    Part time
    H1b
    Local area

    Capital One

    Chicago, IL
    13 hours ago
  • We Are:The beginning of a new Data & AI decade that will reshape...  ...:You are a data/senior data architect who designs enterprise data fabric...  ...AI — and you can define the reference architectures and integration...  ...​Bonus Points If:You have a Master’s degree in a relevant... 
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Chicago, IL
    1 day ago
  •  ...Stadium is looking for a Master Control Operator to join our team. The Master Control Operator should be technically inclined with a comprehensive understanding of and the ability to operate broadcast equipment in a master control environment. This includes original taped... 
    Work at office
    Remote work
    Flexible hours
    Night shift
    Weekend work

    Bally's Corporation

    Chicago, IL
    4 days ago
  • $20 - $23 per hour

     ...Angeles, and Chicago. Weigel is the creator of the nationally syndicated music format MeTV FM. For more information on Weigel, visit: Master Control Operator: Weigel Broadcasting Co in Chicago, Illinois is seeking a detail-oriented and self-motivated Master Control... 
    Local area
    Shift work
    Afternoon shift

    Weigel Broadcasting

    Chicago, IL
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Master Data Reference Architect. Be the first to apply!