Senior Data Analyst - BI, SQL & Power BI (Hybrid)

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

Job summary

Aylo Careers is seeking a Senior Data Analyst for our Data Warehouse Services team in a hybrid Montreal setting. You will store and disseminate data across org groups, enabling BI initiatives and reporting precision.

You’ll partner with Directors, Analysts, and Developers to define strategy and features for our reporting environments. Responsibilities include collaborating with business partners, analyzing data structures, and developing queries.

Qualifications

• 5+ years of experience in a similar role.
• Knowledge of SQL Server, Excel, PowerBI, Fabric, and Cubes.
• Strong customer support experience.
• Understanding data flow concepts.
• Understanding business model concepts.

Responsibilities

• Collaborate with Directors, Analysts, and Developers to define reporting objectives.
• Engage with partners to clarify data analysis needs and requirements.
• Analyze data structures from data marts to support BI initiatives.
• Thrive in a fast-paced environment with multitasking.
• Define functional requirements and map process flows for reports.
• Develop and optimize queries to investigate data issues.
• Estimate time for report projects with DBAs and Developers.
• Track project status and resolve risks with Project Managers.
• Become a subject matter expert in business domains and reporting tools.
• Coordinate development roadmaps to align with goals.

Skills

Analytical thinking

Data storytelling

Stakeholder communication

Tools

SQL Server

Excel

PowerBI

Fabric

Cubes

Job description

Aylo Careers is seeking a Senior Data Analyst for our Data Warehouse Services team in a hybrid Montreal setting. You will store and disseminate data across org groups, enabling BI initiatives and reporting precision.

You’ll partner with Directors, Analysts, and Developers to define strategy and features for our reporting environments. Responsibilities include collaborating with business partners, analyzing data structures, and developing queries.