DATA ARCHITECT / DATA OFFICER L4
Quick facts
- Pay
- $50.93 - $79.58 an hour
- Type
- Full-time
- Location
- Portsmouth, NH
- Experience
- 8–12 years
- Skills
- SQL
- Industry
- Information Technology — 671 open jobs
- Visa in listing
- H-1B
- Apply
- Free to apply — never pay anyone for a job offer or visa sponsorship
Job description
Portsmouth, NH, United States (On-site) Contract (2 months 27 days) Published 15 hours ago enterprise systems Data Migration SQL data conversion ETL / ELT RDBMS (SQL Server, Oracle, PostgreSQL, MySQL, DB2) NoSQL (MongoDB, Elasticsearch) data modelling
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. Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. 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.
Do Not Re-Post | Confidential Submit candidates under their legal name and use only Capgemini template PLEASE SUBMIT CVS IN FG WITH COMPLETE HOME ADDRESS
Role Name: Data Architect
Location: Portsmouth
Start date: 2026-06-15
Background check MANDATORY
GTD ID: I0TLJL
Due to additional onboarding requirements, a meet and greet is required for all new hires. Candidates must be willing to go to the closest Capgemini, Client, or onsite location as indicated by project team to meet with a Capgemini team member prior starting their assignment. If the candidate is not local, travel covered by Capgemini. If travel is involved and after selection the candidate declines the offer, costs will be paid by vendor and not Capgemini.
JOB DESCRIPTION: Data Conversion Lead
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 development and execution of data conversion scripts and tools. Validate converted data through reconciliation, balancing, and exception analysis. Identify, track, and resolve data issues and risks proactively. 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 RDBMS. Hands-on experience with SQL and database tools. Proven experience leading conversion activities for enterprise systems. Excellent communication, analytical, and stakeholder management skills.
Success Factors
Accurate and timely data conversion with minimal post-go-live defects. Strong collaboration across technical and business teams. High data quality and stakeholder confidence in converted data.
Current Location: (City, State & Zip Code): Home location: Relocate: Bill Rate: CTH After 3 Months: Travelling Availability: Availability to Start: Phone/Mobile Number: Skype ID: Email Address: Visa Type: Visa Expiration Date: In process of getting a green card?: Hiring Status: Are you working directly with the contractor’s visa holder: If not indicate # of layers and name of the company: Indicate if the Candidate has worked in CG before and project details along with manager's name: Ex-Capgemini Employee: LinkedIn Account: (MANDATORY) Time slots for an interview (consider 3 to 5 days of availability for faster coordination): Contractor approved to share its resume to client: Skills summary: Resumes will be rejected for the following reasons:
- Different format
- Missing details in comments section
- Missing text box in the header
- Photo ID included containing personal information other than legal name and photo
Only visas accepted are H1B, L2 EAD, H4 EAD, AOS EAD. Permanent residents and green card holders. TN visas only if the contractor lives in US. (if CTH role, only USC and GC holders) External Resource Manager (ERM) | SubCo Staffing Center Capgemini North America | Guatemala
Visa sponsorship record: Capgemini America Inc
Sponsors actively| Fiscal year | H-1B LCAs | USCIS approvals | USCIS denials | PERM |
|---|---|---|---|---|
| FY2026 | 1699 | 1611 | 36 | — |
| FY2025 | 2784 | 2185 | 57 | 361 |
| FY2024 | 1810 | 2795 | 22 | — |
This exact kind of role (Architects) isn't among the roles Capgemini America Inc sponsored most often.
Also filed: E-3 Australian × 17, H-1B1 Singapore × 1 — a good sign for Australian (E-3), Chilean and Singaporean (H-1B1) candidates.
Roles they sponsor most
- applications consultant2294 LCAs · median $133k
- programmer developer881 LCAs · median $110k
- test consultant876 LCAs · median $118k
- business systems analyst558 LCAs · median $118k
- software engineer396 LCAs · median $131k
Which visas can work for this job
Occupation: Architects (SOC 17-1011) — estimated from the job title.
- Mentioned in the listing
H-1B
- H-1B cap-exempt employer
Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).
- TN (citizens of Canada and Mexico)
This kind of role may fit the USMCA profession “Architect / Landscape Architect” — it depends on the actual duties. No lottery, no cap; you need the matching degree or license.
- E-3 (Australia) and H-1B1 (Chile, Singapore)
This employer has filed before (E-3 Australian: 17, H-1B1 Singapore: 1). Same degree requirement as H-1B, but no lottery and a separate quota that is rarely filled.
- O-1 (extraordinary ability)
For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.
- Green card (EB-2 / EB-3 via PERM)
Filed 361 PERM labor certifications: they have a track record of sponsoring permanent residence.
Salary vs prevailing wage
Level III (experienced)Architects · New Hampshire (state median of areas). Annual prevailing wages set by the Department of Labor (OFLC).
| Level | Prevailing wage | H-1B lottery odds* |
|---|---|---|
| Level I | $80,475 | ~15% |
| Level II | $93,080 | ~31% |
| Level III | $105,664 | ~46% |
| Level IV | $118,269 | ~61% |
This job pays $105,934–$165,526 a year (converted from an hourly rate, 2,080 hours) — that's Level III (experienced). In the wage-weighted H-1B lottery a Level III registration gets 3 entries; estimated selection chance about 46% — better than average.
* Odds are DHS projections for the FY2027 wage-weighted lottery (actual results vary by year and employer). Since the FY2027 cap season the H-1B lottery is weighted by wage level: Level I = 1 entry, II = 2, III = 3, IV = 4. The level is set by the offered wage against the prevailing wage for the occupation and worksite. Separately, a $100,000 fee for new H-1B petitions for workers outside the US was announced in 2025; as of September 2026 a federal court ruling keeps it unenforceable while appeals continue — check the current status.
Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.