BI Reporting Analyst (Contract)

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

Job summary

An established industry player is seeking a detail-oriented BI Reporting Analyst to join their team. This role involves leveraging strong SQL skills and hands-on experience with SSRS and Power BI Report Builder to create impactful reports. The successful candidate will participate in a migration project, ensuring data integrity and optimizing existing reports. If you are passionate about data analytics and looking for an immediate start, this could be the perfect opportunity for you to make a significant impact in a dynamic environment.

Qualifications

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

Responsibilities

• Participate in migrating JDE Reports to Power BI.
• Design and maintain reports using SSRS and Power BI.

Skills

SQL

SSRS

Power BI Report Builder

Analytical Skills

Communication Skills

Tools

SQL Server Reporting Services (SSRS)

Power BI Report Builder

DAS (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.