Lead Technical Data Analyst - Data Warehouse Services

Aylo Careers

Apply to this job
Montréal, Quebec Until 9/12/2026 4+ years exp H-1B sponsor history First posted July 14, 2026 Last posted July 14, 2026
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 

 

About this role

Summary

Lead and analyze data, collaborate on reporting, and manage a team in data warehouse projects.

Job title

Lead Technical Data Analyst - Data Warehouse Services

Experience level

4+ years

Minimum experience

4+ years exp

Industry

software

Location requirements

Hybrid role in Montréal, remote options available

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

Yes

Skills & keywords

Required skills

TSQLSQLMysqlAzuredata flow

Preferred skills

None specified

Specializations

data warehouseSQL ServerPowerBIAzuredata analysis
Locations

Structured locations inferred from the posting.

Montreal, QC, Canada

Hybrid City
Related searches