Lead Data Analyst: Hybrid Role with Azure & PowerBI

Aylo; Montreal (administrative region); Hybrid; CAD 85,000 - 110,000; Full time

Job summary

Aylo is seeking a Team Lead Data Analyst in Montreal to guide a high-performing analytics team and translate business needs into robust reporting environments. You will partner with Directors, Analysts, and Developers to capture requirements, structure data marts, and drive data-driven decisions across the org.

The role combines leadership with hands-on data work, requiring 4+ years in analytics, 2+ years in leadership, and strong SQL/PowerBI expertise in a hybrid office setting.

Qualifications

• Bachelor's degree in a relevant field and 4+ years in a technical analytics role.
• 2+ years of leadership experience and ability to guide analysts.
• Strong SQL-based data extraction and analytics capabilities.
• Experience with SQL Server, Excel, PowerBI, Fabric or Cubes.
• Strong communication and problem-solving skills with customer focus.

Responsibilities

• Lead a team of analysts and coordinate with Directors, Analysts, and Developers.
• Capture business requirements and shape reporting content and layout.
• Analyze data from data marts and develop reports.
• Create queries to investigate data issues or build new report structures.
• Collaborate with DBAs and devs to estimate work and refine iterations.
• Coordinate with Project Managers on status, risks, and roadmaps.
• Develop subject matter expertise and contribute to roadmap planning.

Skills

Leadership

Data Analysis

Stakeholder Collaboration

Problem Solving

Customer Support

Communication

Data Modeling

Education

Bachelor's degree in CS/Math/Related

Tools

SQL Server

Excel

PowerBI

Fabric

Cubes

Azure

MySQL

Job description

Aylo is seeking a Team Lead Data Analyst in Montreal to guide a high-performing analytics team and translate business needs into robust reporting environments. You will partner with Directors, Analysts, and Developers to capture requirements, structure data marts, and drive data-driven decisions across the org.

The role combines leadership with hands-on data work, requiring 4+ years in analytics, 2+ years in leadership, and strong SQL/PowerBI expertise in a hybrid office setting.