IT Business Analyst

**About the 360 Program**

This role is part of the 360 Program, an initiative by The King’s Trust Canada. The 360 Program is a two-year initiative designed to help barriered youth aged 18-30 kickstart their careers with a yearlong full-time job, with additional career guidance and support in the second year.

The King’s Trust Canada facilitates this opportunity on behalf of our employer partners, who are committed to offering employment opportunities to qualified youth who may not usually appear in their recruitment pipeline.

**About the employer**

As a corporate event production and management company, we help our clients strengthen their cultures and drive results through the power of transformational live and digital events and experiences. These include customized incentive travel programs, conferences, experiential workshops, launch events, and all things in between.

We are the leader in creating extraordinary experiences through events, meetings and communications that honour the contribution of individuals and inspires them to accomplish more than they thought they ever could.

Our values are a steady compass that guides everything we do:

- As a company we discovered that we value having a safe place to learn and the freedom to try new things.
- We are defined by our solution-oriented focus.
- Everyone at Wynford values taking personal ownership for their actions and responsibilities.
- We know that our colleagues are always ready to band together and will be supporting our success when a challenge needs a team-sized effort.
- We know that courageous conversations among ourselves and our clients build trust and mutual respect.
- Finally, we share a high level of integrity for the way we do business. We will do what we promise.

**About the role**

The IT Business Analyst position is designed to support Wynford’s digital transformation initiatives by bridging the gap between technology and business processes. The primary purpose of this role is to assist in the integration of various software platforms, streamline operations through automation, and enhance data reporting capabilities. By working collaboratively across departments, the co-op student will gain a comprehensive understanding of Wynford’s workflows and challenges, allowing them to provide valuable insights and recommendations for process improvements.

**Day/Week in the role**:
Technical Integrations: (10%)
- Develop and implement integrations between platforms such as Microsoft M365, Smartsheet, and Cvent.

Data Reporting and Visualization: (10%)
- Utilize Power BI and Smartsheet to create and maintain data reports and dashboards that provide actionable insights.
- Analyze data trends to support decision-making processes.

Process Automation: (5%)
- Design and implement automation solutions using Power Automate (and other automation tools) to enhance efficiency across SaaS platforms.
- Identify opportunities for automation and process improvement.

Business Process Analysis: (50%)
- Engage with various departments to understand their processes, tools, and workflows.
- Analyze current practices and document recommendations for improvement.

Registration Website Development: (5%)
- Assist in the development of registration websites using the Cvent platform.
- Focus on enhancing user experience and operational efficiency.

Documentation and Diagrams: (10%)
- Create and maintain data flow diagrams and entity relationship diagrams to map out Wynford’s processes and systems.
- Ensure documentation is clear, comprehensive, and accessible to stakeholders.

Collaboration and Communication: (5%)
- Work closely with cross-functional teams to gather requirements and ensure alignment on project objectives.
- Present findings and recommendations to team members and management.

Continuous Improvement: (5%)
- Stay updated on industry trends and best practices in business analysis and digital transformation.

**Key skills**

Creativity and problem solving:

- Create and manage technical integrations between key platforms (Microsoft M365, Smartsheet, Cvent) to ensure seamless data exchange and improve workflow efficiency.
- Develop robust data reporting solutions using Power BI and Smartsheet, enabling stakeholders to access and interpret critical data for strategic decision-making.
- Leverage Power Automate and Smartsheet to streamline and automate business processes, reducing manual effort and minimizing errors across SaaS platforms.
- Conduct thorough analyses of existing workflows, tools, and practices, identifying areas for improvement and documenting actionable recommendations that enhance productivity.

Communication:

- Create clear and comprehensive diagrams and documentation that reflect Wynford’s processes and systems, aiding in communication and understanding across teams.
- Present technical information clearly to non-technical audiences.

Organization:

- Manage multiple tasks and deadlines effectively.
- Prioritize work and meet projec