Technical Data Analyst - Data Warehouse Services

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

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 organization to various different groups. They are one of the backbones of data at our organization and they are seeking a Senior Data Analyst to join their team.

What you'll be doing:

• Collaborate with internal stakeholders including; 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.

What you'll need to be successful:

Must Haves:

• 5+ years of experience in a similar role.
• Knowledge of tools to create, extract, and analyze from SQL Server / Excel / PowerBI / Fabric / Cubes.
• 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