Analyst, Operations Business Intelligence (remote)

ICU Medical • United States,

2h • Remote

About The Position

As part of the Operations Business Intelligence team, the Operations Business Intelligence Analyst supports the entirety of ICU Medical by developing and managing Supply Chain and Manufacturing data, dashboards and reports used to conduct analyses and assessments across all functions of the business. This position plays a critical role in developing, maintaining and publishing standardized reporting, and by ensuring the accuracy of data and metrics used to drive key business decisions. This will predominantly involve working with all areas of Supply Chain, Manufacturing, and the IT Business Intelligence team to obtain requirements and conduct validation studies. The on-demand dashboards and recuring reporting publications created and maintained by this team are used by various teams and all levels of the organization, from warehouse staff/demand planners through the executive leadership team, to improve operational efficiency, decrease costs, and improve customer satisfaction. This role reports to the Senior Manager, Operations Business Intelligence and will be part of the Operations Strategy group.

Requirements

• Must be at least 18 years of age
• Bachelor’s degree in Business Administration or a quantitative field (e.g., Information Systems, Economics, Supply Chain, Data Science/Analytics, etc.), or similar educational background required with 1‒3 years of work experience analyzing data
• Proficiency in Microsoft Office, including Word, Outlook, SharePoint, and especially Excel, is required
• Knowledge of data modeling: practical understanding of how to design a data model (fact and dimension tables), build relationships, add filters, consolidate and/or group queries. Ability to logically think across reports to utilize available solutions and to optimize the reporting process.
• Excellent verbal, written and interpersonal communication

Nice To Haves

• Coding experience (e.g., SQL, DAX, C++, Python, etc.) is highly preferred
• Experience in an analyst role working in a business intelligence environment, managing and reporting on large amounts of data is highly preferred
• Familiarity with and experience in system rollouts, developing and implementing enterprise-scale reports and dashboards, Data Warehouse Design and Dimensional Modeling is highly desirable
• Experience with major ERP systems (especially Oracle) as it relates to reporting and business intelligence is a definite plus
• Experience setting up, performing, and maintaining analyses and reporting using any/all of the following technologies is preferred but not required: Power BI, Oracle OBIEE, Power Query, PowerPivot, Power Automate, and Alteryx
• Solid understanding of manufacturing and supply chain concepts, flows, processes and metrics is preferred

Responsibilities

• Participate in requirements gathering sessions with key stakeholders to understand reporting needs and available data sources in the various areas of Supply Chain (includes Logistics, Customer Care, Planning, Procurement, etc.) and Manufacturing
• Work with IT to migrate desired data into OBIEE data marts and/or Power BI workspaces
• Facilitate user acceptance testing for OBIEE/Power BI data migration initiatives, dashboards and reports
• Assist in ensuring data integrity across OBIEE, Power BI, and Excel-based reporting outputs
• Translate business requirements into specifications that will be used to develop required OBIEE/Power BI reports/dashboards and mailers, created from disparate data sources
• Develop and manage multiple OBIEE, Power BI and Excel reports/dashboards using data from disparate data sources
• Build and design layouts and visualizations to synthesize analytics into easy-to-understand value-driving opportunities
• Build and maintain supply chain dashboards (including inventory, logistics, demand planning, supply planning) that consolidates KPI progress and analysis reporting in OBIEE/Power BI
• Administer repeated manual reporting tasks on cadence, without supervision, and with attention to quality, accuracy and timeliness
• Automate repetitive offline reporting tasks as much as possible to streamline generation and delivery
• Document processes and cross-train other team members on administering and maintaining both manual and automated reporting
• Provide technical assistance and training to Operations end-users, including participating in recurring OBIEE/Power BI training programs and user-focused documentation development
• Troubleshoot and perform root cause analysis on user report issues
• Work on special projects, as needed

Benefits

• ICU Medical has consistently provided you with clinical innovations that help solve real-world challenges.
• With the acquisition of Hospira Infusion Systems in 2017 and Smiths Medical in 2022, we are now a global market leader with a complete line of clinically-essential IV therapy and high-value critical care products for hospital, alternate site, and home care settings.
• We're ready to bring you consistent quality, innovation, and value in more areas than ever. Our focus allows us to bring you:
• Dedicated and non-dedicated IV sets and needlefree connectors clinically proven to provide an effective barrier against bacterial transfer and colonization.
• The industry’s broadest IV smart pump offering covering large volume, pain management, and ambulatory needs.
• IV medication safety software providing full IV-EHR interoperability with the highest customer satisfaction and compatibility with more EHR systems than any other company.
• Significant US IV solutions manufacturing and supply capabilities.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level