Assistant Asset Management Data Analyst

**Job Description**:
**JOB TITLE**:Assistant Asset Management Data Analyst - Co-op

**DEPARTMENT**:Public Works and Engineering

**NUMBER OF POSITIONS**:2

**JOB STATUS & DURATION**:Temporary 4-Months

**HOURS OF WORK**:35 hour workweek

**LOCATION**:Hybrid Model - when working onsite, you will report to the location of West Tower.

**HOURLY RATE**:Year 1: $19.37; Year 2: $20.27; Year 3: $21.89; Year 4: $23.62

**JOB TYPE**:Management and Administration

**POSTING DATE**:October 17, 2024

**CLOSING DATE**: October 30, 2024

**AREA OF RESPONSIBILITY**:
The Facilities Asset Management and Capital Planning team is part of the Facilities Operations and Maintenance department and contributes to the functioning of City facilities by conducting various audits and inspections.

Reporting to the Supervisor, the Co-Op Student will collaborate with other members of the Facilities Asset Management team on one or more projects while taking the lead on gathering, analyzing, and reporting on Asset Condition assessments and other datasets. The student will be responsible for contributing ideas and insights toward the achievement of project and department objectives. Additionally, involvement in developing trends and patterns from the data, interpreting and communicating findings to stakeholders, and participation in overall project execution activities will be required. The placement will provide an opportunity to develop the understanding of Facilities Asset Management, condition assessments on municipal facilities while providing public sector experience. It is an excellent opportunity to work alongside professionals to plan and improve the delivery of programs, Asset management & Engineering and project management skills.

Work with FAMCP team members to analyze, gather and report on various datasets while developing project coordination skills. The following are indicative of the work that will be required:

- Contributing to the development of analytical models techniques to analyze and understand data
- Review Asset Condition assessment reports
- Prepare and update Asset project tracking excel dashboards and maintain various databases
- Managing, cleaning and manipulating data using R, Excel, Access and other tools
- Identifying key themes and insights from the data, discovering patterns and trends
- Preparing maps, tables, reports, charts, and presentations to communicate results and findings
- Assisting with project planning and management, business analysis and requirements gathering
- Research and present solutions for data management and project status tracking
- Research best practices and develop project plan for identified projects to ensure milestones and targets are achieved.

**SELECTION CRITERIA**:

- Student must be enrolled in any University or College Co-Op. Proof of enrollment letter will be requested prior to job offer.
- Interest in Facilities Asset Management & Capital Infrastructure Planning
- Intermediate level skill or better using Microsoft Excel; knowledge of VBA is considered to be an asset (coursework or work experience with Excel VBA)
- Understanding of databases and data management
- Excellent problem solving, analytical, oral and written communication skills
- Demonstrated ability to work both independently and collaboratively with strong attention to detail
- Ability to effectively communicate complex ideas while collaborating and managing multiple projects
- **Preference will be given to students that have a permanent residency in Brampton._
- **_Various tests and/or exams may be administered as part of the selection criteria._

**Interview**:Our recruitment process will be completed with video conference technology.

***

If you would like to request content in an alternate format, please contact the Accessibility office by submitting a new Alternate Format Request.