88-50100306 Senior Business Intelligence Analyst

Roche • Indianapolis, IN

13d • Hybrid

About The Position

At Roche, we foster a culture where you can show up as yourself, embraced for your unique qualities. Our culture encourages personal expression, open dialogue, and genuine connections, where you are valued, accepted, and respected for who you are, allowing you to thrive both personally and professionally. This is how we aim to prevent, stop, and cure diseases and ensure everyone has access to healthcare today and for generations to come. Join Roche, where every voice matters. The Position Roche Diagnostics Operations, Inc. seeks a Senior Business Intelligence Analyst at its Indianapolis, IN location. Duties: Within a global medical diagnostics organization, lead the development and enhancement of business intelligence solutions by converting proof-of-concept analytical models into scalable, reliable, and user-friendly tools for broader organizational use. Perform data analysis and develop comprehensive reports/dashboards that present actionable insights to support strategic and operational decision-making for supply chain management. Gather data from various supply chain sources and utilize advanced analytics techniques, including data mining, machine learning, and predictive modeling to identify patterns, trends, and correlations. Create reports highlighting key performance indicators (KPIs), trends, and insights for supply chain optimization. Write and optimize complex Structured Query Language (SQL) queries to extract, manipulate, and analyze large-scale datasets, including advanced join/nested queries, and conduct performance tuning for efficient data retrieval. Create and maintain database objects, including tables, views, and data models within cloud or relational database environments based on stakeholder requirements. Translate business logic and requirements defined by management into structured technical specifications for information systems solutions and data-driven outputs while aligning stakeholders’ interests. Develop and implement interactive dashboards and data visualizations using Tableau to enable business users to monitor critical business areas and lead the development/enhancement of internal business intelligence solutions by converting proof-of-concepts into tangible tools. Use platforms such as Alteryx to gather, consolidate, and transform data from multiple enterprise systems, including SAP/WMS/text files/unstructured sources to create automated, unified, and reliable data workflows. Perform process optimization and automation and conduct performance monitoring and KPI tracking. May telecommute up to 2 days per week.

Requirements

• Requires a Master of Business Administration degree with concentrated coursework in applied data analytics
• 2 years of experience as business analyst, data analyst or closely related position supporting supply chain analytics.
• Experience must include Structured Query Language (SQL) for data extraction and transformation
• Experience must include Data extraction, transformation, and loading (ETL) process development
• Experience must include Designing, implementing, and monitoring Key Performance Indicators for supply chain operations, sales, marketing and engineering.
• Experience must include Supply chain analysis and reporting, including analyzing large-scale datasets for inventory levels, order fulfillment, transportation and sales performance.
• Experience must include Building predictive and time-series forecasting models
• Experience must include Effectively communicating complex data to Executive stakeholders and translating requirements into actionable tasks.

Responsibilities

• Lead development and enhancement of business intelligence solutions by converting proof-of-concept analytical models into scalable, reliable, and user-friendly tools for broader organizational use.
• Perform data analysis and develop comprehensive reports/dashboards that present actionable insights to support strategic and operational decision-making for supply chain management.
• Gather data from various supply chain sources and utilize advanced analytics techniques, including data mining, machine learning and predictive modeling to identify patterns, trends and correlations.
• Create reports highlighting key performance indicators (KPIs), trends, and insights for supply chain optimization.
• Write and optimize complex Structured Query Language (SQL) queries to extract, manipulate and analyze large-scale datasets, including advanced join/nested queries, and conduct performance tuning for efficient data retrieval.
• Create and maintain database objects, including tables, views, and data models within cloud of relational database environments based on stakeholder requirements.
• Translate business logic and requirements defined by management into structured technical specifications for information systems solutions and data-driven outputs while aligning stakeholders’ interests.
• Develop and implement interactive dashboards and data visualizations using Tableau to enable business users to monitor critical business areas and lead the development/enhancement of internal business intelligence solutions by converting proof-of-concepts into tangible tools.
• Use platforms such as Alteryx to gather, consolidate and transform data from multiple enterprise systems, including SAP/WMS/text files/unstructured sources to create automated, unified and reliable data workflow.
• Perform process optimization and automation and conduct performance monitoring and KPI tracking.

Benefits

• A discretionary annual bonus may be available based on individual and Company performance.
• Benefits detailed at the link provided below. Benefits (https://roche.ehr.com/default.ashx?CLASSNAME=splash )

What This Job Offers

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