Senior Data Architect

generis Tek•Burbank, CA

4h•Hybrid

About The Position

This is a contract role for a Senior Data Architect with a hybrid work model, located in Burbank, CA. The position is for a client and has a duration of 6+ months, with the potential for contract to hire. The role involves extensive experience in data architecture, modeling, engineering, and large-scale data migration, particularly within the pension/retirement, financial services, insurance, or healthcare industries. A key responsibility is ensuring successful migration by addressing source data quality issues. The architect will also manage offshore teams and collaborate with various stakeholders.

Requirements

15+ years of experience in Data Architecture, Data Modeling, Data Engineering, and large-scale data migration.
Strong expertise in enterprise data architecture.
Hands-on experience with complex legacy-to-modern platform migrations.
Strong SQL and relational database expertise.
Ability to perform source-data analysis, profiling, dependency analysis, source-to-target mapping, transformation rules, ETL architecture, data lineage, and migration design.
Ability to translate business rules into technical transformation logic.
Strong experience in data quality, data remediation, and cleansing.
Ability to perform data reconciliation and validation.
Excellent architecture and stakeholder-management skills.
Ability to translate complex business requirements into scalable data solutions.
Ability to manage offshore Data Architects, Data Analysts, Data Engineers, ETL Developers, and QA teams.

Nice To Haves

Experience preferably within Pension/Retirement, Financial Services, Insurance, or Healthcare.
Strong understanding of pension/retirement data domains such as participants, beneficiaries, employment, earnings, pension credits, benefits, payments, and related-party relationships.

Responsibilities

Designing and implementing enterprise data architecture.
Performing conceptual, logical, and physical data modeling.
Managing complex legacy-to-modern platform migrations, including multiple source systems, cross-system dependencies, migration sequencing, and cutover strategy.
Analyzing, profiling, and mapping source data.
Defining transformation rules and ETL architecture.
Ensuring data lineage and migration design.
Translating business rules into technical transformation logic.
Overseeing data quality, remediation, and cleansing processes.
Identifying duplicates, missing/inconsistent data, and invalid relationships.
Performing data reconciliation and validation, including record counts, financial amounts, balances, historical records, relationships, and key business attributes.
Collaborating effectively with Product Owners, Technical Architects, SMEs.
Managing offshore Data Architects, Data Analysts, Data Engineers, ETL Developers, and QA teams for design, technical walkthroughs, backlog refinement, and implementation oversight.
Fixing source data issues as a critical part of successful migration.