Sr. MDM Data Architect

TEKsystems; San Diego (CA); Hybrid; USD 110,000 - 138,000; Full time

Job summary

TEKsystems seeks an experienced MDM Data Architect to support a large-scale enterprise data transformation in the financial services sector. You will design and evolve the data ecosystem with a focus on MDM, data modeling, governance, and data quality.

You will partner with business stakeholders, data engineers, analytics teams, and architecture leadership to deliver scalable solutions for analytics, AI, and operations.

Qualifications

• 8+ years of experience in Data Management, Data Engineering, Analytics, or related fields.
• 3+ years in a Data Architect or Enterprise Data Architecture role.
• Strong expertise in data modeling: conceptual, logical, physical, dimensional, semantic.
• Experience with Master Data Management (MDM) programs.
• Strong understanding of data governance, data quality frameworks, metadata management, and data lineage.
• Advanced SQL experience.
• Experience designing enterprise-scale cloud data platforms.
• Ability to translate business requirements into data architecture solutions.

Responsibilities

• Define and maintain enterprise data architecture standards, principles, and roadmaps.
• Align data architecture with business objectives and transformation initiatives.
• Evaluate emerging technologies and improve the data ecosystem.
• Design scalable, reusable data solutions across environments.
• Create data models: conceptual, logical, physical, dimensional, semantic.
• Partner with stakeholders to establish stewardship and ownership models.

Skills

Data modeling

Data governance

SQL

Enterprise data arch

Stakeholder collab

Tools

Snowflake

Databricks

Erwin

Informatica

Semarchy

Job description

*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.

Data Architecture & Strategy

• 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.

Data Modeling

• 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.

Master Data Management (MDM)

• 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.

Data Quality & Governance

• 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.

Cloud & Data Platform Architecture

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

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Technology Environment Data Platforms

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

Data Architecture Focus

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

Why Join?

• 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 to work in a hybrid environment and be located near either the San Diego, CA or Dallas, TX office for future conversion consideration.

Job Type & Location: This is a Contract to Hire position based out of San Diego, CA.

Pay and Benefits

The pay range for this position is $80.00 - $100.00/hr.

Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type: This is a hybrid position in San Diego,CA.

Application Deadline: This position is anticipated to close on Sep 7, 2026.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: 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.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.