Senior Analyst - Forecasting & Analytics - Pharma

- Within our commercial Insights, Analytics, and Data organization we are transforming to better power decision-making across our end-to-end commercialization process, from business development to late lifecycle management.

- Forecasting and analytics deliverables support planning and decision making across multiple functional areas such as finance, manufacturing, product development and commercial.

- In addition to ensuring high-quality deliverables, our team drives synergies across the franchise, fosters innovation and best practices, and creates solutions to bring speed, scale and shareability to our planning processes. As we endeavor, we are seeking a dynamic talent for the role of "Senior Analyst - Forecasting & Analytics."

It is essential to have someone who understands and aspires to implement innovative analytics techniques to drive our insights generation across different functions.

People:

- Maintain effective relationship with the stakeholders (Country & Cross border Teams) within or cross GBUs and tasks - with an end objective to develop educational and communication content as per requirement.

- Actively lead and develop SGH operations associates and ensure innovative technologies are leveraged.

- Initiate the contracting process and related documents within defined timelines; and

- Collaborate with global stakeholders for project planning and setting up the timelines and maintaining budget.

Performance:

- Support forecasting activities (pre and post forecasting), including updating TM1 PAFE (excel based) models, testing data push to TM1.

- Creating complex TM1 Planning analytics reports - Quick, Dynamic, and customized. Test and validate report working in TM1 web.

- Largely working on creating/updating TM1/Planning analytics views, using MDX to create subsets for views, working with Production support to create ad hoc Turbo integrator processes, Writing business rules.

- Define and evaluate reporting and analytics needs at the individual country level or market level while enhancing solutions.

- Design TM1 dimensions, attributes, aliases, cubes for new markets/products additions and ready to launch products thus evolving the existing TM1 application.

- Oversee monthly actuals load process, validate the data.

- Work with production team to deploy solutions.

- Integrate new data sources with TM1.

- Streamline and optimize forecasting collection and submission process.

- Refresh Existing Reports and identifies improvement opportunities in reporting and BI tools and as needed structure / functionality with the latest insights as they become available.

- Collaborate with Digital teams to enhance data access across various sources, develop tools, technology, and process to constantly improve quality and productivity.

- Create robust forecast models and dashboards taking into consideration key data, insights, trends, and assumptions around patient flow, market dynamics, competitive landscape, payer mix, supply chain inventory fluctuation, etc.

- Evaluate and maintain existing forecast models; identify and prioritize areas for improvement to iteratively improve function over time.

- Refresh forecast model assumptions and as needed structure / functionality with the latest insights as they become available.

Process:

- Identify and interpret business needs, analyze, and prioritize the requirements, write functional specifications, design, and analyze data, identify gaps, and provide business requirements and expectations feedback.

- Support delivery of projects in terms of resourcing, coordination, quality, timeliness, efficiency, and high technical standards for deliveries made by the business teams.

- Secure adherence to compliance procedures and internal/operational risk controls in accordance with all applicable standards

- Refresh report on frequency/cycle basis (weekly/monthly/quarterly/annually), along with QC checks for each refresh

- Use latest tools/technologies/methodologies and partner with internal teams to provide support on all sort of regular and ad hoc business analytics activities like build, maintenance, and enhancements of such systems.

- Ability to work cross-functionally, gather requirements, analyse data, and generate insights and reports that can be used by the GBU.

- Support delivery of projects in terms of resourcing, coordination, quality, timeliness, efficiency, and high technical standards for deliveries made by the business teams.

Stakeholder:

- Work closely with global teams and/ external vendors to ensure the end-to-end effective project delivery of the designated deliverables.

About you

Experience: 5+ years of experience in pharmaceutical product commercial forecasting and analytics. In-depth knowledge of common databases like IQVIA, APLD, Engagement and execution data.

Soft skills: Strong learning agility; Ability to manage ambiguous environments, and to adapt to changing needs of the business; Good interpersonal and communication skills; strong presentation skills a must; Team player who is curious, dynamic, result oriented and can work collaboratively; Ability to think strategically in an ambiguous environment; Ability to operate effectively in an international matrix environment, with ability to work across time zones; Demonstrated leadership and management in driving innovation and automation leveraging advanced statistical and analytical techniques; High ethical standards and integrity

Technical skills:

- Expert knowledge of Cognos TM1 or IBM planning analytics, PAFE, TM1

- Expert knowledge of Microsoft Excel/Access/Power BI/VBA/SQL

- Experience with analytical programming (e.g., SQL, R, Python), experience with Snowflake preferred.

- Experience of developing and managing dashboards

- Experience with pharmaceutical data and business terms

- Expert knowledge of Microsoft Suites - Word PowerPoint and SharePoint

- Experience of using analytical tools like Power BI, Qliksense, Tableau, Smartsheet, and Alteryx etc.

- Project management abilities; capable of prioritizing and managing multiple projects simultaneously.

- Autonomous, proactive, and strong interpersonal skills

- An aptitude for problem solving and strategic thinking.

- Ability to synthesize complex information into clear and actionable insights.

- Solid understanding of pharmaceutical development, manufacturing, supply chain and marketing functions

- Demonstrated leadership and management in driving innovation and automation leveraging advanced statistical and analytical techniques.

- Hard working, driven, results-oriented and focused on success.

Education: Advanced degree in areas such as Management/Statistics/Decision Sciences/Engineering/Life Sciences/ Business Analytics or related field (e.g., PhD / MBA / Masters)

Languages: Excellent knowledge in English and strong communication skills - written and spoken