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 assetExtensive knowledge and experience of the Microsoft Office suite (Excel : pivot tables and VLOOKUP, Word, PowerPoint, SharePoint)University degree (or equivalent experience)PMP certification an assetAccounting designation an assetEasily adapts to changing prioritiesGreat attention to detailAn analytical mind and inclination for problem-solvingAbility to identify trends, patterns, and insights from data.Ability to work independently as well as with cross-functional teamsStrong analytical skills with the ability to collect, organize and analyze significant amounts of dataExceptional time management skillsAbility to present complex information in a simplified way to various audiences.Bilingualism is required (French & English)