Data Analyst

Source2Hunt LLC; Montreal; On-site; CAD 70,000 - 100,000; Full time

Job summary

A leading IT consultancy in Montreal is seeking an experienced IT Data Analyst. The role involves developing IT projects, enhancing BI processes, and utilizing SQL and Power BI for data analysis. Candidates should have a university degree and 8-12 years of relevant experience, plus strong analytical skills and a customer-focused approach. Bilingual candidates are preferred.

Qualifications

• At least 8 to 12 years of relevant experience.
• Excellent knowledge of SQL and database management systems.
• Good knowledge of development concepts and methodologies.

Responsibilities

• Collaborate in the execution of developing IT projects.
• Implement and enhance BI processes to align with needs.
• Design and implement data models for reporting.

Skills

SQL

Python

R

Power BI

Data Analysis

Cloud platforms

Bilingual (French-English)

Education

University degree in IT, statistics, finance, accounting, or related field

Tools

Power BI

Azure

Job description

Job title: 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).