SQL Data Analyst and Reporting Developer

Compunnel Inc.; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A technology solutions provider in Montreal is seeking a SQL Data Analyst and Reporting Developer to design and maintain data reports and visualizations using SQL and Power BI. The ideal candidate has a Bachelor's degree in a related field and proven experience in developing BI solutions in a dynamic financial technology environment. Strong collaboration skills and experience with Python and ETL processes are required.

Qualifications

• Strong proficiency in SQL and database design, particularly within Microsoft SQL Server (T-SQL).
• Hands-on experience developing in Power BI, including data modeling and DAX.
• Familiarity with ETL tools and processes such as SSIS.

Responsibilities

• Design, develop, and maintain dashboards and visualizations in Power BI using SQL data sources.
• Build and manage OLAP Cubes and Excel reports leveraging Power Query, Power Pivot, and DAX functions.
• Collaborate with cross-functional teams to deliver high-quality reporting solutions.

Skills

SQL proficiency

Power BI development

Python for data manipulation

Data warehousing concepts

OLAP reporting services

PowerShell scripting

ETL processes with SSIS

DAX functions

Education

Bachelor's degree in computer science, Information Technology, Data Analytics, or a related field

Tools

SQL Server

Power BI

SSIS

Splunk

Salesforce Tableau

Job description

SQL Data Analyst and Reporting Developer

11/03/2025

Contract

Active

Job Description:

Job Summary:

The SQL Data Analyst and Reporting Developer will play a key role in designing, developing, and maintaining advanced data reports, dashboards, and visualizations to support modernization projects across Mobile and Desktop platforms. The primary data source will be the Power BI platform. This position requires strong technical expertise in SQL, Power BI, and data analytics, along with the ability to collaborate across teams in a dynamic and global financial technology environment.

Key Responsibilities:

• Design, develop, and maintain dashboards and visualizations in Power BI using SQL data sources.
• Build and manage OLAP Cubes and Excel reports leveraging Power Query, Power Pivot, and DAX functions.
• Develop ETL processes using APIs, SSIS, and Python to ensure efficient data flow and integration.
• Collaborate with cross-functional business and technology teams to deliver timely, high-quality reporting solutions.
• Support data analysis, troubleshooting, and optimization to ensure data accuracy and performance.
• Maintain system documentation and contribute to knowledge-sharing initiatives.

Required Skills:

• Strong proficiency in SQL and database design, particularly within Microsoft SQL Server (T-SQL).
• Solid understanding of data warehousing concepts and OLAP reporting services.
• Hands-on experience developing in Power BI, including data modeling and DAX.
• Proficiency in Python for data manipulation and automation.
• Familiarity with ETL tools and processes such as SSIS.
• Knowledge of PowerShell scripting for task automation.
• Understanding of Splunk for data monitoring and analysis (preferred).

Preferred Skills:

• Experience with Salesforce Tableau for data visualization.
• Strong analytical and problem-solving capabilities.
• Ability to work in a fast-paced, global, and collaborative environment.

Education:

Bachelor’s degree in computer science, Information Technology, Data Analytics, or a related field.

Experience:

Proven experience as a SQL Developer, Data Analyst, or Reporting Developer in a professional environment.

Demonstrated experience in building BI dashboards and managing large datasets.