Senior Business Intelligence and Data Integration Developer
3 weeks ago
Monday, May 6, 2024
Term: 1 Permanent and 1 Contract, Full-Time
Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch
Application Deadline: May 17, 2024
Salary Range: Min: $92,902 to Max: $116,123
Work Location: Head Office, Toronto, ON; Hybrid
The Alcohol and Gaming Commission of Ontario (AGCO) is a regulatory agency that reports to the Ministry of the Attorney General. The AGCO is responsible for regulating the alcohol, gaming, horseracing, and private cannabis retail sectors in Ontario, in accordance with the principles of honesty and integrity, and in the public interest.
The Information and Information Technology (I&IT) Division of the AGCO is looking for a SeniorBusiness Intelligence and Data Integration Developer . Reporting to the Senior Manager, Data Science and Analytics, the successful candidate will be responsible for designing and building efficient and reliable data systems, pipelines, and business intelligence solutions in a cloud environment to support reporting and analytical needs of the organization.
In this role, the successful candidate will:
- Communicate effectively with stakeholders, including business users to understand business requirements to determine technical requirements.
- Provide subject matter expertise and partner with stakeholders to design and develop data pipelines and systems to integrate, transform and organize data from multiple data sources into reliable and easily consumable enterprise datasets to support analytics and business intelligence needs.
- Lead in the execution of plans for migrating on premise ETL processes, database systems and pipelines onto the cloud environment.
- Develop pipelines that prepare data for prescriptive and predictive modeling.
- Prototype and build Power Platform based business intelligence solutions (e.g., reports, dashboards, analytics, Generative AI applications) to support business objectives.
- Ensure developed process and solutions are error free by conducting unit testing, supporting peer testing and code review.
- Review usage and performance of pipeline and data systems to ensure cloud resources are used optimally according to business needs. Redesign and adjust when opportunities exist to gain efficiency.
The ideal candidate will have:
- A technical degree in Computer Science, Statistics, Information Systems, or another quantitative field.
- Certification in Data Engineering, Generative AI or Business Intelligence Solutions Development is an asset.
- Proven experience as a data developer, business intelligence developer or a similar role with experience designing, building, and optimizing data pipelines, data systems and business intelligence solutions (e.g., reports, dashboards).
- Experience with relational databases including Oracle, SQL Server, Azure SQL Database.
- Experience with data pipeline and model development tools such as Visual Studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Azure Synapse Analytics, Azure Data Factory, Azure Storage/Data Lake.
- Advanced knowledge of programming languages (e.g. Python, R).
- Experience with using MS Office Suite.
- Knowledge of Machine Learning and Generative AI concepts.
- Knowledge of Power Platform with expert proficiency in Power BI.
- Experience supporting and working with cross-functional teams in a dynamic environment.
- Experience collaborating using Azure DevOps and the agile framework.
- Proven experience taking highly conceptual business needs and translate into a solution that can be effectively implemented.
- Collaborative team player with effective communication and facilitation skills who can build strong relationships to solve problems.
- The successful candidate must be eligible to work in Canada and will be subject to a criminal background check.
The AGCO is an inclusive and equal opportunity employer.
The AGCO has the responsibility to lead by example in advancing racial equity and to build a diverse, inclusive, accessible and respectful workplace where every employee has a voice and the opportunity to fully contribute. To this effect, you are encouraged to reflect upon the diversity you would bring to the role within your application including, but not limited to, individuals identifying with one or more of the under-represented groups identified within Ontario’s Human Rights Code.
Disability related accommodation during the recruitment process is available upon request.- 90 Sheppard Ave E, North York, ON M2N, Canada
-
Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full timeSenior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...
-
Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full timeSenior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...
-
Old Toronto, Canada Alcohol and Gaming Commission of Ontario Full timeSenior Business Intelligence and Data Integration Developer Monday, May 6, 2024 Term: 1 Permanent and 1 Contract, Full-Time Division/Branch: Information and Information Technology (I&IT) Division / Enterprise Data and Analytics Branch Application Deadline: May 17, 2024 Salary Range: Min: $92,902 to Max: $116,123 Work Location: Head Office,...
-
Analyst, Human Intelligence
1 month ago
Toronto, ON, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Business Intelligence Developer
4 weeks ago
Toronto, ON, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence Developer
4 weeks ago
Toronto, ON, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence Developer
3 weeks ago
Toronto, ON, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med Echo Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities: Design, develop, test, and deploy MicroStrategy-based visualizations, documents,...
-
Analyst, Human Intelligence
1 month ago
Old Toronto, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Analyst, Human Intelligence
1 month ago
Old Toronto, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Analyst, Human Intelligence
1 month ago
Old Toronto, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Analyst, Human Intelligence
1 week ago
Old Toronto, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Analyst, Human Intelligence
1 week ago
Old Toronto, Canada Edelman Data X Intelligence Full timeData and Intelligence – Human Intelligence / Edelman Data & Intelligence (DXI) is currently seeking an Analyst to join our Data and Intelligence team. Reporting to the Insights Manager, the role will focus on providing insights and consultative support to our account teams to help drive business results for our clients. The successful candidate will be...
-
Business Intelligence Developer
1 month ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence Developer
4 weeks ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence Developer
3 weeks ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer– MicroStrategy Project: Insight Med Echo Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project.Responsibilities: Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence Developer
3 weeks ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med Echo Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities: Design, develop, test, and deploy MicroStrategy-based visualizations, documents,...
-
Business Intelligence Developer
3 weeks ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Insight Med Echo Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities: Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers,...
-
Business Intelligence Developer
3 weeks ago
Toronto, Canada Altis Technology Full timeSenior Business Intelligence Developer– MicroStrategyProject: Insight Med Echo Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project.Responsibilities: Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
-
Business Intelligence/ BI Developer
3 weeks ago
Toronto, ON, Canada Altis Technology Full timeSenior Business Intelligence Developer – MicroStrategy Project: Background: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and reports, including...
-
Business Intelligence/ BI Developer
4 weeks ago
Toronto, ON, Canada Altis Technology Full timeSenior Business Intelligence Developer - MicroStrategy Project: Insight Med EchoBackground: BI reporting changes to incorporate Med Echo data into Insight. We are seeking a skilled Senior Developer to join our team and contribute to this project. Responsibilities:Design, develop, test, and deploy MicroStrategy-based visualizations, documents, dossiers, and...
