Senior Business Intelligence and Data Integration Developer

Job Responsibility: 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 Level: Level 10 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 Senior Business 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.