Engineer, Technology II

About AbbVie AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas including immunology, oncology and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us at www.abbvie.com . Follow @abbvie on LinkedIn, Facebook , Instagram , X and YouTube.

Technical expert responsible for independently identifying, engineering, and optimizing data, reporting, and integration solutions that address critical business needs within Clinical Supply Management (CSM). Serves as the reporting and systems-data subject matter expert for the Clinical Supply Systems (CSS) group — designing and delivering operational reports, metrics, and dashboards from GxP clinical supply systems, engineering and supporting system-to-system integrations with external vendor platforms, and continuously improving the processes and master data that those systems depend on. Additionally serves as Business System Owner for assigned CSM systems, accountable for their ongoing health, change management, business continuity and end-user support. Continuously seeks to improve existing methods and processes. Demonstrates proficiency across a broad range of information technology engineering techniques, including SQL development, data integration, reporting and data visualization, API-based system integration, and database and data-warehouse concepts.

Reporting, metrics and analytics development. Independently design, develop, test and deploy operational and management reports, dashboards and KPI views against clinical supply systems using Jaspersoft and SQL against Oracle and PostgreSQL data sources. Gather requirements directly from business stakeholders, translate them into report specifications, build parameterized and filterable reports with dynamic titling and drill-down, publish to the reporting server, and own them through user acceptance and ongoing maintenance. Recent representative work includes shipping and transfer metrics summary reporting for the packaging and distribution sites and an integrated kit-utilization report supporting quarterly waste, cost and volume assessment of expired comparator kits. Business System Ownership. Act as Business System Owner for assigned Clinical Supply Management systems, in line with the Clinical Supply Systems Owner role definition. Accountable for the day-to-day health, configuration and supportability of the owned system(s), including: change management and change control; business continuity and disaster recovery planning and testing; interface and integration error handling and monitoring; definition and documentation of business roles and system access; coordination of upgrades, patches and vendor releases with business and IT partners; periodic review and system lifecycle documentation; and end-user communication for outages, releases and process changes. Serves as the primary point of contact between the business user community, global IT and the external system vendor for the owned system(s), and represents the system in cross-functional governance forums. System integration engineering and support. Engineer, test and support integrations between CSM systems and external vendor platforms — including the TRACK / CSS Inventory to Sensitech SensiWatch temperature-monitoring integration and associated Veeva Vault end-to-end flows. Design and implement API logging and monitoring mechanisms to make integration behavior observable; coordinate the required database, network ACL and firewall configuration across Development and Production; and drive end-to-end testing with internal IT and external vendor engineering teams. Integration issue triage and root cause