Banking Power BI Lead: Paginated Reports & Dashboards

BeachHead Inc.; Toronto; On-site; CAD 110,000 - 140,000; Full time

Job summary

BeachHead Inc. in Toronto, Canada seeks a Senior Power BI Developer to lead complex reporting projects for a banking client.

You will own paginated reports, interactive dashboards, data validation, mapping, and remediation, partnering with business stakeholders and technology teams across the BI delivery life cycle. You will design and deploy reports, optimize performance, and ensure data quality while supporting cross-source integration and documentation.

Qualifications

• Seven to ten years of hands-on business intelligence development experience.
• Advanced Power BI development experience, including dashboards and reports.
• Advanced Power BI Report Builder and paginated reporting experience.
• Expertise with complex parameters, grouping, page breaks, visibility rules, RDL expressions, scope arguments, and pixel-perfect formatting.
• Advanced SQL skills covering data extraction, transformation validation, reconciliation and troubleshooting.
• Advanced DAX and Power Query experience.
• Experience deploying and managing reports in Power BI Service, including gateway configuration and performance troubleshooting.
• Demonstrated understanding of data models, ETL concepts, and data transformation logic.
• Strong analytical and problem-solving abilities with attention to detail.
• Excellent written and verbal communication, and strong documentation skills.

Responsibilities

• Design and develop complex static, pixel-perfect, and paginated reports using Power BI Report Builder.
• Build interactive Power BI dashboards using advanced reporting functionality.
• Implement cascading report parameters connected to source SQL queries.
• Configure report grouping, repeating sections, page breaks, and visibility controls.
• Create custom RDL expressions, including expressions using scope arguments.
• Deploy and manage paginated reports in Power BI Service with gateway setup.
• Optimize paginated report performance and troubleshoot reporting issues.
• Develop advanced SQL queries for data extraction, transformation, validation, reconciliation, and reporting support.
• Create advanced DAX calculations and Power Query transformations.
• Lead reporting deliverables from requirements gathering through design, development, testing, deployment and stakeholder approval.
• Support the integration of information from multiple sources into a central reporting platform.
• Prepare and maintain data mapping documentation covering transformation logic, source-to-target relationships, calculations, and reporting definitions.
• Review data models and transformation requirements to ensure reporting solutions align with specifications.
• Validate transformation mappings and reporting outputs using SQL.
• Maintain data quality, integrity, accuracy, and consistency across reporting deliverables.
• Investigate data discrepancies and resolve reporting issues with stakeholders.

Skills

Power BI development

Power BI Report Builder

DAX

Power Query

SQL

Paginated reports

Tools

Power BI Service

Gateway configuration

SQL querying

Job description

BeachHead Inc. in Toronto, Canada seeks a Senior Power BI Developer to lead complex reporting projects for a banking client.

You will own paginated reports, interactive dashboards, data validation, mapping, and remediation, partnering with business stakeholders and technology teams across the BI delivery life cycle. You will design and deploy reports, optimize performance, and ensure data quality while supporting cross-source integration and documentation.