18 Oct
Family Service Toronto
Toronto
Job details
Here’s how the job details align with your profile.
Pay
- $62,856–$77,451 a year
Job type
- Full-time
- Permanent
Shift and schedule
- Monday to Friday
Location
128 Sterling Road, Toronto, ON
Benefits
Pulled from the full job description
- Dental care
- Employee assistance program
- Extended health care
- Paid time off
- Vision care
- Wellness program
Full job description
Grow with us!
Family Service Toronto (FST) helps people face a wide variety of life challenges. For over 100 years, we have worked with individuals and families destabilized by precarious mental health and/or socioeconomic circumstances, to achieve greater resilience and stability in more just and supportive communities.
We achieve this through our direct service work of intervention and prevention which includes, case management, counselling, peer support and education; knowledge building; and system-level work including social action, advocacy, community-building and working with partners to strengthen the sector.
We’re proud of our people and culture! We are constantly evolving what we do and how we do it. Our work is grounded in the lived experience of the clients and the community. We celebrate diversity, equity, inclusion, and excellence. We are agile, learning and always willing to try new things.
The Opportunity!
Reporting to Manager, Technology & Business Intelligence, the Process Analyst will perform a variety of database-related and administrative tasks for the PassportONE program. This role will also serve as central support for the organization’s Electronic Client Record System (ECRS), overseeing its ongoing development and deployment Additionally,
the Process Analyst will handle reporting and analytics requirements for other programs at Family Service Toronto (FST).
Responsibilities
Database and Systems Integration:
- Thoroughly understands the business processes, workflows, systems, and requirements for FST programs.
- Thoroughly understands the integration between the PassportONE CRM system and the MCCSS DSCIS system. Interprets DSCIS manuals and documentations for DSCIS upgrades to identify all impacts on PassportONE systems.
- Identifying data inconsistencies between FST systems and reporting servers. Advising stakeholders on the data health regularly to ensure accuracy and to improve business practices.
- Troubleshoot technical issues across FST systems (including PassportONE CRM, TPA portal, eCLAIM portal, DocuShare, eForm, TREAT,
WebFocus) and coordinate with IT teams for resolution, escalating unresolved issues to the Manager of Technology & Business Intelligence.
- Collect business requirements from system users for change requests, translating them into technical requirements for IT teams.
- Assign prioritization scores to outstanding change requests on TREAT and PassportONE systems, planning timelines to inform users of upcoming developments.
- Design and develop workflows to maintain data accuracy, completeness, reliability, relevance, and timeliness on FST systems, monitoring and analyzing data quality, and supporting data correction in collaboration with system users.
- Perform User Acceptance Testing (UAT) for system developments on PassportONE and TREAT systems.
- Document report processes, developments, changes, and project work plans, ensuring they are up-to-date.
- Identifies and investigates system and business process deficiencies. Suggests improvements in processes, data collection, analysis methods, service data systems and possibility of integrating different FST databases.
- Participates as the representative on planning/implementation workgroups internally (i.e., TREAT Super User Group) as required.
Data Analytics and Reporting:
- Develops and verifies accuracy of program reports: such as (but not limited to) PassportONE MCCSS Investment and Quarterly Reports, FST Quarterly Reports and any other ad-hoc reports using a range of business intelligence tools.
- Create discrepancy reports to monitor and analyze data quality in FST systems, communicating with stakeholders to investigate and support corrections as required.
- Design and develop Power BI dashboards and paginated reports using Power Query, DAX, SQL, R, and Python.
- Design and develop reports in TREAT using WebFocus language (.html).
- Respond to inquiries from FST Managers, PAs, TPAs, IT teams, and MCCSS related to reports, statistics, and trends.
- Interpret data, analyze results using statistical techniques, and provide ongoing analysis.
- Work with internal stakeholders to understand dashboard, scorecard, and analytics requirements.
- Create effective and meaningful data visualizations to clearly demonstrate and explain trends in large and complex datasets.
Training and Support:
- Provides technical support and training in person, online and on the phone to FST staff, and to PA and TPA users for PassportONE systems, business processes and workflows.
- Identifies training needs based on frequently asked questions, creates technical and user training manuals, designs and delivers training sessions for new and existing processes, system changes and developments to PAs, TPAs and FST staff.
- Advises the Manager, Technology and Business Intelligence of any consistently arising issues and queries raised by PAs, TPAs and FST staff.
- Provides training sessions to FST staff and PAs on how to access the Power BI service, run paginated reports and interact with and filter dashboards.
- Provides training sessions to FST staff on how to access, run and interpret reports developed in WebFocus.
The Process Analyst may be assigned additional duties consistent with this role.
Qualifications
- University degree or equivalent experience in Mathematics, Economics, Computer Science, Information Management, or Business Administration.
- Minimum of three years of related work experience.
- Advanced computer skills (e.g., Microsoft Word, Excel, PowerPoint, Outlook, Access, CRM).
- Strong knowledge of statistics and experience using statistical packages for data analysis (Excel, Access, PowerBI, etc.).
- Proficiency in database query and programming languages such as DAX, SQL, Python, .html, and R.
- Experience handling large data sets and relational databases.
- Ability to respond sensitively and professionally to client needs while maintaining confidentiality.
- Excellent verbal and written communication skills in English.
- Ability to work collaboratively as part of a diverse team.
- Commitment to working in and contributing to an environment that respects the human rights, dignity, and worth of all individuals.
- Demonstrated commitment to principles of social justice, equity, inclusion, and cultural competency.
- Satisfactory Criminal Reference Check with Vulnerable Sector Check.
Interested?
Please indicate file number IT #50-24 on your application and submit cover letter and resume by Nov 1, 2024, 5:00 PM to [email protected].
Our goal is to attract, develop, and retain highly talented employees from diverse backgrounds allowing us to benefit from a wide variety of experiences and perspectives.
We actively encourage applicants from all equity seeking groups. First Nations, Inuit, Métis, Black and People of Colour, people with disabilities, people of diverse gender expression, members of 2SLGBTQI+ communities and people with lived experience of poverty are encouraged to apply.
In accordance with Ontario Human Rights Code, Accessibility for Ontarians with Disabilities Act, 2005, and FST’s Equity and Inclusion policy, accommodation will be provided in all parts of the hiring process. Applicants need to make their needs known in advance.
We thank all applicants and will contact the individuals selected for an interview.
Job Types: Full-time, Permanent
Pay: $62,856.00-$77,451.00 per year
Benefits:
- Dental care
- Employee assistance program
- Extended health care
- Paid time off
- Vision care
- Wellness program
Schedule:
- Monday to Friday
Work Location: Hybrid remote in Toronto, ON M6R 2B7
Application deadline: 2024-11-01
▶️ Process Analyst
🖊️ Family Service Toronto
📍 Toronto