About Toronto MetropolitanAt 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 OpportunityThe Opportunity 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.
Responsibilities - 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.
Qualifications To help us learn more about you, please provide a one-page cover letter 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:
- 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.
#dataanalytics #integraton developer
Additional Information Position Number(s) | 200003942 | Reports To | Data and Business Analytics Manager | Vacancy Type | FTCE | Employee Group | OPSEU | Work Location | Hybrid (in-person and remote) | Start Date | ASAP | End Date | NA | Hours of Work | 36.25 | Grade and Step | 12 | Salary Scale | Target Salary: Min $73,779.01 up to Step 5: $85,530.10 | 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.
For more information, visit Toronto Metropolitan University for Data Analytics and Integration Developer
|