- Salary
- $100 – $105
- Location
- Toronto
- Workplace
- Hybrid, Onsite
- Type
- Contract
- Department
- IT
- Seniority
- Senior
- Source
- PCRecruiter
Description
Senior BI Developer-Data Analyst #109752
Request ID: 109752-1
Start/End Dates: 12/7/2026 - 6/7/2027
Work Location: downtown Toronto, near TTC and GO
Job Title: IT - Senior BI Developer/ Data Analyst
Job Title: Senior BI Developer/ Data Analyst
Line of Business: Risk Intelligence Office
Target rate range: $100-105hr B2B
Target Start Date: First week of December
Duration: 6 months
Potential for this contract to be extended or converted to FTE? Extension YES - FTE: No
Hybrid work - in office on Monday and 1st Friday / month - NOTE: potential for the requirement to increase to two in- office days per week, including a designated squad day
Office Location: 81 Bay St Toronto
Work Schedule (hours per week, start time): 37.5 Hours/week, 9-5 Monday to Friday
Potential for OT? NO
What does the LOB do?: The team supports business intelligence, data reporting, and analytics requirements by developing and maintaining reporting solutions, validating data, and integrating information from multiple sources into the central reporting platform.
Reason the role is open? The MPL Strategic project is changing how its back-end data is sourced and structured. These changes will affect existing reporting, creating a need for a dedicated Senior BI Developer to support the resulting report development, remediation, data mapping, validation, and integration work.
What project will this contractor be working on? The project involves changes to back-end data sources and structures that will affect existing reports. The contractor will update and develop Power BI reporting solutions, write data transformation mappings, validate data through advanced SQL, and support the integration of information into the central reporting platform, RDAL.
Team Size? 10 people
Highlights of the role; why would someone choose this role over another? Opportunity to support a visible strategic data and reporting transformation initiative. Hands-on ownership of complex Power BI paginated reports and interactive dashboards. Exposure to end-to-end BI delivery, including requirements, development, testing, deployment, and stakeholder sign-off. Opportunity to solve complex reporting issues created by changes to enterprise data sources and structures. Close collaboration with technology partners, project leadership, and data stakeholders. Strong potential for extension based on the duration and evolving needs of the project.
Who Will the Candidate Be Working with on a Daily Basis? The contractor will work with an approximately 10-person project team, including the Hiring Manager, BI team members, project management, technology partners responsible for data modelling and integration, data specialists, and business stakeholders.
Job Description:
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 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:
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.
Soft Skills:
Strong analytical and problem-solving skills.
High attention to detail, particularly when developing pixel-perfect 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.
NOTE
Close on Nov 11 at 1pm
G.G. Consulting Group uses advanced ATS systems to track and manage candidates and jobs. We do not use AI tools for candidate screening.
Request ID: 109752-1
Start/End Dates: 12/7/2026 - 6/7/2027
Work Location: downtown Toronto, near TTC and GO
Job Title: IT - Senior BI Developer/ Data Analyst
Job Title: Senior BI Developer/ Data Analyst
Line of Business: Risk Intelligence Office
Target rate range: $100-105hr B2B
Target Start Date: First week of December
Duration: 6 months
Potential for this contract to be extended or converted to FTE? Extension YES - FTE: No
Hybrid work - in office on Monday and 1st Friday / month - NOTE: potential for the requirement to increase to two in- office days per week, including a designated squad day
Office Location: 81 Bay St Toronto
Work Schedule (hours per week, start time): 37.5 Hours/week, 9-5 Monday to Friday
Potential for OT? NO
What does the LOB do?: The team supports business intelligence, data reporting, and analytics requirements by developing and maintaining reporting solutions, validating data, and integrating information from multiple sources into the central reporting platform.
Reason the role is open? The MPL Strategic project is changing how its back-end data is sourced and structured. These changes will affect existing reporting, creating a need for a dedicated Senior BI Developer to support the resulting report development, remediation, data mapping, validation, and integration work.
What project will this contractor be working on? The project involves changes to back-end data sources and structures that will affect existing reports. The contractor will update and develop Power BI reporting solutions, write data transformation mappings, validate data through advanced SQL, and support the integration of information into the central reporting platform, RDAL.
Team Size? 10 people
Highlights of the role; why would someone choose this role over another? Opportunity to support a visible strategic data and reporting transformation initiative. Hands-on ownership of complex Power BI paginated reports and interactive dashboards. Exposure to end-to-end BI delivery, including requirements, development, testing, deployment, and stakeholder sign-off. Opportunity to solve complex reporting issues created by changes to enterprise data sources and structures. Close collaboration with technology partners, project leadership, and data stakeholders. Strong potential for extension based on the duration and evolving needs of the project.
Who Will the Candidate Be Working with on a Daily Basis? The contractor will work with an approximately 10-person project team, including the Hiring Manager, BI team members, project management, technology partners responsible for data modelling and integration, data specialists, and business stakeholders.
Job Description:
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 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:
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.
Soft Skills:
Strong analytical and problem-solving skills.
High attention to detail, particularly when developing pixel-perfect 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.
NOTE
Close on Nov 11 at 1pm
G.G. Consulting Group uses advanced ATS systems to track and manage candidates and jobs. We do not use AI tools for candidate screening.
Skills
PythonSQLETLPower BIProject Management