Data Analytics and Integration Developer

Remote Toronto, ON

The Data Analytics and Integration Developer (formerly named, Business Intelligence & ETL Developer) will play a key role in uncovering actionable insights from a high volume and varied sources of data to help improve the overall student experience, streamline operational processes, and facilitate informed decision-making by:

  • Collaborating with various Chang School teams (Data & Business Analytics, IT Operations, Applications, Finance, Marketing, etc.), using industry best practices and current technologies, to extract data from various sources and develop meaningful reports, data visualizations, and processes.
  • Developing, maintaining, and enhancing systems including databases, reporting solutions, and Data Integration / Extract-Transform-Load (ETL) processes.  
  • Providing training and user support on dashboards/reports and other business analytics solutions.


  • Support business analytics 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 analytics solutions.
  • Developing technical artifacts describing the functionality of business analytics platforms, data flow between systems, and explaining technical concepts in simple terms (e.g. with analogies) for business to easily grasp them.
  • Following best practices for standard presentation formats, documentation, and reports.
  • Support data integration functions with the department by
  • Loading OLAP cube structures with data extracts from internal systems.
  • Designing, developing, and scheduling data integration processes to transfer information needed for business analytics and reporting.
  • Troubleshooting data integration procedures in the event of a job failure or other technical issue.
  • Create technical artifacts to help business grapes technical concepts with ease and provide analogies, etc.
  • Provides backup and assistance to other members of the department.



  • 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:
  • Data Integration/ETL, Querying Data, Data Visualization and Report/Dashboard Development   
  • Collaborating with business users to gather requirements, impart training and explain technical concepts in business-friendly language
  • Strong knowledge of the following skills:
  • Microsoft Data/business intelligence suite - SQL Server, SSAS (SQL Server Analysis Services), SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services). 
  • Experience using similar database systems/stacks from major vendors (e.g. Oracle, IBM, Microsoft Azure Analysis Services, Teradata, etc.) would be considered.
  • Data Query languages - SQL, Multi-Dimensional Expression (MDX).
  • Experience using Data Analysis Expression (DAX) / PowerQuery M for Tabular SSAS models / Power BI would be considered.
  • Reporting/Data Visualization tool(s) - Tableau preferred.
  • Experience in Power BI, Qlikview, and/or another leading reporting tool would be considered.

Nice-to-have skills:

  • Some programming skills - Python, Excel VBA (Visual Basic for Applications).
  • Experience dealing with data from complex enterprise systems, such as financial systems, customer relationship management (CRM) systems, student information systems (SIS), enterprise resource planning systems (ERP), etc.
  • Strong analytical skills and logical thinking to assess trends from data to provide insights and proactively share findings with stakeholders and other areas.
  • Solid oral and written communication skills, especially technical writing experience for diverse non-technical audiences
  • Highly organized with the ability to coordinate multiple initiatives/projects concurrently, and meet changing requirements/priorities to accomplish objectives.
  • Build and maintain strong working relationships with internal and external partners; collaborate across organizational boundaries with various functions and coordinate with vendors.

Subscribe to Job Alerts