Lead Technical Data Analyst - Data Warehouse Services
Aylo Careers Open At a glance
Senior Data Analysis & BI role at Aylo Careers. Montréal · no salary stated · we estimate CA$100,000–CA$129,500 across Canada.
Aylo Careers has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Help lead analysts while shaping reporting environments with directors, analysts and developers around business needs
- Examine data marts and turn stakeholder discussions into reporting layouts, content plans and functional requirements
- Write queries to investigate data problems and build report structures for business teams
- Work with database administrators and developers to estimate report projects, then refine those estimates as work progresses
- Track project risks and status with project managers, build subject-area expertise and help coordinate development roadmaps
What you bring
- At least four years in a comparable technical analysis role, with two years or more leading work
- A bachelor’s degree in computer science, mathematics or another relevant field
- Experience with SQL Server, Excel, Power BI, Fabric or cubes, plus strong T-SQL, SQL, MySQL and Azure skills
- Strong analytical problem-solving ability, customer support experience and understanding of data flow and business models
Who this fits
This senior role suits someone who combines hands-on technical analysis with team leadership and stakeholder collaboration. The position is based in Montréal, and you may encounter adult content.
From the employer
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
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.