Junior Data Analyst

About this position

Position Type: Full-time contract until August 31, 2020

Location(s): Toronto

Experience: 3+ years

Number of Positions: 1

Reporting to: Program manager

Start Date: Immediately

Responsibilities (include but are not limited to):

CaMS and File Administration

• Data cleaning, validation and analysis
• Work experience in information governance, data governance or records management
• Create interactive visualization in Power BI where appropriate
• Enter service plans for both employers and participants into CaMS with 100% accuracy
• Assess CaMS reports, monitor progress of programs and cross reference statistics with internal trackers
• Update client’s employment history, placement information and service activities in a timely manner
• Serve as a CaMS expert and provide support to various staff as needed
• Assist with assembling client and employer files according to The Career Foundation’s audit standards
• Maintain physical and electronic copies of client files and employer files
• Communicate with staff on any missing data, signatures, paperwork etc. needed for the files
• Ensure that all follow-up information is included in each file as scheduled
• Perform routine file audits, ensuring data entered in CaMS corresponds 100% with hard copy files
• Upon closing each file in CaMS, complete file checklists to ensure all files are audit-ready
• Keep track of client service plans and ensure that each file has all exit follow-ups completed
• Support staff with entering client profiles in The Career Foundation’s database and SharePoint application
• Close client files in CaMS, including data verification, binding of documents, and filing
• Conduct exit follow-ups with clients at 3, 6, and 12 months; record status updates in CaMS and in physical files
• Assist with allocating files to the 5 EO centres
• Organize and maintain a physical and electronic filing system for the 5 EO centres at The Career Foundation

Reporting / Budget Tracking

• Update and maintain participant registration and budget tracking systems
• Report to manager on statistics, expenditures, and program targets for the 5 EO centres
• Fulfil all employment service documentation requirement
• Assist in collecting and organizing financial information for budget preparation as needed
• Maintain accurate and up-to-date tracking of client supports budget
• Assist in collecting and organizing financial information for budget preparation
• Collect and process placement claims that are submitted to finance
• Reconcile claims with budget allocations for each application/placement to ensure accuracy
• Maintain up-to-date budget expenditures report in Microsoft Excel, ensuring timely entries into the system
• Monitor budget commitments for each program based on monthly, quarterly and yearly targets
• Verify and reconcile internal trackers with reports from the finance department
• Review target achievements and budget of expenditures for programs and advise management of discrepancies and concerns.

Qualifications / Skills Required:

• Must possess post-secondary education / certification in Office Administration, Accounting or Finance related field
• Knowledge in operating CaMS / EOIS government database an asset
• Advanced proficiency in Microsoft Word, Excel, PowerPoint and database applications
• Experience working with invoices, claims, large budgets and various trackers
• Familiarity with Employment Ontario funded programs and services an asset
• Customer service oriented with ability to uphold the organization’s service standards and policies
• Excellent verbal and written communication skills for giving and receiving information, participating in meetings and writing reports
• Strong aptitude in math an asset; must be detailed and accurate
• Must be punctual, self-motivated/self-directed; professional and possess great interpersonal skills
• Excellent organizational skills, able to multi-task / take initiative when needed  
• Flexible to assist team members as needed to help ensure program goals are met
• Ability to maintain sensitive information, exhibit tact, diplomacy and good judgment, with high standards of ethics and confidentiality
• Capable of working under pressure with frequent interruptions; able to prioritize while working on numerous program demands
• Able to work independently and build strong working team relationships
• Must be able and willing to travel between locations in the GTA on a regular basis
• Must be able to work evenings and weekends

Application Process:  Please submit a cover letter and résumé to jobs@careerfoundation.org.  Please remember to quote the job title of the position you are applying for in the subject line of your email. No phone calls please. Thank you for your interest in The Career Foundation.