Senior BI Developer / Data Analyst (7–10 years) to deliver Power BI paginated reports and interactive dashboards using Power BI Report Builder, SQL, and DAX 109752-1

S.I. Systems Ltd.; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

S.I. Systems Ltd. is seeking a Senior BI Developer / Data Analyst in Toronto to deliver Power BI paginated reports and interactive dashboards.

Expect hands-on ownership across design, development, testing, deployment, and stakeholder sign-off, with extension potential based on project needs. The role requires 7–10 years of BI experience, expertise in Power BI Report Builder and paginated reports, SQL and DAX, and familiarity with Power BI Service governance and data modeling within a regulated

Qualifications

• 7-10 years of BI development experience required.
• Advanced Power BI development with interactive dashboards and reports.
• Advanced experience with Power BI Report Builder and paginated reports.
• Advanced SQL for data extraction, transformation, validation, reconciliation, and reporting.
• Advanced DAX and Power Query experience.
• Experience deploying and managing reports in Power BI Service, including gateways and performance troubleshooting.
• Understanding of data models, ETL concepts, and data transformation logic.

Responsibilities

• Design and develop complex static and paginated reports using Power BI Report Builder.
• Develop interactive Power BI dashboards using advanced functionality.
• Implement cascading report parameters mapped to source SQL queries.
• Create custom RDL expressions, including scope arguments.
• Manage paginated reports in Power BI Service, including gateway assignment and configuration.
• Use advanced SQL for data extraction, transformation validation, reconciliation, and reporting support.
• Create and maintain mapping documents defining data transformation logic, source-to-target relationships, calculations, and reporting definitions.

Skills

Power BI

Paginated reports

SQL

DAX

Power Query

Data modeling

ETL

Power BI Report Builder

Power BI Service

Tools

Power BI Report Builder

Job description

Senior BI Developer / Data Analyst (7–10 years) to deliver Power BI paginated reports and interactive dashboards using Power BI Report Builder, SQL, and DAX 109752-1

Our financial services client is seeking a Senior BI Developer / Data Analyst (7–10 years) to deliver Power BI paginated reports and interactive dashboards using Power BI Report Builder, SQL, and DAX

Join a strategic reporting transformation within a Risk Intelligence Office, where back-end data changes are reshaping enterprise reporting. This role updates and develops Power BI solutions, authors data transformation mappings, validates data via advanced SQL, and supports integration into the central reporting platform, RDAL. Expect hands-on ownership of complex paginated reports and interactive dashboards with end-to-end BI delivery across requirements, development, testing, deployment, and stakeholder sign-off. The engagement offers strong visibility with technology partners and stakeholders, with potential for extension based on project needs.

Contract, Hybrid MondayFirst Friday

81 Bay Street

6 months

Must Haves:

7-10 years of hands-on BI development experience, including responsibility for complex enterprise reporting solutions.

Advanced Power BI development experience, including interactive dashboards and reports.

Advanced experience with Power BI Report Builder and paginated reports, including complex parameters, grouping, page breaks, visibility rules, RDL expressions, scope arguments, and pixel-perfect formatting.

Advanced SQL skills for complex querying, data extraction, transformation validation, reconciliation, troubleshooting, and reporting.

Advanced DAX and Power Query experience.

Experience deploying and managing reports in Power BI Service, including gateways and report performance troubleshooting.

Demonstrated understanding of data models, ETL concepts, and data transformation logic.

Nice to Have:

Previous experience supporting enterprise-scale data or reporting transformation initiatives.

Experience integrating reporting data from multiple source systems.

Experience working with centralized reporting or analytical data platforms such as RDAL.

Experience in financial services or another highly governed enterprise environment.

Familiarity with data governance, controls, reconciliation, and reporting-quality practices.

• Experience working closely with separate data-modelling and ETL development teams.

Responsibilities

• Design and develop complex static and paginated reports using Power BI Report Builder
• Develop interactive Power BI dashboards using advanced functionality
• Implement cascading report parameters mapped to source SQL queries
• Create custom RDL expressions, including expressions that use scope arguments
• Manage paginated reports in Power BI Service, including gateway assignment and configuration
• Use advanced SQL for data extraction, transformation validation, reconciliation, and reporting support
• Create and maintain mapping documents defining data transformation logic, source-to-target relationships, calculations, and reporting definitions

Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.