Job Description

JOB TITLE: Assistant Asset Management Data Analyst \xe2\x80\x93 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 \xe2\x80\x93 when working onsite, you will report to the location of West Tower.

HOURLY RATE: Year 1: $19.48; Year 2: $20.41; Year 3: $22.03; Year 4: $24.01

JOB TYPE: Management and Administration

POSTING DATE: July 10, 2023

CLOSING DATE: July 30, 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.
• A police criminal check will be required (to be paid for by the student).
• 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.

Alternate formats will be provided upon request.

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 July 30, 2023 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. The City of Brampton requires all applicants to have a valid Criminal Record and Judicial Matters Check (Level 2) or a Vulnerable Sector Check (if 18 years of age or older) issued from their local police department, dated within the last six (6) months. All checks must indicate for the purpose of employment.

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 \xe2\x80\x9cprefer not to answer\xe2\x80\x9d 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\xe2\x80\x99s 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.

City of Brampton