IT Business Analyst III

Responsibilities

• Lead end-to-end data migration of research, clinical, and biospecimen data from legacy systems into enterprise specimen management platforms, ensuring accurate data conversion, standardization, and integrity.
• Design, develop, and optimize SQL Server migration solutions, including reusable parsing logic, data integration workflows, transformation processes, validation scripts, and migration utilities to support efficient, high-quality data migration.
• Support clinical data efforts by assisting clinical staff with the standardization of queries and the use of appropriate coding methods to efficiently access and retrieve data from available databases.
• Perform data profiling, cleansing, mapping, reconciliation, and pre-/post-migration validation to identify and resolve data quality issues, including duplicate records, missing data, mapping discrepancies, and integrity violations.
• Develop Python automation and API integrations to streamline business processes, improve regulatory compliance, and reduce manual effort.
• Troubleshoot and resolve complex production issues involving SQL Server databases, application integrations, migrated data, and enterprise specimen management systems.
• Collaborate with business stakeholders, research teams, IT staff, and vendors to integrate third-party tools with the enterprise system.
• Participate in the design, development, testing, implementation, configuration, maintenance, and documentation of application enhancements, system upgrades, reports, interfaces, and business processes.
• Manage technical Help Desk tickets received that are related to supporting the application, including support during system outages.
• Contribute to project planning by providing effort estimates, managing issue resolution, administering application security, and following established change management and application support procedures.

Qualifications

• Bachelor’s Degree in Information Technology, Computer Science, or other related field.
• Minimum 7 years of IT business analysis experience managing Enterprise applications.
• Experience with application development lifecycle methodology as well as IT analysis mythologies such as process flow definition, data flow diagramming etc.
• Preferred: Experience with specimen management, laboratory information management systems (LIMS), biobanking, or clinical research platforms.
• Experience migrating research, clinical, laboratory, or biospecimen data between enterprise applications.
• Proficiency in Python for automation, scripting, and REST API integration.
• Familiarity with healthcare or clinical research data standards and regulatory requirements.
• Excellent written and verbal communication skills with experience collaborating across business, research, and technical teams.
• Ability to manage multiple priorities while delivering high-quality solutions within project timelines.
• Experience creating technical documentation, conducting User Acceptance Testing (UAT), and providing end-user training and knowledge transfer.
• Excellent organizational and communication skills.