Data Analyst II

Job Title: Data Analyst II Location: Mettawa IL 60045 - Hybrid Required - M/F Remote - T/W/TH Onsite Contract: 1 Year - based on performance and business needs Required Skills Jaspersoft Reporting SQL, PSQL, experience with relational databases Clinical Supplies or Clinical Supply Systems experience AI prompt engineering Bachelors or 5+ years experience Purpose Statement: 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. Responsibilities 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 the 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 for 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 of 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. Qualifications 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. 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 Possesses the ability to think and act with regard to multiple functions with exceptional follow-up skills. Strong skills in customer orientation and prioritization required Goal-oriented and independent way of working Strong communication skills (both written and oral). #J-18808-Ljbffr