City of Brampton
Assistant Asset Management Data Analyst – Co-op
Job Description
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: $18.27; Year 2: $19.49; Year 3: $21.05; Year 4: $22.71
JOB TYPE: Management and Administration
POSTING DATE: October 17, 2023
CLOSING DATE: November 07, 2023
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 this opportunity matches your interest and experience, please apply online by clicking the button above by March 08, 2024 and complete the attached questionnaire. We thank all applicants; however, only those selected for an interview will be contacted. The successful candidate(s) will be required, as a condition of employment, to execute a written employment agreement. A criminal record search will be required of the successful candidate to verify the absence of a criminal record for which a pardon has not been granted.
As part of the application process, applicants will be invited to complete a self identification survey. The survey is voluntary. Participation in the survey will have no impact on hiring decisions. Should you wish to opt out of completing the survey, please select “prefer not to answer” as a response to each question. All information collected is confidential and will not be shared with the hiring manager. The surveys will be anonymized and will be kept separate from applicant or employee files, such that the individuals who completed the surveys will not be identifiable. The results of the survey will assist in the analysis of disaggregated metrics for organizational planning purposes and our commitment to advance and foster diversity, equity, and inclusion. The City may use anonymized data to produce aggregate reports for internal or external use.
Please be advised, the City of Brampton uses email to communicate with their applicants for open job competitions. It is the applicant’s responsibility to include an updated email address that is checked daily and accepts emails from unknown users. As we send time sensitive correspondence via email (i.e. testing bookings, interview dates), it is imperative that applicants check their email regularly. If we do not hear back from applicants, we will assume that you are no longer interested in the Job Competition and your application will be removed from the Competition.
If you would like to request content in an alternate format, please contact the Accessibility office by submitting a new Alternate Format Request.