Business Intelligence Developer - Toronto, Canada - Cineplex

Description

Work location:

City:

What you will do:

The Business Intelligence Report Developer will join our growing team of analytics experts. They will be joining a team that is the Centre of Excellence for Corporate Data. The individual will be responsible for building, modernizing, and maintaining organizational reports. The ideal candidate has experience with SQL Server databases, data modelling and Power BI report development. The individual will be a problem solver that has expertise and delivery depth across data platforms, applied data analysis, Azure cloud, and business automation solutions.

Key Responsibilities:

• Be the primary contact for maintaining the existing reporting suite based on Power BI and SSRS dashboards with the support of other experienced BI team members.
• Strong SQL skills required.
• Investigative and problem-solving skills will be needed.
• Collaborate with stakeholders to define the business layer and presentation layer of the BI model that is business-friendly and supports a self-service environment where appropriate.
• Communication skills to clearly understand the requirements that are being laid out, translate to technical requirements, and execute.
• Review functional and design specifications to ensure full understanding of individual deliverables.
• Ongoing monitoring of existing key reports to ensure data quality and integrity.
• Will support most of the data quality testing in close collaboration with Data Engineering team.
• Conduct a comprehensive review of all current BI reporting to establish a BAU Reporting Requirements Definition for all business functions.

Education and Certification:

• Diploma or Degree in Data, Analytics, Computer Science, Mathematics or Engineering.

Experience:

• 2+ years of professional experience in report development (SSRS & Power BI ideally)
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Experience debugging Multi-Dimensional and Tabular Data Models.
• Experience delivering solutions on the Azure platform (Data Lake, Synapse, Data Factory)

Knowledge, Skills and Abilities:

• SQL knowledge and experience working with relational databases, complicated query authoring (SQL Window Functions, Stored Procedures etc.) as well as working familiarity with a variety of cloud databases (Databricks, Azure SQL, Azure Synapse).
• Power BI and Power Platform expert user, with the ability to generate complicated, optimized reports bringing data from multiple different sources, ability to create and think in terms of a semantic reporting model.
• Power Platform experience will include automating business processes (especially around data gathering and manipulation of data from Excel and csv files).

Inclusion & Diversity

Cineplex, its subsidiaries, and affiliates are equal opportunity employers with a commitment to hiring and retaining a diverse workforce. We encourage and welcome applications from all intersectional walks of life. The collective sum of our individual differences, experiences, knowledge, innovation, self-expression, unique capabilities, and talent represents a significant part of our culture. By valuing a diverse workforce, we enforce hiring practices that are fair and equitable.

Accessibility

We are committed to improving access and opportunities for all individuals, including those with disabilities by identifying and removing barriers that may prevent, inhibit, or restrict their access to employment oporunities. If you require accommodation at any stage of our hiring process (application, interviews, assessments, and placement), please contact us at or via email at

While we appreciate all interest, only those candidates selected for an interview will be contacted.