Senior Analyst – Forecasting & Analytics

About the job

Strategic context:

As part of GTMC, Insights & Analytics Capabilities delivers best-in-class and transformative insights and innovative tools and methods that actionably fuel Sanofis strategic business decisions, processes and deliverables. In doing so, our Hubs are a crucial part of how we innovate, improving performance across every Sanofi department and providing a springboard for the amazing work we do. Build a career and you can be part of transforming our business while helping to change millions of lives. Ready?

Main Responsibilities :

• At our Sanofi we are leveraging analytics and technology, on behalf of patients around the world. We are seeking those who have a passion for using data, analytics, and insights to drive decision making that will allow us to tackle some of the world’s greatest health threats.
• 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 endeavour, we are seeking a dynamic talent for the role of “Business Analytics Specialist”
• It is essential to have someone who understands and aspires to implement innovative analytics techniques to drive our insights generation across different functions.

• 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, analyse, and prioritize the requirements, write functional specifications, design, and analyse 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.

• Assist in the development and implementation of data-driven projects and initiatives.

• Performance Monitoring:
  • Track and analyze key performance indicators (KPIs) to monitor business performance.
  • Provide regular updates and reports on performance metrics to management.
• Training and Development:
  • Provide training and support to other team members on data analysis techniques and tools.
  • Share best practices and promote data-driven decision-making across the organization.
• Deliver best-in-class and best-in-cost support to key asset team.

About you

• Experience: 4+ 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

Why choose us?

Better is out there. Better medications, better outcomes, better science. But progress doesn’t happen without people – people from different backgrounds, in different locations, doing different roles, all united by one thing: a desire to make miracles happen. So, let’s be those people.

At Sanofi, we provide equal opportunities to all regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, or gender identity.

Watch our ALL IN video and check out our Diversity Equity and Inclusion actions at sanofi.com!