Date Posted: 09/15/2026
Hiring Organization: Rose International
Position Number: 507495
Industry: Government
Job Title: Data Architect Data Migration Lead
Job Location: Remote, USA
Work Model: Remote
Shift: 8am to 5pm
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 10
Min Hourly Rate($): 60.00
Max Hourly Rate($): 70.00
Must Have Skills/Attributes: Data Governance, Data Mapping, Data Migration, SQL Server, Validation
Experience Desired: Large-scale data migration/conversion experience (7 yrs); Enterprise data mapping, validation, reconciliation, and legacy modernization experience (7 yrs); Data governance, data quality, data security, and database experience. (5 yrs); Strong SQL and SQL Server experience. (5 yrs); Experience with ETL/ELT. (5 yrs); Experience developing source-to-target mappings. (5 yrs)
**C2C is not available**
Job Description
Required Skills & Experience
• 5+ years large-scale data migration/conversion experience.
• 5+ years enterprise data mapping, validation, reconciliation, and legacy modernization experience.
• 5+ years data governance, data quality, data security, and database experience.
• Strong SQL and SQL Server experience.
• Experience with ETL/ELT.
• Experience developing source-to-target mappings.
• Experience migrating historical and current operational data.
• Experience with data validation and reconciliation.
• Experience developing migration scripts and validation reports.
• Experience with database architecture and data modeling.
Preferred Qualifications
• Financial-system experience.
• Payment-processing experience.
• State/Federal government experience.
• K-12 education data experience.
• School Finance experience.
• High-volume or mission-critical data migration experience.
• AWS RDS/cloud database experience.
• The SOW specifically requires migration strategy, source-to-target mapping, ETL/ELT, data cleansing, validation, reconciliation, migration scripts, logs, and financial data comparison.
Position Overview
We are seeking an experienced Senior Data Architect / Data Migration Lead to lead data architecture, migration, conversion, validation, and reconciliation activities for the modernization of an enterprise School Finance system.
The successful candidate will design the target data architecture, analyze legacy data, develop source-to-target mappings, oversee ETL/ELT processes, perform data cleansing and validation, and ensure historical and current data is migrated accurately and completely.
Key Responsibilities
• Design the target database schema and data architecture.
• Analyze existing legacy databases and data structures.
• Develop the data migration and conversion strategy.
• Develop detailed source-to-target data mappings.
• Design and implement ETL/ELT processes.
• Develop migration and conversion scripts.
• Perform data profiling and cleansing.
• Validate migrated data for completeness and accuracy.
• Develop reconciliation processes and reports.
• Reconcile financial totals, records, historical data, and calculation results.
• Identify and document migration exceptions.
• Develop migration logs and validation reports.
• Support migration sequencing and cutover planning.
• Develop rollback and contingency strategies.
• Develop and maintain the data dictionary.
• Support data governance, security, and data-quality requirements.
• Support SQL/database optimization.
• Work closely with application development, business analysis, QA, and State personnel. - **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
The interactions that I have had with your representatives have always been prompt and very professional. I am very pleased and impressed with your company and services.
Sioe, Consultant
You are customer service oriented. No matter whether it was the Recruiter or someone in Human Resources/Payroll, you were responsive. That to me is key!
Tonya, Consultant
Rose International maintained good communication during assignments and are very informative through email and phone calls.
Sade, Consultant
Each time I contacted Rose, I was completely satisfied with the great attention and customer service I received. Each person was extremely knowledgeable and patient with my concerns or questions.
Diana, Consultant
Rose International was not only attentive and responsive, but they were very professional and helpful whenever I called or needed any assistance.
Diane, Consultant
EMPLOYEE COMMENTS