Technical Data Analyst - Data Warehouse Services

JobsCloseBy Editorial Insights

Aylo seeks a Senior Data Analyst for its Data Warehouse Services team in Montréal, a full-time onsite role. You’ll partner with Directors and Analysts to define reporting strategy, engage business partners, and analyze data structures from data marts for BI initiatives. Develop and optimize queries, estimate effort with DBAs, coordinate with Project Managers, and become a domain expert for reporting. Must have 5+ years in a similar role and strong SQL Server, Excel, PowerBI, Fabric and Cubes skills, plus solid customer support and understanding of data flow and business models. Provide concrete examples of stakeholder collaboration and BI impact; note hybrid/onsite flexibility and potential exposure to adult content.

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