Senior Data Architect

JPS Tech Solutions; Burbank (CA); On-site; USD 140,000 - 210,000; Full time

Job summary

JPS Tech Solutions in California seeks a Senior Data Architect to design enterprise data architectures, models, and migration strategies for large-scale programs. You will lead cross-functional teams through legacy-to-modern platform migrations, ensuring data quality, lineage, and transformation rules are embedded in the solution.

The role requires strong SQL and relational database skills, deep collaboration with Product Owners, SMEs, and offshore data teams, and the ability to translate

Qualifications

• 15+ years of experience in data architecture, modeling, engineering, and large-scale migrations.
• Experience with legacy-to-modern migrations across multiple source systems and cutover strategy.
• Strong SQL and relational databases; source-to-target mapping, transformation rules, and ETL design.
• Expertise in data quality, remediation, cleansing, and data reconciliation.

Responsibilities

• Translate business requirements into scalable data architectures and solutions.
• Collaborate with Product Owners, Technical Architects, SMEs, and offshore Data teams for design walkthroughs and backlog refinement.
• Oversee data migration design, sequencing, validation, and data integrity across complex systems.
• Recognize that successful migration starts with fixing the source data.

Skills

Data architecture

Data modeling

Data engineering

Data migration

SQL

ETL

Data quality

Data cleansing

Data lineage

Stakeholder management

Offshore teams

Job description

Job Description

15+ years of experience in Data Architecture, Data Modeling, Data Engineering, and large-scale data migration, preferably within Pension/Retirement, Financial Services, Insurance, or Healthcare.

Strong expertise in enterprise data architecture and conceptual, logical, and physical data modeling with hands-on experience with complex legacy-to-modern platform migrations, including multiple source systems, cross-system dependencies, migration sequencing, and cutover strategy.

Strong SQL and relational database expertise, with the ability to perform source-data analysis, profiling, dependency analysis, source-to-target mapping, transformation rules, ETL architecture, data lineage, and migration design, including translating business rules into technical transformation logic.

Strong experience in data quality, data remediation, and cleansing, including identifying duplicates, missing/inconsistent data, invalid relationships, and ability to perform data reconciliation and validation, including record counts, financial amounts, balances, historical records, relationships, and key business attributes.

Strong understanding of pension/retirement data domains such as participants, beneficiaries, employment, earnings, pension credits, benefits, payments, and related-party relationships is highly desirable.

Excellent architecture and stakeholder-management skills, with the ability to translate complex business requirements into scalable data solutions and collaborate effectively with Product Owners, Technical Architects, SMEs, along with ability to manage offshore Data Architects, Data Analysts, Data Engineers, ETL Developers, and QA teams for design, technical walkthroughs, backlog refinement, and implementation oversight.

A critical responsibility of this role is recognizing that successful migration starts with fixing the source data.