Engineer, Technology II

What you'll do

• Design and deploy operational reports, dashboards, and KPI views using Jaspersoft and SQL against Oracle and PostgreSQL databases.
• Act as the Business System Owner by managing system health, configuration, change control, and disaster recovery planning.
• Engineer and support system-to-system integrations with external vendor platforms using API logging and monitoring mechanisms.
• Perform root cause analysis for integration failures by correlating application logs, API responses, and database activity.
• Manage master data quality, including item classifications and mapping, while assessing the impact of changes on downstream systems.
• Identify and implement automation opportunities to improve efficiency within Clinical Supply Management processes.
• Execute system lifecycle activities including technical documentation, user acceptance testing (UAT), and GxP compliance tasks.
• Create training materials and update global standard operating procedures (SOPs) for internal users and stakeholders.

What we're looking for

• Bachelor's degree and at least 5 years of relevant experience, or a Master's degree and at least 4 years of relevant experience.
• Strong SQL development skills for query authoring, tuning, and troubleshooting against Oracle and PostgreSQL databases.
• Hands-on experience developing and deploying reports in Jaspersoft/JasperReports including parameterization and distribution.
• Understanding of relational database design, data models, and data-warehouse concepts to navigate unfamiliar schemas.
• Experience engineering system-to-system integrations involving API/interface concepts, log analysis, and root cause investigation.
• Ability to elicit requirements from business stakeholders and translate them into technical deliverables.
• Demonstrated ownership of a business system including change management, access definition, and vendor coordination.
• Familiarity with clinical supply management systems (IRTs, Signant’s PMD, Loftware’s P360, Master Control’s Mx) and Sensitech SensiWatch. (preferred)
• Experience with scripting or automation in Python for data processing and operational tooling. (preferred)
• Experience preparing training materials, SOPs, or work instructions and delivering system training. (preferred)
• Prior experience in clinical drug development, clinical supply chain, or a GMP regulated environment. (preferred)
• Experience with computer system validation, UAT, change control, and GxP documentation practices. (preferred)