Lead Technical Data Analyst - Data Warehouse Services

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

Established in 2004, we are a tech pioneer offering world-class adult entertainment and games on some of the internet’s safest and most popular platforms. With the support of an international team of dynamic and collaborative innovators, we are on a mission to enable safe user experiences and empower our communities by celebrating diversity, inclusion, and expression — all while maintaining robust trust-and-safety protocols.

We embrace the best of both worlds! Local talent can thrive in our collaborative office space with the flexibility of a hybrid work environment, while remote team members play an integral role in shaping our dynamic culture from afar. We have offices in Montreal (Quebec), Austin (Texas) and Nicosia (Cyprus).

A select number of positions require full-time in office attendance*

The Data Warehouse Services team plays a vital role in our organization. They are responsible for storing vast quantities of data from many sources and responsible for disseminating data across the organizations to various different groups. They are one of the backbones of data at our organization and they are seeking a Team Lead Data Analyst to join their team.

What you'll be doing:

• Participate in leadership of a team of analysts
• Work with internal stakeholders including; Directors, Analysts, and Developers to understand business requirements/goals, and help capture the strategy, content, and features for layout of our reporting environments.
• Analyze data and structure from data marts
• Participate in brainstorming sessions regarding functional requirements, content organization, process flow, and report specifications.
• Develop queries for investigation of data issues or creation of new report structures for business units.
• Partner with Database administrators and developers to establish high-level time and effort estimates based on client requirements during report project kickoffs, and then refining the estimate during each iteration.
• Collaborate with Project Managers to identify project status, potential risks and issues.
• Become a subject area expert
• Assist in the coordination of development roadmaps

What you'll need to be successful:

Must Haves:

• 4+ years of experience in a similar technical analytical role
• 2+ years of leadership experience
• Bachelor’s degree in Computer science, Mathematics, or other relevant degree
• Knowledge of tools to create, extract, and analyze from SQL Server / Excel / PowerBI / Fabric / Cubes.
• Strong technical skills in TSQL, SQL, Mysql and Azure
• Analytical and problem solving skills.
• Strong customer support experience.
• Understanding Data flow Concepts.
• Understanding Business Model Concepts.

As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all employees

In this role you may be exposed to adult content