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.
- 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.
- Bilingualism is required (French & English)
