Advanced Business Analyst - Planning Insights & Analytics

The position

As an Advanced Business Analyst - Planning Insights & Analytics, you will be responsible for executing detailed data analyses to support Production, demand and supply planning, generating actionable insights to drive strategic decision-making, collaborating with cross-functional teams to implement data-driven solutions, and continuously enhancing your analytical capabilities through mentorship and ongoing professional development. Your other responsibilities will be to:

1. Perform comprehensive data analysis and reporting using dashboards to identify trends and patterns that inform and support operational strategies.
2. Manage and refresh operational KPIs and performance metrics regularly to support weekly and monthly insights reporting.
3. Execute data preparation and transformation using tools like Alteryx and SQL, ensuring data accuracy, and supporting data cleansing activities for analysis readiness.
4. Collaborate with development teams to gather requirements, contribute to design and data preparation, and support the implementation of business dashboards that enhance data visualization and streamline reporting for planning teams. Additionally, prepared PowerPoint presentations based on insights derived from dashboard analytics.
5. Support the maintenance and enhancement of dashboards to ensure clear, impactful data visualizations that aid planning functions.
6. Conduct ad-hoc analyses by exploring data sets to deliver clear, actionable insights to stakeholders, while collaborating with team members to address key business questions.
7. Collaborate with the GOP team and other functional areas to address data queries and deliver actionable insights.

Qualifications

To be successful in this role, you should have:

1. Master’s or Bachelor’s degree in Engineering, Pharmacy, or a Supply Chain-related field.
2. 8 - 10 years of total experience, including 3–4 years of relevant experience in supply chain and planning within the pharmaceutical or automotive industry.
3. Must have hands-on experience with tools such as Power BI or Tableau, Alteryx or SQL, and advanced Excel.
4. Must have experience in designing, tracking, and reporting operational KPIs, performing data cleansing, and collaborating cross-functionally to deliver actionable insights.
5. Must have the ability to translate complex datasets into executive-ready business narratives and actionable insights through analytics.
6. Experienced in providing regular verbal and written updates, sharing preliminary findings with stakeholders, and drafting clear communications for routine updates, data requests, and issue escalations, supported by strong communication skills.