Financial planning and analysis (FP&A) Analyst

In a changing world, unprecedented challenges require unmatched talent. Join one of Montreal’s Top Employers in 2024. We are a dynamic and growing organization having its main establishment located in downtown Montreal and part of a leading international banking institution fully committed to building a more sustainable future. Note that the position may be in the Canadian Branch of BNP Paribas or in one of its subsidiaries based in Montreal.

The position at a glance

The role, primarily focuses on Management Reporting activities and financial analytics for the CIB activities.

• Produce weekly and monthly management reports; this covers actual production and maintenance considering that the structure evolves frequently to take into account changes in business focus or organization.
• The role also involve a continuous improvement strategy to ensure that data are collected, organized, enriched and reported in a secure way with a full audit trail.
•  Ensure that reports are prepared in full adherence with management accounting principles and data reconciled with Finance systems.
•  Apply knowledge of tools and the business in order to identify process improvements and implement reporting changes. Design and Process improvement expertise are critical as the Canada position is envisioned as a reporting center of excellence with the skills to streamline and automate report production and other financial tasks.
• The role also requires a solid understanding of Digital solutions to contribute to the transformation of the Finance delivery model.
• Support on an ad hoc basis other Performance Management activities (maintenance, support to forecast/budget exercise, review of financial indicators, etc.)
• Assist the manager for the staff coordination and supervise the daily operations of team located in Montreal as well as the team located in BNP Paribas Shared service center located in ISPL (India).

In detail

Projects, systems support, operational process improvements:

• Participate in the upgrades/version releases of respective reporting tools, as well as system amendments/enhancements required to facilitate new/modified reporting requirements. In connection with this effort, assist in user acceptance testing and after care post deployment.
• Assist in identifying operational process improvements in production, control procedures, and workflow organization to increase the team’s efficiency and effectiveness. Also, assist in integrating and streamlining the reports under the team’s responsibility.

Day to day production:
• Ensure delivery of all financial data/reporting in a timely manner from the team members
• Ensure the control and the integrity of the data throughout the reporting production
• Ensure that the reports are in accordance with the quality and granularity defined.
• Ensure that the quality controls are defined and properly designed.
• Perform sanity checks on reports published on a monthly basis.
• Maintain and share Productivity KPI to our stakeholders for both teams under direct Management and the extended team located in ISPL

BI/Project:
• Enhance and automate all the production reports and ensure that relevant documentation is up-to date and published on a yearly basis
• Identify opportunities for optimization of current process including:
                • Automatization of process/controls using Alteryx/SQL/Python and/ou PowerQuery
                • Visualization/Creation of Digital reports using PowerBI/Tableau
• Propose significant improvements not limited to the scope of SFM to the Management and lead the initiatives

Support the Client Services teams (CST) located in New York :
•  have a close link and communication channel with the CST and the head of the SFM team in order to gather necessary information on business evolution
• keep them informed of any potential delay/risk that could impact agreed production timeline or figures
• perform ad-hoc reporting when requested by the Head of CST.
• in partnership with other teams, contribute to the enhancement of the platform tools as well as the automation and standardization of the tools & reports.
• perform a yearly review of all the set of reporting to ensure that they remain key for management.

Other tasks:
• contribute to any project that has an impact on the reporting (sourcing, mapping, systems evolutions…)
• observe the bank policies and procedure
• ensure continuity of service in respect of staffing, training, leavers or exceptional events
• assist in any special project or request as directed by Management

The strengths and skills that will help you succeed

•  Financial and performance analysis: Degree in Performance Management and Finance from a reputable university.
•  Between 5 to 8 years of Financial Reporting or Performance Management, preferably within Financial Services Industries.
• Ability to develop and adapt a process: Ablility to manage multiple projects, and effectively prioritize workload when dealing with multiple deadlines. Team management experience and experience in project management supervision and coordination
• Digital tools: Excellent IT skills, including experience with data processing tools such as Alteryx or SQL, and creating reports using Business Intelligence tools (SQL, Server Analysis, Tableau or Power BI) as well as Excel skills including pivot tables, power query, advanced Excel functions & macros. Knowledge in Sharepoint (Lists) and other scripting technology would be appreciated (Powershell, Python, Vba) and/or in processes to collect information (mostly via Forms in tools to be defined)
• Ability to deliver/Result driven: Self-starter and team player, able to work independently and collaboratively with various teams in a deadline-focused environment.
•  Excellent communication skill
• Accounting: Knowledge of USGAAP and IFRS is a plus
• Given the vast majority of our clients, both internal and external, are based outside of Quebec and Canada, specific language requirements may apply. Knowledge of the English is required.