Senior Report Developer

Cynet Systems Inc; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading company seeks a Business Intelligence Analyst to leverage Power BI for report migration and development. The role requires strong SQL and DAX proficiency, as well as analytical problem-solving skills to ensure report accuracy and adherence to standards. This position offers opportunities to contribute to significant technical projects within a collaborative team environment.

Qualifications

• At least 2 years of experience with Power BI Desktop.
• At least 4 years of experience with SQL query languages.
• At least 2 years of experience with DAX programming.

Responsibilities

• Migrate operational reports to Power BI following Government Standards.
• Troubleshoot issues with reports and dashboards during testing.
• Collaborate with project teams for documentation and knowledge transfer.

Skills

Power BI

SQL

DAX

Data Validation

Analytical Skills

Tools

Azure Data Factory

Microsoft SQL Server

Job description

Job Description:

Assignment Deliverables:

• Participate in reporting needs assessment to understand the functionality and design of the current operational reports in use.
• Perform assessment, and define approach in collaboration with project team and stakeholder to migrate operational reports to appropriate CDT solution standard reporting features or to a Power BI tool (i.e., Desktop or Report Builder).
• Perform design and development activities to migrate operational reports to Power BI in alignment with Government Standards and Guidelines (i.e., AODA, WCAG 2.0 Level AA).
• Perform troubleshooting and apply corrective actions to resolve issues with migrated reports and dashboards discovered during pre-release testing.
• Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer.
• Participate in knowledge transfer activities.

Experience and Skillset Requirements:
Mandatory Requirements:

• 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).

Desired Skills and Experience:

• Technical skills and expertise to design and develop in Jasper Report Tool.
• Experience working in a business intelligence team/ environment, developing, and delivering business intelligence and/or analytical reports and dashboards.
• Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports.
• Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports.
• Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.
• Knowledge of Microsoft SQL Server.
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.

Resumes Evaluation/Criteria:
Technical Knowledge:

• 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).

Analytical and Problem Solving Skills:

• 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.

Communication Skills:

• 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.