Senior BI Developer/ Data Analyst

Raise; Toronto; Hybrid; CAD 129,000 - 149,000; Full time

Job summary

Raise is hiring a Senior BI Developer/ Data Analyst for a top client in Toronto. You will design and implement Power BI reports and dashboards, optimize data models, and partner with stakeholders to translate requirements into scalable analytics solutions.

Responsibilities include building paginated reports with Power BI Report Builder, writing advanced SQL, DAX, and M queries, validating data quality, and leading BI delivery from requirements to sign-off in a hybrid environment.

Qualifications

• 7-10 years hands-on BI development experience with complex enterprise reports.
• Advanced Power BI development for interactive dashboards and reports.
• Advanced experience with Power BI Report Builder and paginated reports.

Responsibilities

• Design and develop complex Power BI reports and dashboards.
• Implement cascading report parameters mapped to source SQL queries.
• Define report grouping, page breaks, and visibility rules.
• Create pixel-perfect report layouts and RDL expressions.
• Manage paginated reports in Power BI Service and tune performance.
• Develop advanced SQL, DAX, and Power Query transformations.

Skills

Power BI development

Advanced SQL

DAX

Power Query

Paginated reports

Data modeling

Stakeholder collaboration

Tools

RDAL

Job description

• Location: Toronto, ON - Hybrid (Monday First Friday)
• Pay Rate: $93.63/hr - $108.22/hr
• Contract Length: 6 Months with possibility for extension

We at Raise are hiring a Senior BI Developer/ Data Analyst for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand.

Responsibilities

• Design and develop complex static and paginated reports using Power BI Report Builder.
• Develop interactive Power BI dashboards using advanced Power BI functionality.
• Implement cascading report parameters mapped to source SQL queries.
• Define report grouping, repeating sections, page breaks, and visibility-control properties.
• Design precise, pixel-perfect report layouts.
• Create custom RDL expressions, including expressions that use scope arguments.
• Manage paginated reports in Power BI Service, including gateway assignment and configuration.
• Tune the performance of paginated reports and troubleshoot reporting issues.
• Use advanced SQL for data extraction, transformation, validation, reconciliation, and reporting support.
• Develop advanced DAX calculations and Power Query transformations.
• Lead BI delivery from requirements gathering through design, development, testing, deployment, and stakeholder sign-off.
• Collaborate with technology partners to integrate information from multiple sources into the central reporting platform, RDAL.
• Create and maintain mapping documents that define data transformation logic, source-to-target relationships, calculations, and reporting definitions.
• Review data models and transformation requirements to ensure reporting solutions are developed correctly.
• Use SQL to validate transformation mappings and confirm that reporting outputs align with documented requirements.
• Maintain strong data quality, integrity, accuracy, and consistency across all reporting outputs.
• Work closely with business and technical stakeholders to investigate data discrepancies and resolve reporting issues.

Must Have Requirement

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

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

Looking for meaningful work? We can help!

Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.

We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.

We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/

In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at [phone] or [e-mail]