Data Architect

Location: Portsmouth,RI
Duration: 6 Months

Job Overview

We are seeking an experienced Data Conversion Lead / Data Architect to lead end-to-end data conversion and migration activities for large-scale system implementations and transformation programs.

The successful candidate will be responsible for ensuring that data is accurately extracted, transformed, validated, and loaded into target systems while maintaining data integrity, quality, and compliance.

This role requires strong technical expertise in data migration, data modeling, ETL, SQL, and relational databases, combined with excellent stakeholder management and leadership skills.

Key Responsibilities

• Lead and manage the overall data conversion and migration strategy, approach, and execution.

• Analyze source and target data models and establish data mapping and transformation rules.

• Coordinate data extraction, cleansing, validation, reconciliation, and loading activities.

• Work closely with business stakeholders and technical teams to understand data requirements.

• Oversee the development and execution of data conversion scripts, processes, and tools.

• Validate migrated data through reconciliation, balancing, and exception analysis.

• Identify, track, and proactively resolve data quality issues and migration risks.

• Support mock conversions, system testing, UAT, cutover, and go-live activities.

• Ensure data migration activities align with data governance, audit, quality, and compliance standards.

• Prepare project status updates, metrics, documentation, and migration reports for leadership.

Primary Skills

• Data Migration / Data Conversion ,

• Data Architecture,

• Data Modeling,

• ETL Concepts and Processes,

• SQL,

• Relational Database Management Systems (RDBMS),

• Data Mapping and Transformation

• Data Validation and Reconciliation

• Enterprise Data Conversion

• Data Quality and Governance

Secondary Skills

• Data Cleansing,

• Migration Strategy and Planning,

• Conversion Scripts and Tools,

• Mock Conversions,

• System Testing,

• User Acceptance Testing (UAT)

• Cutover and Go-Live Support

• Exception Analysis

• Risk and Issue Management

• Stakeholder Management

• Technical Documentation

• Business and Technical Team Collaboration

Required Qualifications & Experience

• 8–12 years of experience in data migration, data conversion, or related data management roles.

• Strong understanding of data modeling, ETL concepts, and RDBMS.

• Hands-on experience with SQL and database tools.

• Proven experience leading data conversion or migration activities for enterprise-scale systems.

• Strong analytical and problem-solving capabilities.

• Excellent communication and stakeholder management skills.

• Ability to work effectively with business, technical, application, architecture, and vendor teams.