Solution Architect – Data Migration / LIMS

Location: New Haven, CT

Onsite Flexibility: Hybrid

• Position Type: Contract
• Contract Duration: 1 month
• Pay Rate: $70.00–$88.00 / Hour (USD)
• Shift / Schedule: Days
• Hours Per Week: Approximately 20 hours per week (initial assessment phase); opportunity to increase to approximately 40 hours per week following the initial assessment phase
• Travel Requirements: Approximately 2 days per week on alternate weeks on-site; flexibility may be available for strong remote candidates
• 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.

Our client is seeking an experienced Solution Architect – Data Migration / LIMS to lead the technical design and execution of a laboratory data migration initiative. The initial engagement will focus on a 5-week data assessment and migration planning phase, with approximately 20 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 for 12–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.

• Lead end-to-end LIMS data migration initiatives, from assessment and planning through execution and validation.
• Design and execute ETL/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.

• 8–10 years of experience in solution architecture, data migration, data engineering or related technical delivery roles.
• Proven experience delivering complex data migration and ETL/ELT initiatives.
• Experience executing multiple migration cycles, including mock migrations and production cutover preparation.
• Strong SQL skills and experience working with relational databases such as SQL Server and Oracle.
• Experience using Python or similar scripting languages for data transformation, migration automation or validation.
• Strong understanding of complex data structures and large-scale data migration environments.

• Strong functional understanding of R&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 through REST 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.

• Strong hands-on experience with LIMS platforms, ideally:

- Thermo Fisher SampleManager - LabWare LIMS

• Strong experience with:

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

• Strong troubleshooting, communication and stakeholder management capabilities.

• LIMS: Thermo Fisher SampleManager, LabWare LIMS
• Data Engineering: ETL/ELT frameworks, SQL, Python, migration pipelines, data profiling and cleansing
• Databases: SQL Server, Oracle
• Integration: REST APIs, SOAP APIs, file-based integrations

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

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-14593 Industry: Software Engineering