Business Intelligence Specialist - Intermediate

Cleo Consulting; Ontario; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Specialist to join their dynamic Data & Analytics team. This pivotal role involves serving as a strategic advisor, translating business goals into actionable data solutions, and orchestrating complex data integrations across Azure platforms. The ideal candidate will have a proven track record in delivering end-to-end data solutions, managing stakeholder relationships, and ensuring data governance. If you thrive in a fast-paced environment and have a passion for data-driven storytelling, this opportunity offers a chance to make a significant impact on enterprise-wide initiatives.

Qualifications

• 5-8 years of experience in large scale data integration.
• Proven experience with Azure data services and data pipelines.
• Strong analytical skills with a focus on stakeholder needs.

Responsibilities

• Act as a data strategist translating business goals into data requirements.
• Lead mapping of complex data flows across Azure components.
• Conduct advanced data investigations and deliver reporting solutions.

Skills

Data Analysis

Stakeholder Management

Azure Data Services

SQL

Power BI

Education

Bachelor's Degree in Data Science

Master's Degree in Computer Science

Tools

Azure Data Factory

Azure Synapse Analytics

Data Lake

SQL Databases

Azure DevOps

Jira

Job description

Assignment : RQ00141 - Business Intelligence Specialist - Intermediate

Requisition : RQ00141

Job Title : Business Intelligence Specialist - Intermediate

Client : Metrolinx

Start Date : 2025-05-20

End Date : 2025-11-14

Department : Solution Delivery

Office Location : 277 Front Street West, Toronto

Business Days : 129.00

Location : Hybrid - Up to 2 days in office

Public Sector Experience : Nice to Have

Must Haves :

• 5-8 years doing large scale integration
• 5- 8 years Lead discovery sessions and stakeholder interviews to deeply understand business drivers, KPIs, and analytical needs across departments.
• 6+ years of experience in data analysis, business analysis, or analytics consulting within enterprise environments.

Description

• We are looking for an experienced and strategic Senior Data Analyst to join our Data & Analytics team. This is not your average data role - it requires a high-performing individual with deep expertise in working across complex data ecosystems, particularly within the Microsoft Azure platform. You will serve as a critical link between business units, data engineers, architects, and governance teams - driving clarity in requirements, managing stakeholder relationships at all levels, and ensuring successful implementation of enterprise-wide data initiatives.
• This role is ideal for someone with a strong track record in delivering end-to-end data solutions, orchestrating large-scale change requests, and proactively identifying opportunities to streamline data processes and drive strategic outcomes.

Key Responsibilities :

• Strategic Business & Data Alignment

Act as a data strategist and trusted advisor to senior business stakeholders, translating business goals into data requirements and actionable solutions.

• Lead discovery sessions and stakeholder interviews to deeply understand business drivers, KPIs, and analytical needs across departments.

Lead the mapping of complex data flows across Azure components, including Azure Data Factory, Azure Synapse Analytics, Data Lake, and SQL Databases.

• Work closely with data architects to ensure business requirements are aligned with data models, pipelines, and architectural standards.
• Develop and maintain robust documentation, including data lineage, flow diagrams, and interface mapping.
• Change Request & Implementation Governance

Own the lifecycle of high-impact change requests : from impact analysis and prioritization through to deployment and post-implementation review.

• Collaborate with product owners, developers, QA teams, and DevOps to ensure changes are implemented with minimal disruption.
• Manage change control boards, sprint planning sessions, and delivery timelines for data platform initiatives.
• Data Governance, Quality, and Compliance

Partner with data governance and compliance teams to ensure data solutions adhere to enterprise standards, privacy policies, and security frameworks.

• Define data quality metrics and collaborate on anomaly detection and resolution processes.
• Advanced Data Analysis & Reporting

Conduct high-value data investigations and complex queries across structured and unstructured datasets.

• Deliver advanced dashboards and reporting solutions in Power BI, ensuring consistent performance, reliability, and stakeholder satisfaction.
• Provide insights and recommendations to executive stakeholders using robust analytical storytelling.

Minimum Qualifications :

• Bachelor's or Master's degree in Data Science, Computer Science, Information Systems, or a related technical discipline.
• 6+ years of experience in data analysis, business analysis, or analytics consulting within enterprise environments.
• Proven experience working with Azure data services at scale, with strong familiarity with data pipelines, transformation layers, and storage components.
• Advanced proficiency in SQL, Power BI
• Demonstrated success in managing complex data projects, including multi-stakeholder coordination, technical translation, and delivery oversight.

Preferred Qualifications :

• Experience with Agile methodologies, sprint planning, and backlog management (e.g., Azure DevOps, Jira).
• Certifications in Azure Data Fundamentals,
• Executive Communication : Ability to engage and influence senior leaders with data-driven storytelling.
• Systems Thinking : Holistic understanding of how data flows through people, processes, and technology.
• Leadership : Self-starter with the ability to lead cross-functional initiatives with minimal oversight.
• Attention to Detail : Precision in requirements documentation, quality assurance, and delivery hand-offs