Data Specialist, Office for Refugees (ORAT), Toronto

Employment Opportunity

DATA SPECIALIST

Office for Refugees, Archdiocese of Toronto (ORAT)

830 Bathurst St, Suite 104 Toronto, ON M5R 3G1

Modified Full Time (21 hours per week)

Replacement Position

Level 10: $27,396 - $41,094 (range pro-rated based on 21 hours per week)

Overview:

The Office for Refugees, Archdiocese of Toronto (ORAT) is seeking a skilled Data Specialist to develop and maintain its core databases for the Private Sponsorship of Refugees (PSR) Program and the Economic Mobility Pathways Pilot (EMPP). This role reports directly to the Director.

Responsibilities:

• Maintain, Troubleshoot and Enhance the current Microsoft (MS) Excel PSR Case Management Workbook.

• Develop a robust MS Access database for PSR Case Management and migrate all data from Excel, ensuring integrity and performance.

• Continue developing and maintaining the Economic Mobility Pathways Pilot (EMPP) database.

• Manage and update additional ORAT workbooks.

• Create clear documentation for all databases and tools.

• Additional duties, as needed.

Essential Requirements:

Proven technical expertise is essential. Candidates must demonstrate advanced proficiency in:

• Microsoft Excel (advanced functions, pivot tables, macros, and VBA).

• Microsoft Access (VBA programming, query optimization, and complex SQL queries).

• Design, develop, and maintain MS Access forms, reports for PSR and EMPP case management.

• Strong VBA automation across Excel, Access, and Outlook.

• Data migration and process automation (including Outlook, PDF, and Windows File Explorer).

The following are assets:

• Working knowledge of JavaScript, HTML, MS Forms (SharePoint), and Adobe Acrobat forms.

• Familiarity with Canada’s Private Sponsorship of Refugees (PSR) Program.

Other Requirements:

• Meticulous attention to detail and proven ability to work independently.

• Strong analytical and problem-solving skills.

• Legal entitlement to work in Canada.

• Willingness to occasionally work outside standard hours.

• Successful criminal background check.

Benefits:

• 3 weeks pro-rated vacation

• Comprehensive group benefits after 3 months

• Defined Benefit pension plan with employer contribution match

• Family-friendly policies including paid sick days and maternity/parental leave top-up

• Professional development reimbursement and annual retreat days

In-depth knowledge and experience in MS Excel and Access are mandatory for this position.

Those interested in applying should submit their resume and cover letter (in MS Word or PDF format) quoting Position Number 2025-04 to: Stephanie Nargoz, Director, Human Resources at hr@archtoronto.org.

Deadline: Applications will be accepted until the position is filled.

We thank all applicants, however, only those selected for an interview will be contacted.

In compliance with the Accessibility for Ontarians with Disabilities Act (AODA), the Archdiocese of Toronto provides reasonable accommodations to individuals with disabilities. If contacted for an interview, applicants should make any accommodation needs known at that time.