City : Toronto, Ontario, Canada

Category : Full time

Industry : Public Services/Utilities

Employer : Healthcare of Ontario Pension Plan (HOOPP)

Why you’ll love working here:

• high-performance, people-focused culture

• our commitment that equity, diversity and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves

• learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth

• optional membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security

• virtual fitness, yoga and meditation classes, nutritional consultations and wellness seminars

• flexible hybrid work model that embraces remote work

• the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Application Deadline: September 17, 2024

Application Requirements: Cover Letter, Resume, and Transcript

Job Summary

The BI & Automation Analyst (RPA), Co-op Student will gain hands-on experience working with leading automation software applications and business intelligence technologies. Primary objectives include develop and support automation and reporting solutions, monitoring process jobs, communicating status and investigate issues as they arise. This involves having a detailed understanding of business processes and being able to logically trace steps to determine issue resolutions. This role will provide support in the enhancements of existing solutions and development of new project.

What you will do:

• Participate in requirements gathering sessions for process reviews, assist in BI & RPA feasibility to assess processes, capture steps and tasks required for process automation

• Develop and support automations and orchestrations using UiPath and Microsoft Power Platform (Power Automate, Power Apps, Power BI) from proof-of-concept to production deployment

• Coordinate data reconciliation, maintenance and troubleshooting

• Develop workflow and integrate with SharePoint and Microsoft 365

• Provide technical support and enhancements for existing RPA automations and BI solutions which includes troubleshooting, re-running jobs in orchestrator, communicating with business teams

• Produce, edit, and review key project documents (Process Design, Technical Design, User Support, etc..)

• Research latest trends in emerging technologies and technical practices

What you bring:

• Bachelor's and/or Master’s degree in Computer Science, Computer Engineering, Software development

• Understanding and knowledge of basic C# and .Net programming skills (conditional/non conditional data handling, exception handling)

• Intermediate knowledge of and development with UiPath and Microsoft Power Platform (Power Automate, Power Apps, Power BI, Azure, SharePoint, Teams, and Common Data Service)

• Understanding of PowerApps formulas and best practices

• Intermediate to advanced SQL, data models

• Know how to set up and troubleshoot custom connectors within Power Apps and Power BI

• Python coding experience would be considered an asset
  Experience coding and/or using REST APIs, JSON parsing would be considered an asset

• Knowledge of data visualization tools (e.g. Power BI, Tableau)

• Excellent oral and written communication skills

• Strong collaboration skills - you partner well with others to solve problems and actively incorporate input from various sources and collecting business requirements

• Working with key stakeholders to drive business results