Report Developer

Amyantek; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading company seeks a Senior Report Developer for a 7-month contract with the Ontario Public Service. The role involves migrating reports to Power BI while applying strong SQL and Power BI skills. Ideal candidates have experience in troubleshooting and report validation in a business intelligence context. The position is hybrid, requiring 3 days a week in the office.

Qualifications

• At least 2 years of experience with Power BI and DAX.
• At least 4 years of experience with SQL query languages.
• Experience in a business intelligence environment.

Responsibilities

• Migrate operational reports to Power BI.
• Perform assessment and design for report migration.
• Document processes for knowledge transfer.

Skills

Power BI

SQL

DAX

Troubleshooting

Tools

Azure Data Factory

Microsoft SQL Server

Jasper Report Tool

Job description

Direct message the job poster from Amyantek

Please send your resume at [emailprotected] if you are interested in this 07 month contract with Ontario Public Service(Ministry of Solicitor General) with a possibility of extension, If you are not interested, please feel free to pass it in your network for anyone looking for work.

Job Title : RQ07907 – Senior Report Developer - 3 Resources

Working Status : Hybrid – 3 days a week in the office

Location : 720 Bay Street, Toronto

Start Date : 2025-07-28

End Date : 2026-03-05

Must Have

• 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

Scope

• Provide planning, assessment, and development effort to complete the conversion of 100+ operational reports and dashboards from JasperReports to PowerBI
• Work with Project manager and Business Areas to evaluate and modernize reports, where applicable
• Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
• Work with Project Team to complete all relevant and required documentation, such as knowledge transfer, and communication to support the completion of the project
• 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 OPS 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

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

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Contract

Job function

Job function

Information Technology, Business Development, and Analyst

Business Consulting and Services, Government Administration, and Government Relations Services

Referrals increase your chances of interviewing at Amyantek by 2x

Sign in to set job alerts for “Report Developer” roles.

Freelance Data Analyst (Python) - AI Trainer

Business Analyst (Data, Loyalty & Insights)

Toronto, Ontario, Canada CA$90.00-CA$90.00 21 hours ago

Data Quality Analyst (Fraud Investigation)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.