Business Analyst II

Description:

Provide meaningful and timely financial performance reports to management. Complete analyses including financial analyses to support new business opportunities and product operational issues. Provide financial performance reporting including monthly management letters, trends, and analytical reports for management. Conduct monthly financial reviews with product line or functional managers and assists line managers in developing operational budgets. Develop quarterly profit and loss forecasts for assigned areas. Assist in conducting economic evaluation of new product opportunities. Work under only very general supervision. Work is reviewed for soundness of judgment and overall adequacy and accuracy. Contribute to the completion of organizational projects and goals. Errors in judgment or failure to achieve results would normally require a moderate expenditure of resources to rectify. Frequent internal company and external contacts. Represent organization on specific projects .Years of Experience: 3 – 6 Years

Department Description:

Working within the Project and Portfolio Management Office the candidate will have the opportunity to function creatively enhancing existing PPMO tools and / or developing and implementing new ideas to support Site and Global monthly project and portfolio reporting. This includes portfolio health and performance monitoring, with a focus on project financials and resource analysis for data modeling and trending. The candidate will work with the Global Sanofi network and functional teams across the site, acquiring knowledge of strategic investment projects and the vaccine industry.

The incumbent must be comfortable collecting data, flagging errors / actions to update / clean project information; perform complex analysis in order to present clear and concise “call-to-action” insights for month end and projected yearly summaries to multiple levels of management. Ability to link strategies, project initiatives and understanding the “big picture” impact to the overall site portfolio budget performance is required to excel in this role. Strong interpersonal and facilitation skills to obtain critical information for data synthesis and present findings for actionable next steps is critical for success.

Responsibilities:

Collect, analyze and synthesize data with supporting insightful key messages that speak to the health and performance of the site’s project portfolio; calling out actions needed for improvement and root causes for variances from baselines; this also includes using data visualization to identify themes, trends, historical correlations to support discussions.

Include baseline data to monitor and track key performance indicators (KPIs) analyzing opportunities and providing suggestions to improve performance.

Leverage Global (SHINE, PowerBI) and /or develop site reporting tools (i.e. excel, dashboards, project management templates, process flows, etc.) for monthly and multi-year project portfolio data consolidation and analysis; enhancing tools as needed for efficiency and evolution in reporting.

Understand and align reporting with financial budget targets, financial reforecasts and ongoing project controls and portfolio prioritization.

Support Project and Portfolio Managers across the organization maintaining and enhancing existing project and portfolio management tools used to monitor, track and report on project and portfolio cost, schedule and resource metrics on a regular basis.

Key support to the Toronto Site Resource Management Officer (RMO):

Collaborate with Site RMO and Functional RMOs to support consistency and accuracy of the resource data.

Develop, maintain and generate reports to monitor Demand vs capacity, analyze and propose resolution to Demand vs Capacity gaps.

Develop simplified tools to highlight gaps in demand, capacity and actuals (time tracking) on a monthly basis. Support adherence to time tracking principles/best practices.

Updating RMO monthly health and performance visualization data, calling out actions needed for improvement and root causes for variances from baselines.

Work in collaboration with site SHINE admin to Perform Data Quality Checks (DQC) on resources within SHINE. Ensuring proper Employee Id #'s, Cost accounts, Resource Platforms etc.

Participate in site and Global Portfolio, RMO and SHINE admin meetings including applicable training.

Basic qualifications:

Undergraduate or Master's degree in Engineering, Finance or Business
Proficient in use of MS Office (Excel, Outlook, PowerPoint, Word and SharePoint)
Must be legally entitled to work in Canada
Minimum 1-3 year industry experience

Preferred Technical Competencies and Soft Skills:

Experience with Planisware, Smartsheet and data visualization tools such as Power BI, QlikView, Business Object and/or Tableau
Experience with data analysis and reporting, managing dashboards and performance metrics
Ability to interpret and present project data and concepts to non-project management audiences
Ability to analyze high volume of data and build scenarios
Advanced experience of digital tools and technologies
Able to work independently and collaboratively bringing ideas forward in a positive and constructive manner
Strong organizational, time management and problem-solving skills with ability to multitask effectively
Attention to detail and analytical skills (data analysis, synthesis and performance reporting)
Applied creativity and continuous improvement mindset
Transversal management working experience
Strong written, verbal and interpersonal communication skills