Senior BI Developer / Data Analyst
- DAX and Power Query Hybrid
- Monday and first Friday on-siteContract Details C$85.00-C$100.00 / Hour (CAD)Shift / Schedule: 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.
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.
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.
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.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.
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.
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.
Familiarity with data governance, controls, reconciliation, and reporting-quality practices.
Experience working closely with separate data-modelling and ETL development teams.
High attention to detail, particularly when developing pixel-perfect reports and validating data.
Ability to translate business reporting requirements into technical reporting solutions.
Robust documentation skills, particularly for data mappings, transformation rules, and reporting definitions.
Collaborative approach when working with business stakeholders, project managers, technology partners, and data teams.1 interview (virtual via MS Teams) with the Hiring Manager and Senior Leadership, approximately 1 hour in duration. A SQL test may be required; This client is a large, full-service multinational institution offering a comprehensive range of banking, wealth management, and capital markets products and services to individuals, businesses, and institutional clients. It serves millions of clients across its home market and operates internationally, with significant commercial and investment banking presence in the United States and other global markets. The organization employs professionals across technology, risk intelligence, data and analytics, capital markets, and enterprise programs functions, and is recognized for its collaborativ

📌 Senior Bi Developer (Winnipeg)
🏢 Global Technical Talent
📍 Winnipeg