Business Analyst, Equipment

AECON; Calgary; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading construction and engineering firm in Calgary is seeking an experienced Equipment Business Analyst to prepare and analyze reports, conduct profit and loss analyses, and assist with special projects. The ideal candidate will possess SAP and Microsoft Office skills, particularly in Excel, and have strong attention to detail and problem-solving abilities. This is an opportunity to work in a dynamic environment with a focus on equipment utilization and data analysis.

Qualifications

• Experience with data mining and manipulation.
• Strong organizational and time management skills.
• Ability to work independently and in a team.

Responsibilities

• Prepare and analyze various weekly and monthly reports.
• Conduct profit and loss analysis monthly.
• Develop project-specific utilization reports.

Skills

SAP / Business Objects experience

Microsoft Office proficiency

Attention to detail

Critical reasoning ability

Data mining experience

Goal achievement orientation

Technical background

Excellent communication skills

Problem-solving skills

Organizational skills

Tools

Excel

PowerPoint

Job description

Overview

What is the Opportunity? Reporting to the Equipment Director, the Equipment Business Analyst is responsible for preparing and analyzing various weekly and monthly reports, performing analysis on data, and working on a variety of special projects for the Equipment team.

What You'll Do Here

• Equipment and Vehicle Utilization Analysis. Reported Hours vs. GPS variance analysis.
• Creation & distribution of Utilization reports to Management, Operations & Safety.
• Liaison between Operations & Equipment team regarding utilization.
• Develop project specific utilization reports for all sectors in Aecon.
• Profit & Loss Analysis. Conduct Actual vs. Budget Analysis monthly.
• Prepare annual rate analysis and participate in rate setting.
• Fuel Consumption Analysis and Reporting (On highway and off road).
• Telematics Analysis & Development. Develop reporting and dashboard on idling, speeding violations, and driving behaviour. Mileage reporting and analysis.
• Lead relevant training and roll-out of new initiatives.
• Technology Investigation & Development. Investigate groundbreaking technology as it relates to vehicles and equipment.
• Create & Generate various Reports. Prepare Capital Budget Master Files.
• Prepare and maintain equipment rental reconciliations.
• Special Projects – support acquisitions and integrations as needed.
• Work with Equipment Director and Business Unit leads to define equipment policies and procedures.
• Update and maintain Aecon Equipment Manual as it relates to the relevant sections for this role.

What You Bring to the Team

• SAP / Business Objects experience is a requirement.
• Microsoft Office proficient – with advanced Excel, PowerPoint.
• High attention to detail.
• Demonstrated critical reasoning ability.
• Data mining / collection and manipulation experience.
• Demonstrate high goal achievement orientation.
• Technical background.
• Excellent communication skills, both written and oral, and the confidence and ability to work with all levels of staff and management within a large organization.
• Ability to work in a team environment as well as individually.
• Strong problem-solving skills.
• Strong organizational and time management skills with an ability to multi-task.
• Ability to adhere to project schedules and meet deadlines.