Lead Technical Data Analyst - Data Warehouse Services

Aylo; Montreal (administrative region); Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Aylo in Montreal, Canada, is seeking a Team Lead Data Analyst to guide a group of analysts within the Data Warehouse Services team. The role blends leadership with hands-on data analysis across data marts and reporting environments.

You’ll collaborate with Directors, Analysts, and Developers to translate business requirements into actionable reporting, develop queries, and help shape development roadmaps while maintaining Aylo’s trust-and-safety standards.

Qualifications

• 4+ years in a technical analytical role.
• 2+ years of leadership experience.
• Bachelor’s degree in Computer Science, Mathematics, or related.
• Proficient with SQL Server, Excel, PowerBI, Fabric, Cubes.

Responsibilities

• Lead a team of analysts.
• Collaborate with Directors, Analysts, and Developers to capture business requirements and reporting layouts.
• Analyze data and structures from data marts.
• Contribute to report specifications and content organization.
• Develop queries for data issues and new reports for business units.
• Partner with DBAs and developers to estimate effort for report projects.
• Coordinate with Project Managers to identify risks and status.
• Become a subject area expert and assist in roadmap planning.

Skills

Analytical thinking

Leadership

Customer support

Problem solving

Communication

Education

Bachelor’s degree in CS/Math or related field

Tools

SQL Server

Excel

PowerBI

Fabric

Cubes

MySQL

Azure

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