Solution Architect – Data Migration / LIMS

Solution Architect – Data Migration / LIMS

Location: New Haven, CT

Onsite Flexibility: Hybrid

Contract Details

• Position Type: Contract
• Contract Duration: 1 month (approximately 20 hours per week) (40 hours/week)
• Pay Rate: $70.00–$88.00 / Hour (USD)
• Shift / Schedule: Days (approximately 20 hours per week during initial assessment phase; ramp-up to approximately 40 hours per week following the initial assessment)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

Our client is seeking an experiencedSolution Architect – Data Migration / LIMS to lead the technical design and execution of a laboratory data migration initiative. The initial engagement will focus on a5-week data assessment and migration planning phase, with approximately20 hours per week expected to start. Strong delivery during this phase is expected to lead to an expanded engagement, with the broader program anticipated to run for at least several months and potentially extend for12–18 months. This role is ideal for a hands-on architect who can both define the migration strategy and work directly with technical teams to execute data profiling, mapping, transformation, validation and reconciliation activities.

Key Responsibilities

• Lead end-to-endLIMS data migration initiatives, from assessment and planning through execution and validation.
• Design and executeETL/ELT pipelines covering data extraction, transformation, mapping, loading and reconciliation.
• Define source-to-target mappings, migration architecture, technical specifications and migration standards.
• Perform data profiling, cleansing, transformation, validation and exception handling.
• Analyze source and target data structures to identify data gaps, quality issues and transformation requirements.
• Lead and support multiple migration cycles, including mock migrations, testing and production readiness.
• Troubleshoot migration issues across ETL, validation and reconciliation cycles and drive issues through resolution.
• Develop or support automation for data transformation, validation and reconciliation activities.
• Partner with business, laboratory and functional teams to translate migration requirements into scalable technical solutions.
• Provide technical leadership and guidance across LIMS, data engineering, integration and migration workstreams.
• Ensure migration outcomes meet agreed quality, completeness and traceability requirements.

Required Skills

• Strong hands-on experience withLIMS platforms, ideally:

- Thermo Fisher SampleManager - LabWare LIMS

• Proven experience delivering complexdata migration and ETL/ELT initiatives.
• Strong experience with:

- Source-to-target mapping - Data transformation - Data validation - Data reconciliation - Data profiling and cleansing - Exception handling

• Experience executing multiple migration cycles, includingmock migrations and production cutover preparation.
• StrongSQL skills and experience working with relational databases such asSQL Server andOracle.
• Experience usingPython or similar scripting languages for data transformation, migration automation or validation.
• Strong understanding of complex data structures and large-scale data migration environments.
• Strong troubleshooting, communication and stakeholder management capabilities.

Preferred Skills

• Strong functional understanding ofR&D and Quality Control laboratory processes.
• Experience supporting LIMS migrations within pharmaceutical, biotechnology, life sciences or other regulated laboratory environments.
• Experience integrating applications and data throughREST APIs, SOAP APIs and file-based interfaces.
• Experience defining migration architecture and technical standards across multiple systems or workstreams.
• Previous experience working directly with business and laboratory stakeholders to translate operational requirements into technical migration solutions.

Required Experience

• 8–10 years of experience insolution architecture, data migration, data engineering or related technical delivery roles.

Work Environment / Physical Requirements

• Work Model: Primarily remote with hybrid on-site requirement.
• On-Site Requirement: Approximately 2 days per week on alternate weeks; flexibility may be available for strong remote candidates.
• Client Location: New Haven, Connecticut.

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.

Job Number: 26-14593Industry: Software Engineering

#LI-Hybrid #LI-GTT