Sr. PowerBI Developer-Banking
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Working with one of our top financial clients, this role calls for a Sr. PowerBI Developer-Banking to support a strategic data and reporting transformation initiative. You will take ownership of complex Power BI paginated reports, interactive dashboards, data validation, mapping, and reporting remediation while partnering with business stakeholders, project leadership, technology teams, and data specialists. This opportunity offers hands-on exposure to the full business intelligence delivery lifecycle, including requirements gathering, design, development, testing, deployment, troubleshooting, and stakeholder sign-off, with strong potential for continued project involvement.
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, including gateway assignment and configuration.
- Optimise 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 documented 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 in collaboration with business and technical stakeholders.
- Collaborate with data modelling and ETL teams while supporting reporting requirements without directly developing data models or ETL pipelines.
- Seven to ten years of hands-on business intelligence development experience, including responsibility for complex enterprise reporting solutions.
- Advanced Power BI development experience, including interactive 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 complex queries, data extraction, transformation validation, reconciliation, troubleshooting, and reporting.
- 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.
- Exceptional attention to detail when developing reports and validating data.
- Clear written and verbal communication skills.
- Ability to translate business reporting requirements into technical reporting solutions.
- Strong documentation skills, particularly for data mappings, transformation rules, and reporting definitions.
- Ability to work independently and take ownership of deliverables.
- Collaborative approach when working with business stakeholders, project managers, technology partners, and data teams.
- Experience supporting enterprise-scale data or reporting transformation initiatives.
- Experience integrating reporting data from multiple source systems.
- Experience working with centralised reporting or analytical data platforms.
- 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.
Privacy Policy
More about this job
Responsibilities
Design, develop, deploy, and troubleshoot complex paginated reports and interactive Power BI dashboards, using SQL, DAX, and Power Query to support reporting and data validation. Lead reporting deliverables from requirements gathering through stakeholder approval, maintain data mapping and quality documentation, and collaborate with business, technology, data modelling, and ETL teams.
Requirements
Requires 7–10 years of hands-on business intelligence development experience, including advanced Power BI, paginated reporting, SQL, DAX, and Power Query skills. Candidates should understand data models and ETL concepts and demonstrate strong analytical, communication, documentation, and stakeholder collaboration abilities.
Skills
- Power BI
- Power BI Report Builder
- Paginated Reporting
- SQL
- DAX
- Power Query
- RDL Expressions
- Data Validation
- Data Mapping
- Data Reconciliation
- Report Performance Optimization
- Power BI Service
- Gateway Configuration
- Data Transformation
- Stakeholder Communication
- Reporting Documentation
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Finance & Accounting
Keywords
- Power BI
- Power BI Report Builder
- Power BI Service
- Paginated Reports
- Interactive Dashboards
- SQL
- DAX
- Power Query
- RDL Expressions
- Cascading Parameters
- Data Transformation
- Data Validation
- Data Reconciliation
- Data Mapping
- Data Quality
- Data Integrity
- Data Models
- ETL
- Gateway Configuration
- Performance Optimization
- Reporting Remediation
- Central Reporting Platform
- Business Intelligence
- Financial Services
- Data Governance
- Requirements Gathering
- Stakeholder Sign-Off
- Source-to-Target Mapping