Senior BI Developer / Data Analyst - DAX and Power Query

Location: Toronto, ON

Onsite Flexibility: Hybrid - Monday and first Friday on-site

Contract Details

- Position Type: Contract
- Contract Duration: 6 months (with potential for extension)
- Pay Rate: C$85.00-C$100.00 / Hour (CAD)
- Shift / Schedule: 9:00 AM - 5:00 PM, 37.5 hours per week

Job Summary

The Senior BI Developer will design and develop complex static and paginated reports using Power BI Report Builder, along with interactive Power BI dashboards. This individual will support the MPL Strategic project, where changes to back-end data sourcing and structures are creating significant reporting impacts. The successful candidate will provide end-to-end BI development support, including requirements gathering, report design, SQL development, data transformation mapping, testing, deployment, troubleshooting, and stakeholder sign-off. The role requires advanced Power BI and SQL expertise, strong knowledge of DAX and Power Query, and an understanding of data models and ETL concepts.

The contractor will collaborate with technology and data partners who own the underlying data models and ETL implementation. While this individual will not be expected to build data models or ETL pipelines directly, they must be able to understand transformation requirements, prepare detailed data mapping documentation, and use SQL to verify that the defined mappings and transformations work correctly. Python is not required for this role.

Key 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 Requirements

- 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 Requirements

- 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 workplace.
- Familiarity with data governance, controls, reconciliation, and reporting-quality practices.
- Experience working closely with separate data-modelling and ETL development teams.

Required Skills

📌 Senior BI Developer (Toronto)
🏢 Global Technical Talent
📍 Toronto