As a member of the Civil PMO team, the main responsibility of the Business Analyst is to define a business intelligence (BI) strategy supporting the evolution of high technology and to manage data analysis and the various KPIs and governance reports for the management of the SPC and PMO Civil program.
He is in direct contact with senior management and collaborates with various functions of the organization, including : Project and Product Management, Finance, Sales, Engineering, Quality Assurance and IT.
Main files
Project and Product cost analysis
Performance analysis
Report estimated expenses per month Cost reductions for execution operations
Financial forecast
PRC analysis
Invoicing
Financial summary sheet
Manloading
S&OP
Ad-analysis hoc to support the needs of the business
In addition, the Business Analyst will
Support the development of tools to visualize and monitor business performance.
Review and analyze processes, tools, and performance metrics to identify areas for improvement.
Support the maintenance of project databases and ensure data integrity.
Requirements
Extensive knowledge and experience with tools such as Microsoft Office, Power BI (M, DAX, Model and Service).
Knowledge of relational databases and SQL programming.
Excellent analytical skills.
Experience with data, code, scripting (Python / Java / SQL) and using Microsoft cloud services : Azure, Databrick, etc., an asset
Extensive knowledge and experience of the Microsoft Office suite (Excel : pivot tables and VLOOKUP, Word, PowerPoint, SharePoint)
University degree (or equivalent experience)
PMP certification an asset
Accounting designation an asset
Easily adapts to changing priorities
Great attention to detail
An analytical mind and inclination for problem-solving
Ability to identify trends, patterns, and insights from data.
Ability to work independently as well as with cross-functional teams
Strong analytical skills with the ability to collect, organize and analyze significant amounts of data
Exceptional time management skills
Ability to present complex information in a simplified way to various audiences.