IT Data Analyst

IT Data Analyst

Location : Montréal, Quebec (Onsite)

Type : Full-time

Roles and Responsibilities

• Collaborate in the execution of developing IT projects.
• Implement and continuously enhance BI processes to align with business needs and industry best practices.
• Rigorously monitor and improve procedures and processes to optimize the quality of the services offered.
• Ensure the creation and development of an internal knowledge base (including documentation).
• Write complex SQL queries or use Python / R to extract, transform, analyze, and structure data efficiently from multiple sources.
• Create and maintain comprehensive cloud solutions utilizing key components for data integration, management, and transformation.
• Collect, process, and analyze data in collaboration with stakeholders to produce business analyses, recommendations, actionable insights, and support decision-making.
• Design and implement data models, including star schemas and semantic models, to enhance reporting and analytics.
• Utilize M and DAX languages to develop, maintain, and optimize Power BI dashboards and reports.

Qualifications and Education Requirements

• University degree in IT, statistics, finance, accounting, or related field with experience.
• At least 8 to 12 years of relevant experience.

Technical Knowledge

• Excellent knowledge of SQL and database management systems.
• Good knowledge of Python / R.
• Previous experience with cloud platforms (Azure / Fabric).
• Good knowledge of data security best practices.
• Strong analytical skills and mastery of data analysis.
• Attention to detail, solution-oriented, customer-focused, and quality-driven.
• Expertise in developing content in Power BI, actively using M and DAX.
• Advanced expertise in dimensional data models, database design and development, data mining, segmentation techniques, data warehouses, batch processing, and reporting techniques.
• Good knowledge of development concepts and methodologies.

Other Requirements

• Ability to work independently while being a team player.
• Excellent oral and written communication skills.
• Bilingual (French-English).
• Exceptional perseverance in finding technical means to carry out projects and tasks.
• Excellent time management skills and ability to prioritize work while meeting deadlines under pressure (stress tolerance).