DATA ARCHITECT / DATA OFFICER L4

Capgemini; Portsmouth (NH); On-site; USD 70,000 - 110,000; Full time

Job summary

Capgemini in Portsmouth, NH, on-site, is seeking a Data Architect / Data Officer L4 for a 2 month 27 day contract. You will lead end-to-end data conversion activities, collaborate with stakeholders, and ensure data integrity across legacy to target systems.

The role requires 8–12 years in data migration, strong SQL and ETL skills, data modeling expertise, and proven leadership of complex enterprise data conversions. Excellent communication and governance alignment are essential.

Qualifications

• 8-12 years of experience in data migration or data conversion roles.
• Strong understanding of data modeling, ETL concepts, and relational databases (RDBMS).
• Hands‑on experience with SQL and database tools.
• Proven experience leading data conversion activities for enterprise systems.
• Excellent communication, analytical, and stakeholder management skills.

Responsibilities

• Lead and manage the overall data conversion strategy, approach, and execution.
• Analyze source and target data models and define data mapping and transformation rules.
• Coordinate data extraction, cleansing, validation, and reconciliation activities.
• Work closely with business teams to understand data requirements and usage.
• Oversee the development and execution of data conversion scripts and tools.
• Validate converted data through reconciliation, balancing, and exception analysis.
• Identify, track, and proactively resolve data issues and risks.
• Support mock conversions, system testing, UAT, and go-live cutover activities.
• Ensure adherence to data governance, audit, and compliance standards.
• Provide status updates, metrics, and documentation to project leadership.

Skills

Data migration

SQL

ETL/ELT

Data modeling

RDBMS

Stakeholder management

Communication

Job description

DATA ARCHITECT / DATA OFFICER L4 (Contract)

Portsmouth, NH, United States (On-site)

Contract (2 months 27 days)

Published 3 days ago

Data Migration

SQL

ETL / ELT

Job Overview

The Data Conversion Lead is responsible for planning, managing, and executing end-to-end data conversion and migration activities as part of large-scale system implementations or transformations. This role ensures that data from legacy systems is accurately extracted, transformed, validated, and loaded into target systems while maintaining data integrity, quality, and compliance. The Data Conversion Lead works closely with business stakeholders, application teams, architects, and vendors to ensure successful data migration aligned with project timelines and business objectives.

Key Responsibilities

• Lead and manage the overall data conversion strategy, approach, and execution.
• Analyze source and target data models and define data mapping and transformation rules.
• Coordinate data extraction, cleansing, validation, and reconciliation activities.
• Work closely with business teams to understand data requirements and usage.
• Oversee the development and execution of data conversion scripts and tools.
• Validate converted data through reconciliation, balancing, and exception analysis.
• Identify, track, and proactively resolve data issues and risks.
• Support mock conversions, system testing, UAT, and go-live cutover activities.
• Ensure adherence to data governance, audit, and compliance standards.
• Provide status updates, metrics, and documentation to project leadership.

Required Skills & Experience

• 8-12 years of experience in data migration or data conversion roles.
• Strong understanding of data modeling, ETL concepts, and relational databases (RDBMS).
• Hands‑on experience with SQL and database tools.
• Proven experience leading data conversion activities for enterprise systems.
• Excellent communication, analytical, and stakeholder management skills.

The pay range that the employer in good faith reasonably expects to pay for this position is $50.93/hour - $79.58/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non‑public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Success Factors

• Accurate and timely data conversion with minimal postgolive defects
• Strong collaboration across technical and business teams
• High data quality and stakeholder confidence in converted data