Report Developer - Senior

LanceSoft Inc; Toronto; On-site; CAD 85,000 - 110,000; Full time

Job summary

A leading company is seeking a Senior Report Developer based in Toronto to design and develop strategic reports and dashboards using Power BI. The candidate will utilize strong technical knowledge in T-SQL and DAX to enhance reporting processes while ensuring high data quality and facilitating knowledge transfer within the team.

Qualifications

• At least 4 years of experience in SQL query languages (T-SQL).
• At least 2 years of experience in Power BI Desktop.
• At least 2 years of experience in DAX programming.

Responsibilities

• Design and develop reports and dashboards using Power BI.
• Perform data modeling and implement functions within Power BI reports.
• Analyze data to resolve data quality issues and validate reports.

Skills

Analytical skills

Problem solving

Communication skills

Tools

Power BI Desktop

DAX programming

T-SQL

Job description

Title: Report Developer - Senior
Location: Toronto, Ontario (Onsite)
Duration: 12 Months with possible extension

Resumes Evaluation/Criteria:
Criteria 1: Technical Knowledge - 50 Points

• Experience / demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)
• Experience / demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)
• Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)

Criteria 2: Analytical and Problem Solving Skills - 30 Points

• Experience / demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment / team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)
• Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation
• Demonstrated experience working within a team environment to troubleshoot and resolve technical problems
• Ability to provide analysis, developing and implementing approved new / re-engineered business process standards.

Criteria 3: Communication Skills - 20 Points

• Oral and written communication skills, interpersonal and consultative skills, facilitation skills
• Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members
• Experience preparing documentation

Knowledge Transfer

• What needs to be KT
• All documentation relating to the technology designs and technology knowledge specific to the candidate’s assignment. All information gathered while working with vendors and internal solutions to be shared. Any best practices, work around, lessons learned must be documented
• Codes
• Scripts
• Power BI report and dashboard specifications (PBIX files)

Must haves:

• Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]
• Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]
• Demonstrated working knowledge of DAX programming (At least 2 years of experience)