Business Intelligence & ETL Developer - The Chang School

About Toronto Metropolitan

At the intersection of mind and action, Toronto Metropolitan University is on a transformative path to become Canada’s leading comprehensive innovation university. Integral to this path is the placement of equity, diversity and inclusion as fundamental to our institutional culture. Our current academic plan outlines each as core values and we work to embed them in all that we do.

We welcome those who have demonstrated a commitment to upholding the values of equity, diversity, and inclusion and will assist us to expand our capacity for diversity in the broadest sense. In addition, to correct the conditions of disadvantage in employment in Canada, we encourage applications from members of groups that have been historically disadvantaged and marginalized, including First Nations, Metis and Inuit peoples, Indigenous peoples of North America, racialized persons, persons with disabilities, and those who identify as women and/or 2SLGBTQ+. Please note that all qualified candidates are encouraged to apply; however, applications from Canadians and permanent residents will be given priority.

In April 2022, the university announced our new name of Toronto Metropolitan University, which will be implemented in a phased approach. Learn more about our next chapter.

.

The Chang School

The G. Raymond Chang School of Continuing Education is Canada’s foremost provider of university-based adult education, facilitating access to the University’s renowned, professionally relevant courses and programs. Since 1975, we have been delivering leading-edge workplace knowledge that empowers learners to reach their personal and professional goals. We have approximately 70,000 annual enrolments (in 1,500 courses, seminars, and workshops) in Arts; Business; Communication and Design; Community Services; Engineering, Architecture, and Science; Gateway for International Professionals; Programs for 50+; and Spanning the Gaps – Access to Post-Secondary Education. We also offer 86 career-related certificate programs and numerous course series, with 39 certificate programs that can be completed entirely at a distance. Our flexible, accessible programming is available on campus, via distance education, and off-site for employee groups at leading organizations. 

For more information, visit continuing.ryerson.ca.

We especially welcome applications from individuals who self identify as women, Black, Indigenous or a racialized person, reflecting the community we serve.  If you identify in one of the former groups, we encourage you to self-identify in your cover letter.  At The Chang School, we are guided by the values of equity, diversity and inclusion where the diversity of our community is celebrated.  We thrive on building a just and inclusive culture of respect and learning at all levels of our organization.  We welcome you to join us in our growth.

The Opportunity

The Business Intelligence and ETL Developer will

• Develop reports, data visualizations, processes and database objects using industry best practices and current technologies.  
• Provide support, maintenance and enhancements to systems including databases, business intelligence (BI) systems and Extract-Transform-Load (ETL) processes.  
• Provide user support and training on reports, dashboards and other business intelligence solutions.

Responsibilities

• Support business intelligence reporting and analysis within The Chang School by:
  • Soliciting requirements from end users for data analysis requests, new reports and new dashboards.
  • Creating complex queries, dashboards and datasets for use by internal customers.
  • Analyzing and assessing trends from data to provide insights and recommendations.
• Support end users within The Chang School by:
  • Providing guidance and technical support on dashboards, self-serve reporting and other business intelligence solutions.
  • Developing new documentation and manuals describing the functionality of business intelligence platforms such as Tableau and SSRS.
  • Following best practices for standard presentation formats, documentation and reports.
• Support ETL functions with the department by
  • Loading OLAP cube structures with data extracts from internal systems.
  • Designing, developing and scheduling ETL processes to transfer information needed for business intelligence and reporting.
  • Troubleshooting ETL procedures in the event of a job failure or other technical issue.
  • Writing technical documentation for ETL processes in order to support business continuity in the event of a load or system failure.
• Provides backup and assistance to other members of the department.

Qualifications

To help us learn more about you, please provide a one page letter of interest and resume describing how you meet the following required qualifications:

• Successful completion of a post-secondary degree program in Computer Science, Information Technology, Data Analytics or a related field and a minimum of 3 years of work experience in ETL, data cubes, database administration and data warehousing: 
  • Experience in report design, dashboard development and data visualization.       
  • Experience dealing with financial, marketing and executive information systems.
  • Experience working with business users to gather requirements for reporting and dashboard development.
  • Strong knowledge of SQL, MDX, Tableau, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services), SQL Server and Excel VBA (Visual Basic for Applications).

• Strong analytical skills to assess trends from data to provide insights and proactively share findings with stakeholders and other areas.
• Solid oral and written communication skills, especially in writing experience for technical documentation for different audiences

• Highly-organized with the ability to coordinate multiple initiatives/projects concurrently, and meeting changing requirements/priorities to accomplish objectives.
• Ability to work in a fast-paced environment and effectively manage several projects and deadlines at once.
• Build and maintain strong working relationships with internal and external partners; collaborate across organizational boundaries with various functions and coordinate with vendors
   

#businessintelligence

#ETL Developer

Additional Information

As part of the selection process, candidates may be required to complete an occupational assessment.  
Applications will only be accepted online through Toronto Metropolitan University's careersite.

Toronto Metropolitan University is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA), and aims to ensure that independence, dignity, integration and equality of opportunity are embedded in all aspects of the university culture.
 
We will provide an accessible experience for applicants, students, employees, and members of the Toronto Metropolitan University community.We are committed to providing an inclusive and barrier-free work environment, beginning with the recruitment process. If you have restrictions that need to be accommodated to fully participate in any phase of the recruitment process, please contact hr@ryerson.ca. All information received in relation to accommodation will be kept confidential.