BUSINESS INTELLIGENCE CONSULTANT
About the role
Job ID: 58760
Job Category: Poilicy, Planning and Research
Division & Section: Public Health, Decision Support, Surv & Immunization
Work Location: Metro Hall, 55 John St, Toronto, M5V 3C6
Job Type & Duration: Full-time, Temporary (Approximately 14 months) Vacancy
Salary: $94,905.00-$128,386.00
Shift Information: Monday to Friday, 35 hours per week
Affiliation: Non-Union
Number of Positions Open: 1
Posting Period: 03-Sep-2025 to 17-Sep-2025
Job Summary:
The business intelligence consultant is responsible for leading the Epidemiology and Data Analytics Unit (EDAU)'s transition of its code to the R language from existing software program languages. They will migrate code (SAS to R), develop products, and provide R language technical support and training to both epidemiology teams within the EDAU.
Major Responsibilities:
- Works closely with EDAU teams to develop and transition code for products currently using SAS or STATA to R programming language.
- Prepares documentation, reports, presentations, related to projects and activities.
- Implements detailed plans and recommends policies/procedures regarding program specific requirements.
- Conducts research into assigned area ensuring that such research takes into account developments within the field, corporate policies and practices, legislation and initiatives by other levels of government.
- Provides consultation and guidance on creating top-quality clean code and participates in peer-to-peer code review.
- Prepares reports for management in relation to changes in business technology solutions.
- Plans and executes assigned projects (i.e. defines purpose, objectives, project activities, milestones and deliverables, monitors work performance and tracks progress to ensure project goals and timelines are met).
- Meets timelines and milestones by monitoring deliverables. Accurately identifies resource requirements and potential risks. Supports research projects and data mining, including trends analysis.
- Follows all privacy protocols regarding sensitive data, information storage and extraction.
- Creates contingency plans both for business and system interruptions and supports business continuity planning.
- Creates reports and consults with the Managers regarding data analysis protocols and recommendations.
- Maintains a data dictionary of all valid, tested and repeatable data and/or information products.
- Develops, implements and applies sound information management standards, procedures and tools to provide consistent, accurate, timely information.
- Liaises with information providers throughout the City and other municipalities to develop and share information on R coding language.
You must also have:
- Knowledge of epidemiological principles and practices.
- Excellent leadership, interpersonal, facilitation and conflict management skills.
- Excellent written and verbal communication skills, including the ability to write reports and briefing notes, and develop presentations.
- Strong analytical and problem-solving skills.
- Ability to work cooperatively as part of a multi-disciplinary team, foster relationships with stakeholders within Toronto Public Health and in other city divisions and external organizations.
- Ability to handle challenging and time-sensitive assignments in a high profile professional and political environment.
- Proficiency in MS Word, Excel, Outlook, Power Point.
- Experience with Python and SQL+ is an asset.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.
Accommodation
The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.
About City of Toronto
The City of Toronto is committed to fostering a positive and progressive workplace culture, and strives to build a workforce that reflects the citizens it serves. We are committed to building a high performing public service, with strong and effective leaders to enable service excellence, through high engagement and healthy and safe workplaces.
Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities. As the fourth largest city in North America, Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents and businesses.
Toronto Public Service consists of approximately 35,771 employees, providing programs and services to Toronto residents, businesses and visitors. Additionally, the City of Toronto has a number of agencies and corporations including the Toronto Police Service, Toronto Public Library and the Toronto Transit Commission, which make up the broader municipal organization.
There are 44 operating divisions and offices providing an extensive level of programs and services. We offer diverse career opportunities across a wide variety of professional, trade, administrative, managerial and other employment roles. The Toronto Public Service has won numerous awards for quality, innovation and efficiency in delivering citizen-focused services. We are proud to have been named one of Canada's Top 100 Employers, Canada's Best Diversity Employers, Top Family Friendly Employers and Greater Toronto's Top Employers.
Consider joining the award-winning Toronto Public Service and help us make a difference in a great City!
BUSINESS INTELLIGENCE CONSULTANT
About the role
Job ID: 58760
Job Category: Poilicy, Planning and Research
Division & Section: Public Health, Decision Support, Surv & Immunization
Work Location: Metro Hall, 55 John St, Toronto, M5V 3C6
Job Type & Duration: Full-time, Temporary (Approximately 14 months) Vacancy
Salary: $94,905.00-$128,386.00
Shift Information: Monday to Friday, 35 hours per week
Affiliation: Non-Union
Number of Positions Open: 1
Posting Period: 03-Sep-2025 to 17-Sep-2025
Job Summary:
The business intelligence consultant is responsible for leading the Epidemiology and Data Analytics Unit (EDAU)'s transition of its code to the R language from existing software program languages. They will migrate code (SAS to R), develop products, and provide R language technical support and training to both epidemiology teams within the EDAU.
Major Responsibilities:
- Works closely with EDAU teams to develop and transition code for products currently using SAS or STATA to R programming language.
- Prepares documentation, reports, presentations, related to projects and activities.
- Implements detailed plans and recommends policies/procedures regarding program specific requirements.
- Conducts research into assigned area ensuring that such research takes into account developments within the field, corporate policies and practices, legislation and initiatives by other levels of government.
- Provides consultation and guidance on creating top-quality clean code and participates in peer-to-peer code review.
- Prepares reports for management in relation to changes in business technology solutions.
- Plans and executes assigned projects (i.e. defines purpose, objectives, project activities, milestones and deliverables, monitors work performance and tracks progress to ensure project goals and timelines are met).
- Meets timelines and milestones by monitoring deliverables. Accurately identifies resource requirements and potential risks. Supports research projects and data mining, including trends analysis.
- Follows all privacy protocols regarding sensitive data, information storage and extraction.
- Creates contingency plans both for business and system interruptions and supports business continuity planning.
- Creates reports and consults with the Managers regarding data analysis protocols and recommendations.
- Maintains a data dictionary of all valid, tested and repeatable data and/or information products.
- Develops, implements and applies sound information management standards, procedures and tools to provide consistent, accurate, timely information.
- Liaises with information providers throughout the City and other municipalities to develop and share information on R coding language.
You must also have:
- Knowledge of epidemiological principles and practices.
- Excellent leadership, interpersonal, facilitation and conflict management skills.
- Excellent written and verbal communication skills, including the ability to write reports and briefing notes, and develop presentations.
- Strong analytical and problem-solving skills.
- Ability to work cooperatively as part of a multi-disciplinary team, foster relationships with stakeholders within Toronto Public Health and in other city divisions and external organizations.
- Ability to handle challenging and time-sensitive assignments in a high profile professional and political environment.
- Proficiency in MS Word, Excel, Outlook, Power Point.
- Experience with Python and SQL+ is an asset.
Equity, Diversity and Inclusion
The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.
Accommodation
The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.
About City of Toronto
The City of Toronto is committed to fostering a positive and progressive workplace culture, and strives to build a workforce that reflects the citizens it serves. We are committed to building a high performing public service, with strong and effective leaders to enable service excellence, through high engagement and healthy and safe workplaces.
Toronto is home to more than 2.9 million people whose diversity and experiences make this great city Canada’s leading economic engine and one of the world’s most diverse and livable cities. As the fourth largest city in North America, Toronto is a global leader in technology, finance, film, music, culture, and innovation, and consistently places at the top of international rankings due to investments championed by its government, residents and businesses.
Toronto Public Service consists of approximately 35,771 employees, providing programs and services to Toronto residents, businesses and visitors. Additionally, the City of Toronto has a number of agencies and corporations including the Toronto Police Service, Toronto Public Library and the Toronto Transit Commission, which make up the broader municipal organization.
There are 44 operating divisions and offices providing an extensive level of programs and services. We offer diverse career opportunities across a wide variety of professional, trade, administrative, managerial and other employment roles. The Toronto Public Service has won numerous awards for quality, innovation and efficiency in delivering citizen-focused services. We are proud to have been named one of Canada's Top 100 Employers, Canada's Best Diversity Employers, Top Family Friendly Employers and Greater Toronto's Top Employers.
Consider joining the award-winning Toronto Public Service and help us make a difference in a great City!