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.

Responsibilities:

1. 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.
2. 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.
3. 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.
4. Integration issue triage and root cause analysis. Serve as first-line technical investigator for interface and integration failures. Correlate application logs, API responses and database activity to establish root cause, distinguish vendor-side from AbbVie-side faults, and communicate findings directly to external vendor technical contacts and internal stakeholders. Resolve issues of low to moderate complexity independently and escalate appropriately, engaging global IT support and external system providers when required.
5. Master data management. Own the input, administration and quality of master data in CSM systems, including item master classifications, data mappings and the representation of external partners and depots. Assess the downstream impact of master data changes on dependent system functionality, reporting and integrations before implementation.
6. Process optimization and automation. Identify and deliver automation and optimization opportunities that increase efficiency within CSM. Prepare proposals for cross-departmental process improvements, and take new local processes from concept through requirements, testing and implementation together with the relevant business area.
7. System lifecycle, validation and compliance activities. Support system lifecycle activities including documentation, user requirement specifications, UAT execution and approval, system access approvals and coordination of upgrade and change activities with business and IT partners. Evaluate change control and change management impacts for the Clinical Supply Systems group. Produce and maintain the technical documentation associated with delivered work.
8. Training and knowledge transfer. Prepare and maintain training materials for CSM systems and deliver system training to new and existing users. Prepare and update global SOPs and work instructions relating to Clinical Supply Systems. Act as a resource and mentor to others on reporting tools and system data.
9. Business and vendor partnership. Communicate with global users of CSM systems to scope requests, resolve problems and evaluate new processes. Maintain working relationships with external vendors and service providers in accordance with AbbVie Values, Vendor Management Office and Purchasing expectations. Contribute input to project time and cost estimates.
10. New technology evaluation. Evaluate new IT systems and tooling with regard to functionality, data model and integration options with the existing CSM system landscape. Understand and adhere to applicable Corporate and Divisional policies, including code of conduct, safety, GxP compliance, data security and the software development lifecycle.

Required:

• Bachelor's degree in a relevant field and at least 5 years of relevant experience, or Master's degree in a relevant field and at least 4 years of relevant experience.
• Strong, demonstrable SQL development skills, including query authoring, tuning and troubleshooting against relational databases (Oracle and/or PostgreSQL).
• Hands-on experience developing and deploying reports in Jaspersoft / JasperReports, including parameterization, scheduling and distribution.
• Working understanding of relational database design, data models and data-warehouse concepts, and the ability to navigate an unfamiliar schema to locate and validate data.
• Experience supporting or engineering system-to-system integrations, including API/interface concepts, log analysis and structured root cause investigation.
• Ability to work directly with business stakeholders to elicit requirements and translate them into technical deliverables; strong customer orientation and prioritization skills.
• Effective written and verbal communication skills, including communicating technical findings to non-technical stakeholders and to external vendor technical teams.
• Goal-oriented, independent working style with exceptional follow-up skills, and the ability to think and act across multiple functions.
• Demonstrated ownership of a business system or application, including accountability for change management, access and role definition, vendor release coordination and end-user communication.
• Familiarity with clinical supply management systems (IRTs, Signant’s PMD, Loftware’s P360, Master Control’s Mx) and with vendor platforms such as Sensitech SensiWatch.

Preferred:

• Experience with scripting or automation (e.g. Python) for data processing and operational tooling.
• Experience preparing training materials, SOPs or work instructions and delivering system training.
• Prior experience in clinical drug development, clinical supply chain, in a GMP regulated environment.
• Experience with computer system validation, UAT, change control, periodic review, disaster recovery testing and GxP documentation practices.

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state or local law: ​

• The compensation range described below is the range of possible base pay compensation that the Company believes in good faith it will pay for this role at  the time of this posting based on the job grade for this position. Individual compensation paid within this range will depend on many factors  including  geographic location, and we may ultimately  pay more or less than the posted range. This range may be  modified in the future. ​

• We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick), medical/dental/vision insurance and 401(k) to eligible employees.​

• This job is eligible to  participate in our short-term incentive programs.  ​

Note: No amount of pay is  considered to be wages or compensation until such amount is earned,  vested,  and determinable. The amount and availability of  any bonus, commission, incentive, benefits, or any other form of compensation and benefits that are allocable to a   particular employee  remains in the Company's sole and absolute discretion unless and until paid and may be  modified at the Company’s sole and absolute discretion,  consistent with applicable law. ​

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community.  Equal Opportunity Employer/Veterans/Disabled. 

US & Puerto Rico only - to learn more, visit https://www.abbvie.com/join-us/equal-employment-opportunity-employer.html

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

https://www.abbvie.com/join-us/reasonable-accommodations.html