Analyst, Operations Business Intelligence (remote)

ICU Medical is a global leader in IV therapy and critical care products. They are seeking an Operations Business Intelligence Analyst to support the development and management of Supply Chain and Manufacturing data, dashboards, and reports to drive key business decisions and improve operational efficiency.

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

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
• Fast Learner: Ability to quickly get up to speed on processes and technologies, and to take ownership of assigned projects and reports
• Professional Ownership: Take on new opportunities and tough challenges with urgency, energy, and enthusiasm
• Organization Skills: Ability to plan, prioritize and multi-task on several workstreams to meet commitments aligned with team and organizational goals in a timely manner
• Attention to Detail: Ensure all work requirements and deliverables are met and output is logical, thorough, and accurate
• 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
• Critical Thinking: Interpret and assess historical, current, and projected data to identify problems, causes, and areas for which procedural or system changes are indicated
• Self-motivated and Proactive: able to bring a solution to bear without having to be asked
• Organizational Agility: Ability to build relationships and work collaboratively with others to meet shared objectives; including various levels of business users and IT. Maneuver comfortably through complex policy, process, & people-related organizational dynamics
• Manage Ambiguity: Operates effectively and proposes approaches or solutions, even when things are not certain or the way forward is not clear. Flexible mentality and change-minded
• Excellent verbal, written and interpersonal communication
• 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
• Solid understanding of manufacturing and supply chain concepts, flows, processes and metrics is 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