Technical Data Analyst - Data Warehouse Services

JobsCloseBy Editorial Insights

Aylo is seeking a Senior Data Analyst to join its Data Warehouse Services team in Montreal with a hybrid setup, with some roles requiring full-time in-office attendance; the organization operates in adult entertainment and games and has offices in Montreal, Austin and Nicosia. You will collaborate with Directors, Analysts and Developers to shape reporting strategy, translate business needs into data requirements, analyze data structures in data marts, and develop and optimize queries while coordinating with DBAs and Project Managers. To stand out, highlight 5+ years in a similar role, expertise with SQL Server Excel Power BI Fabric Cubes, strong customer support, and a track record of turning data into actionable insights, plus comfort with rapid cross-functional environments and the 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