Supply Chain Data Analyst; SmartSupplies, Jaspersoft

HYBRID North Chicago IL
- Hybrid Required - M/F Remote - T/W/TH Onsite - Non-Negotiable

Pay: $45-$49/hr

REQUIRED:

Bachelor's Degree or equivalent education with typically 5 years of experience, or Master's Degree or equivalent education with typically 2 years of experience.

Jasper Soft Reporting

SQL, PSQL, experience with relational databases

Clinical Supplies or Clinical Supply Systems experience

Oracle SQL

Smart Supplies preferred / not required
-SAP would be a good substitute

Prior experience in clinical drug development or GMP/GCP area preferred

Experience in working with IT systems and an affinity for Work with IT systems necessary

Understanding of database setup and usage as well as SQL knowledge

Understanding of Jaspersoft or similar Reporting Tools

Job Description:

Responsible for day-to-day systems activities, like training and Master Data Management. Resolves system questions and interface issues of limited complexity. Works on automation and optimization requests to increase efficiency within CSM.

Day to Day:

• This person is the first POC for end users who are having an issue for their "Smart Supplies" system, they will also create reports generate KPI's, will take meeting minutes, updating SOP's, end user training
• Preparation and maintenance of training materials for CSM IT systems and conducting system training for new employees relating to CSM IT systems.
• Responsible for reflecting process of external partners in CSM IT systems, independent input and administration of master data management into the CSM IT system, as per requests and information from various source systems. When entering and managing some master data, such as Item Master Classifications and Data Mappings, the influence on all relevant system functionalities must be considered.
• Processing primarily local inquiries about the functionality of CSM IT systems, solving complex problems that arise when using the systems and Independent resolution of low-complexity errors that occur with interface systems. Involving global IT support and external system providers.
• Preparation of proposals to optimize cross-departmental work processes to improve efficiency and cost structure with support from the Program Manager Clinical Supplies Systems. Preparation and implementation of IT interfaces to CSM IT systems with support from the Program Manager Clinical Supplies Systems.
• Research and collection of statistics and KPIS, as well as implementation of ad hoc views, dashboards, unvalidated reports under supervision by the Program Manager Clinical Supplies Systems and external consultants. Development of new local processes and process optimizations with the respective specialist area, from idea to testing to implementation with the support of supervisors.
• Supports system lifecycle activities, documentation, UAT approvals, system access approvals and coordination of upgrade and system change activities with respective business and IT partners. These activities are strongly supported by the respective manager. Evaluation of new IT systems, taking into account system functionalities, as well as integration options with existing systems.
• Definition of new local processes within CSM from the perspective of system functionalities, as well as when writing user requirement specifications.
• Preparation and update of global SOPs, work instructions and training materials in the area of clinical supply management in relation to IT systems of the
• Evaluates change control/change management processes and coordinates the activities required by the Clinical Supplies Systems Group locally.
• Communication with global users of CSM IT systems, to discuss specific inquiries and problem solutions, as well as when evaluating new processes.