Sr. MDM Data Architect

* Location:

* Remote (4-6 months) then Hybrid 2x per week + every other Friday

* Worksite Options:

• San Diego, CA
• Dallas, TX

(must be local to either San Diego or Dallas for contract-to-hire conversion)

Conversion Rate is DOE/location

Employment Type:

4-6-Month Contract-to-Hire

Position Summary A Leading Broker Dealer client is seeking an experienced MDM Data Architect to support a large-scale enterprise data transformation initiative within a leading financial services organization. This individual will play a key role in designing and evolving the enterprise data ecosystem, with a strong focus on Master Data Management (MDM), data modeling, data governance, and data quality.

This position will partner closely with business stakeholders, data engineers, analytics teams, and architecture leadership to build scalable data solutions that support analytics, reporting, AI initiatives, and operational business needs.

• Define and maintain enterprise data architecture standards, principles, and roadmaps.
• Align data architecture with business objectives and strategic transformation initiatives.
• Evaluate emerging technologies and recommend improvements to the data ecosystem.
• Design scalable, reusable, and sustainable data solutions.

• Create conceptual, logical, physical, dimensional, and semantic data models.
• Develop scalable data structures across operational and analytical environments.
• Define master data, reference data, and metadata management strategies.
• Ensure consistency across key business domains.

• Support enterprise MDM strategy and architecture.
• Define golden records, matching and merging logic, survivorship rules, and governance processes.
• Partner with business stakeholders to establish stewardship and ownership models.
• Support implementation and governance of MDM platforms.

• Develop enterprise data quality frameworks and standards.
• Establish data quality KPIs, monitoring, scorecards, and observability processes.
• Define standards for lineage, metadata management, cataloging, and stewardship.
• Collaborate with compliance and security teams to meet regulatory requirements.

• Design and govern modern cloud-based data platforms.
• Architect data lakes, lake houses, warehouses, and real-time data solutions.
• Establish ingestion, transformation, storage, and consumption patterns.
• Ensure solutions meet performance, scalability, reliability, and cost objectives.

• 8+ years of experience in Data Management, Data Engineering, Analytics, or related fields.
• 3+ years of experience in a Data Architect or Enterprise Data Architecture role.
• Strong expertise in data modeling methodologies:
  Conceptual, Logical, Physical, Dimensional, Semantic.
• Experience with Master Data Management (MDM) programs.
• Strong understanding of:
  Data Governance, Data Quality Frameworks, Metadata Management, Data Lineage.
• Advanced SQL experience.
• Experience designing enterprise-scale cloud data platforms.
• Ability to translate business requirements into data architecture solutions.

• Financial Services, Wealth Management, or Broker-Dealer industry experience.
• Experience with:
  Snowflake, Databricks, Erwin, Informatica, Semarchy, Other MDM platforms.
• Knowledge of:
  Data Mesh, Data Fabric, Lakehouse Architecture, Medallion Architecture (Raw, Staging, Normalized Layers).
• Experience supporting AI, machine learning, and advanced analytics initiatives.

• Databricks (Raw, Staging, Normalized Layers)
• Snowflake (Dimensional & Semantic Layer)

• Data Modeling
• Data Governance
• Data Quality
• Master Data Management (MDM)
• Data Integration
• API-Based Architecture

• Opportunity to help build a modern enterprise data ecosystem from the ground up.
• High-visibility role supporting a major enterprise transformation initiative.
• Direct exposure to executive leadership and strategic decision-making.
• Ability to influence architecture, tooling decisions, and long-term data strategy.
• Contract-to-hire opportunity with strong long-term growth potential.

Location Requirement:
Candidates must be able…