IT Analyst (Data Engineering and Analytics (BI))

YOUR CAREER AT ÉTS

École de technologie supérieure is a constituent of the Université du Québec network. Specialized in applied teaching and research in engineering and technology transfer, it trains engineers and researchers recognized for their practical and innovative approach. Ideally located in the Griffintown district at the intersection of Old Montreal and downtown, ÉTS is a short walk from Lucien-Lallier and Bonaventure metro stations.

At ÉTS, the work environment reflects the educational experience we offer to our 11,000 students: collaborative, inclusive, accessible, and human-scale!

Want to learn more about what ÉTS offers? Discover all our benefits and working conditions here: Benefits of working at ÉTS.

Join a community that, within a creative and agile organization, contributes daily to training more than a quarter of Quebec's engineers!

The job title listed in the collective agreement is: IT Analyst. To access a brief description of the tasks, click here.

YOUR BENEFITS COMPETITIVE SALARY 22 DAYS OF VACATION SUMMER HOURS | 4 DAYS PER WEEK GROUP INSURANCE | RETIREMENT PLAN WORK-LIFE BALANCE ON-SITE SPORTS CENTER TELEMEDICINE SERVICE 3 MONTHS FREE SUSTAINABLE MOBILITY 15 DAYS OF PUBLIC HOLIDAYS EXCLUSIVE DISCOUNTS AND MUCH MORE...

YOUR ROLE

What if your expertise in data engineering and analytics could make critical information accessible and exploitable within an innovative and growing School?

By joining ÉTS, you will integrate the IT Project Management and Data Governance Office team. This team develops and evolves the institutional data architecture as well as business intelligence services to support the School's teaching, research, and administrative activities.

What will be your impact as an IT Analyst in Data Engineering and Analytics (BI) at ÉTS?

You will contribute to the implementation of the School's statistical portrait of teaching, research, and administrative activities as well as the realization of projects requiring fine data analysis.

Your work will notably feed data warehouses, data marts, and dashboards used by different units of ÉTS in the context of strategic and operational decisions.

On a daily basis, you will

• Collaborate with architects, programmers, analysts, and project managers in the realization of deliverables related to data organization, operation, and protection.
• Develop and maintain ETL workflows in SQL Server Integration Services (SSIS).
• Analyze and develop complex SQL analysis and data profiling queries.
• Optimize the performance of ETL processes, SQL queries, and analytical models.
• Perform technical analyses and develop analytical models for data processing and exploitation.
• Ensure the maintenance and integrity of data warehouses and participate in their creation and evolution.
• Participate in deployment activities, including development, testing, production deployment, and version management.
• Analyze the impacts on existing systems during change requests.
• Analyze data statistical requests describing the School's activities and establish database query strategies to respond to them.
• Collaborate in the establishment of guidelines, registers, and technical documentation governing data organization and security practices.
• Assess data security risks and may be required to write reports describing certain risks or events (e.g., personal information protection, etc.).
• Maintain a watch on new trends and best practices in the industry and market in terms of data engineering, operation, and protection, and analyze their potential impacts on the organization.
• Participate in the creation and maintenance of Power BI reports.
• DO YOU HAVE WHAT IT TAKES TO MEET THE CHALLENGE?

Education

• You have a bachelor's degree in computer science or any other appropriate discipline.

Experience

• You have a minimum of three (3) years of experience, particularly as a BI developer on SSIS (SQL Server Integration Services).
• You can identify data processing mechanisms that reduce risks and promote data protection.
• You have complementary expertise in BI technologies (Tableau and MS SSAS Tabular and cube, Power BI including DAX, MDS and DQS, GitLab).
• You have experience with Microsoft Fabric or another modern cloud data platform (asset).
• You have knowledge in data modeling (asset).
• You have experience with Azure Data Factory (asset).
• You have knowledge of government information that frames the protection of personal information (asset).
• You are familiar with the domain of higher education (an asset).
• YOU WILL SUCCEED IF YOU HAVE:

Specific Skills

• You have technical expertise in BI development, particularly with SQL, ETL processes, and SSIS, and are able to translate business rules into reliable computer processes.
• You demonstrate rigor and precision in the execution of your work. You adopt a systematic approach to ensure the production of expected results.
• You gather and examine detailed information, then integrate and deepen your understanding of facts and situations.
• You contribute to achieving common goals through your team spirit and ability to work cooperatively with your colleagues.
• You communicate clearly and are able to explain complex technical concepts to non-specialized internal colleagues and clients.

Other Skills

• You demonstrate autonomy, proactivity, and initiative, even when needs or context are not fully defined.
• You are a force of proposal in the search for solutions and in the evolution of the BI ecosystem.
• You attach great importance to customer satisfaction and seek to respond effectively to their needs.
• You demonstrate discretion and judgment in the handling of sensitive data and personal information.
• You establish realistic priorities and transform goals into concrete action plans with timelines.
• You have excellent mastery of the French language, both spoken and written.
• Given the nature of the tasks, the person may be called upon to use spoken and written English occasionally in the performance of their duties.
• Do you have the profile we are looking for to join this team?

Please note that selected candidates will be invited to a virtual interview, which will take place on October 5 or 6, 2026. As part of this interview, they will need to present a technical presentation in line with the job requirements.

We invite you to apply and Diana Oliveros, talent acquisition advisor, will be happy to tell you more about the position and our working conditions during an interview.

Applying to ÉTS, what a brilliant idea!