Master Data Reference Architect
$70 - $75 per hourArtech 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
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...SuggestedFull timeTemporary work- ...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...SuggestedH1bWorldwideFlexible hours
- ...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...SuggestedWork experience placementWork at office
- ...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...SuggestedPart timeWork at office
$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,...SuggestedFull timeInternshipWork at officeRelocationRelocation package- ...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 timeOverseas
- ...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 week3 days per week
$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 employmentFull timeWork at officeLocal area$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 areaImmediate startFlexible hours$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 timeLocal areaRemote work$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 workWork at officeLocal area- ...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 placementWork at officeLocal area
- ...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...
- ...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 placementLive inWork at officeLocal area
- ...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
- ...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 workFlexible hours
- ...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...
$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- ...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
$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$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 timeWorldwideFlexible hours- * 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...
$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 workTemporary workRemote workFlexible hours- ...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
$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 timePart timeH1bLocal area$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 timeContract workWork experience placementInternshipWork at officeLocal area$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 timePart timeH1bLocal area- 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 placementLive inWork at officeLocal area
- ...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 officeRemote workFlexible hoursNight shiftWeekend work
$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 areaShift workAfternoon shift
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Master Data Reference Architect. Be the first to apply!
Related searches
- masters chemistry Chicago, IL
- master plumbing Chicago, IL
- masters healthcare administration Chicago, IL
- master of public health Chicago, IL
- history masters Chicago, IL
- service master Chicago, IL
- master data coordinator Chicago, IL
- masters degree Chicago, IL
- masters communication Chicago, IL
- masters degree biology Chicago, IL






