Job Description

Position Summary

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.

Essential Duties & Responsibilities

Data Accessibility

• 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

Report Development

• 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

Process Management

• 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

Other

• 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

Knowledge & Skills

• 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
• Solid understanding of manufacturing and supply chain concepts, flows, processes and metrics is preferred

Minimum Qualifications, Education & Experience

• 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
• 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

Work Environment

• This is largely a sedentary role.
• This job operates in both a professional office environment and routinely uses standard office equipment.
• Typically requires travel less than 5% of the time.

Salary Range - $78,000 - $112,000

The salary range displayed represents the annual base salary we reasonably expect to pay for this role. The actual salary may vary [differ] based upon various factors, including, but not limited to, relevant experience, skills, education, licensure/certifications, and geographic location.

ICU Medical provides a comprehensive total rewards package that includes:

• Competitive financial benefits, including a generous 401(k) match and (for eligible roles) our Annual Incentive Plan
• A wide range of benefit options at affordable rates
• Additional perks to assist employees with their work-life effectiveness, such as Paid Time Off, Company Holidays, and Tuition Reimbursement

Additional information on health and welfare benefit offerings can be found at https://www.icumed.com/about-us/careers/investing-in-your-future/.