Senior Data Analyst, Data Warehouse & BI (Hybrid/Remote)

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

Benefits offered by this job

Hybrid work model

Office in Montreal

Job summary

Aylo in Montreal is seeking a Senior Data Analyst to join the Data Warehouse Services team. They store and disseminate data across groups, supporting reporting environments and BI initiatives in a fast-paced, collaborative setting.

This role combines in-office attendance with hybrid flexibility across our Montreal, Austin, and Nicosia offices. You will partner with Directors, Analysts, and Developers to translate business needs into dashboards using SQL Server, Excel, Power BI, Fabric, and Cubes.

Qualifications

• 5+ years of experience in a similar role.
• Knowledge of SQL Server / Excel / PowerBI / Fabric / Cubes.
• Strong customer support experience.
• Understanding Data flow Concepts.
• Understanding Business Model Concepts.

Responsibilities

• Collaborate with Directors, Analysts, and Developers to understand business objectives and requirements, and help define the strategy, content, and features for our reporting environments.
• Engage with business partners at all levels to discuss and clarify data analysis, needs and requirements.
• Analyze data structures and content from data marts to support business intelligence initiatives.
• Thrive in a fast-paced environment, where multitasking and adaptability are essential.
• Participate in brainstorming sessions to define functional requirements, organize content, map process flows, and specify report features.
• Develop and optimize queries to investigate data issues or new reporting structures for various business units.
• Work closely with Database Administrators and Developers to estimate time and effort for report projects and refining these estimates throughout the project.
• Collaborate with Project Managers to track project status, identify potential risks,and resolve issues as they arise.
• Become a subject matter expert in relevant business domains and reporting tools.
• Assist in coordinating and maintaining development roadmaps to ensure alignment with business goals.

Skills

5+ years experience

SQL

Excel

Power BI

Data analysis

Customer support

Data flow concepts

Business model concepts

Fabric

Cubes

Tools

SQL Server

Power BI

Fabric

Cubes

Job description

Aylo in Montreal is seeking a Senior Data Analyst to join the Data Warehouse Services team. They store and disseminate data across groups, supporting reporting environments and BI initiatives in a fast-paced, collaborative setting.

This role combines in-office attendance with hybrid flexibility across our Montreal, Austin, and Nicosia offices. You will partner with Directors, Analysts, and Developers to translate business needs into dashboards using SQL Server, Excel, Power BI, Fabric, and Cubes.