BI Reporting Analyst (Contract)

Black & McDonald; Markham; On-site; CAD 60,000 - 90,000; Full time

Job summary

An innovative firm is looking for a detail-oriented BI Reporting Analyst to join their team. This role involves designing and maintaining impactful reports using SSRS and Power BI, while also writing complex SQL queries to extract and present data. As part of a migration project, you'll collaborate with business users to ensure data accuracy and integrity. If you have a strong analytical mindset and excellent communication skills, this opportunity offers a chance to make a significant impact in a dynamic environment. Immediate start is preferred for candidates ready to contribute right away.

Qualifications

• Strong SQL skills with the ability to write and optimize queries.
• Experience in SSRS and Power BI Report Builder for report design.

Responsibilities

• Participate in migrating JDE Reports to Power BI.
• Design and maintain reports using SSRS and Power BI.
• Write complex SQL queries for data extraction.

Skills

SQL

SSRS

Power BI Report Builder

Analytical Skills

Communication Skills

Tools

SQL Server Reporting Services

Power BI

Data Access Studio

Job description

Job Title: BI Reporting Analyst (Contract )
Location: CVD
Contract Type: Contract (Immediate Start)
Duration: 4 months, with possibility of extension
Start Date: ASAP

Job Overview:
We are seeking a BI Reporting Analyst with strong SQL skills and hands-on experience in SSRS and Power BI Report Builder. This role is ideal for a detail-oriented analyst who can quickly interpret business needs and deliver accurate, impactful reports.

Key Responsibilities:

• Participate in the migration project of JDE Reports Now reports to Power BI
• Design, develop, and maintain reports using SSRS and Power BI Report Builder
• Write complex SQL queries for data extraction, transformation, and presentation
• Collaborate with business users to understand and refine reporting requirements
• Ensure accuracy, consistency, and integrity of data across all reports
• Troubleshoot and optimize existing reports and queries

Requirements:

• Strong SQL skills with demonstrated ability to write and optimize queries
• Experience with SQL Server Reporting Services (SSRS)
• Proficiency in Power BI Report Builder (Paginated Reports)
• Strong analytical skills and keen attention to detail
• Excellent communication skills and ability to work independently

Preferred Qualifications:

• Familiarity with JDE (JD Edwards) tables
• Experience with DAS (Data Access Studio) tool

Contract Details:

• Immediate start; candidates available to begin right away are highly preferred

Black & McDonald welcomes and encourages applications from persons with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the recruitment and selection process.