Manager, Portfolio Reporting & Analytics

Job summary

The Manager of Portfolio Reporting & Analytics is responsible for designing and delivering high-quality Power BI dashboards and report packs for senior stakeholders. They will also manage data integrity, optimize SQL queries, and partner with IT to ensure accurate and consistent reporting outputs.

Job details

Headquartered in Toronto, the Canada Infrastructure Bank (CIB) is responsible for investing in new infrastructure projects. The CIB’s mission is to work with provincial, territorial, municipal, federal, Indigenous and private sector investor partners to transform the way infrastructure is planned, financed and delivered in Canada. As the Manager, Portfolio Reporting & Analytics, you will own the business design and delivery of dashboards and report packs used by senior stakeholders. In addition, you are accountable for delivering and operationalizing portfolio reporting outputs, translating strategic priorities into high-quality, production-ready dashboards and reporting solutions. You will query and validate data directly from enterprise datasets, shape clear metric definitions, and publish high-performing Power BI solutions that leaders trust. This role is accountable for reporting outputs, insight generation, and data integrity, operating within the business while partnering closely with IT. Your responsibilities include: Design and deliver Power BI dashboards and report packs aligned to defined business priorities and executive decision‑making needs, including Power Query, data modeling, DAX, publishing, and refresh Write and optimize SQL to interrogate, reconcile, and validate data from enterprise databases/data warehouses Translate business questions into well defined metrics, definitions, and visuals with established standards that enable clear executive decision-making Implement data quality checks, reconciliations, and documentation so outputs are explainable and trusted Partner with IT and systems owners to access and shape data from enterprise databases/warehouses and independently validate outputs to ensure accuracy and consistency Define business data and reporting requirements and priorities, and work with IT and systems owners to improve data sourcing (tables/views, refresh schedules, access) and reduce manual reporting Continuously improve performance and usability (report design standards, navigation, load times, and workspace governance) Your ideal profile: Minimum of seven years of relevant experience in analytics, reporting, and business intelligence, with hands-on delivery in Power BI Undergraduate degree in business, finance, economics, engineering, computer science, or a related field Experience supporting investment or portfolio reporting, with strong understanding of commitments, funding, valuations, cash flows, performance, and pipeline reporting. Experience in infrastructure or related private assets environments is strongly preferred Exceptional stakeholder management and communication skills, with experience presenting insights to senior leaders and influencing decisions Strong Power BI capabilities with a focus on translating business requirements into scalable, decision‑ready reporting outputs Demonstrated portfolio of Power BI work (dashboards, semantic models, DAX) Advanced SQL skills and comfort working directly with enterprise databases/data warehouses to query, reconcile, and validate results Demonstrated ability to lead and develop reporting and analytics capability, including mentoring, prioritization, and driving consistency and quality of outputs Strong controls mindset, including documentation, lineage, reconciliation, and change management to support explainable, audit-ready reporting Experience operating within a business function in close partnership with IT, with clear accountability for reporting outputs and stakeholder adoption Bilingualism in English and French is an asset; training can be provided We thank you for your interest. Only those selected for further screening or an interview will be contacted. Don’t forget to follow us on LinkedIn and on X (formerly Twitter) @cib_en or @bic_fra. At the CIB, we are committed to diversity and equitable access to employment opportunities. If you require an accommodation for the recruitment/interview process (including alternate formats of materials, or accessible meeting rooms or other accommodation), please let us know at accessible@cib-bic.ca and we will work with you to meet your needs. For more information on our company, visit www.cib-bic.ca.

What you’ll do

The Manager of Portfolio Reporting & Analytics is responsible for designing and delivering high-quality Power BI dashboards and report packs for senior stakeholders. They will also manage data integrity, optimize SQL queries, and partner with IT to ensure accurate and consistent reporting outputs.

Requirements

Candidates must have at least seven years of experience in analytics and business intelligence with hands-on Power BI expertise. An undergraduate degree in a relevant field such as finance, business, or computer science is required, along with strong SQL skills and experience in portfolio or investment reporting.

Listed skills

• Data visualization · Preferred
• Power BI · Preferred
• SQL · Preferred
• Financial analysis · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Power BI
• SQL
• Data Modeling
• DAX
• Portfolio Reporting
• Data Visualization
• Business Intelligence
• Data Integrity
• Stakeholder Management
• Financial Analysis
• Infrastructure Investment
• Data Warehousing
• Metric Definition
• Change Management
• Reporting Governance
• Accountability
• Reporting Solutions
• Data Analysis Expressions (DAX)
• Bilingual (French/English)
• Strategic Prioritization
• Auditing
• Reconciliation
• Dashboard
• Corporate Finance
• Business Requirements
• Investments
• Decision Making
• Communication
• Computer Science
• Data Quality
• Economics
• Cash Flows
• Warehousing
• Governance
• Scalability
• Mentorship
• SQL (Programming Language)
• Usability
• Prioritization
• Business Priorities
• Pipeline Reporting

Job areas

• Data & Analytics
• Finance & Accounting
• Management & Leadership
• Technology
• Government & Public Sector
• Analytics Portfolio Manager
• Business Intelligence Developer / Architect
• Software Developers