Senior Power BI Developer / Data Engineer

Original job posting

Design and develop Power BI dashboards and semantic models to support Capital Measurement and Risk reporting within a banking environment. Collaborate with stakeholders to modernize reporting platforms and ensure data is regulator-ready and auditable.

Job details

Senior Power BI Developer/ Data Engineer V Location: Toronto, ON Onsite Flexibility: Hybrid — 4 days in office Contract Details Position Type: Contract Contract Duration: 6 months (with potential for extension) Pay Rate: C$85.00–C$105.00 / Hour (CAD) Shift / Schedule: Monday to Friday, 9:00 AM – 5:00 PM Travel Requirements: Not required Job Summary We are seeking a seasoned Senior Power BI Developer to support a Capital Measurement Reporting (CMR) Data Modernization program within the Banking domain. This role will focus on delivering trusted, well-governed, and regulator-ready analytics that support capital reporting, risk metrics, and executive decision-making. The successful candidate will work closely with Risk, Finance, Regulatory Reporting, and Data Engineering teams to modernize reporting platforms, enhance transparency, and enable data-driven insights aligned to regulatory expectations (e.g., Basel / capital frameworks). Key Responsibilities Capital & Risk Reporting Analytics Design and develop Power BI dashboards and reports supporting Capital Measurement, RWA, Risk Exposure, and Finance metrics. Translate complex capital and risk data into clear, auditable, and business-friendly visualizations. Enable storytelling for senior management and regulators, ensuring clarity, traceability, and consistency. Support drill-downs from enterprise summaries to granular risk and exposure data. Data Modernization & Modeling Build optimized Power BI semantic models aligned with modern data platforms (cloud, curated data layers). Apply advanced data modeling techniques (star schema, conformed dimensions) for capital and risk data. Develop and optimize DAX measures for capital calculations, aggregations, trends, and comparisons. Leverage Power Query (M code) and SQL to support ETL and data transformation requirements. ETL & Data Integration Work with upstream ETL and Data Engineering teams to ensure accurate, timely, and reconciled data feeds. Support ingestion from multiple banking data sources (risk engines, finance systems, regulatory datasets). Ensure data lineage, reconciliation, and consistency across reports. Power BI Service & Governance Manage Power BI Service environments, including workspace strategy, datasets, refresh schedules, and access controls. Implement version control, deployment, and release management practices aligned with enterprise standards. Ensure compliance with data governance, security, and audit requirements. Produce high-quality documentation to support audit, model validation, and regulatory reviews. Automation & Power Platform Utilize Power Automate to streamline reporting workflows and data validation processes. Contribute to broader Power Platform adoption within the Capital Measurement ecosystem. Stakeholder Engagement & Leadership Partner with Risk, Finance, Capital Management, and Technology stakeholders to gather requirements and validate outputs. Act as a subject matter expert for Power BI within the Capital Measurement Reporting space. Mentor junior BI developers and promote best practices across the program. Participate in design reviews and modernization working groups. Required Skills Business Intelligence & Data Power BI Desktop & Power BI Service (Expert) Advanced DAX Power Query / M code Advanced SQL Enterprise data modeling (Fact / Dimension modeling) ETL concepts and performance optimization Documentation and audit-ready reporting Power Automate Report development Process mapping Storytelling (translating complex data into executive-ready formats) Power Platform & Tools Power Platform fundamentals Version Control (Git, Azure DevOps or equivalent) PBIX lifecycle and release management Core Competencies & Soft Skills Strong stakeholder engagement across Risk, Finance, and Technology Excellent communication and storytelling skills Ability to explain complex capital data in simple, executive-ready formats Coachable, continuous learner with modernization mindset High accountability and willingness to deliver in regulatory-driven environments Attention to detail Preferred Skills Banking & Domain Knowledge (Highly Preferred) Capital Measurement / Capital Reporting Risk & Finance data concepts Regulatory reporting environments Data controls, reconciliation, and traceability expectations Large-scale data modernization programs Additional Skills Python scripting VBA / Macros (legacy reporting environments) Process mapping and operating model documentation PBI Service management Education Requirements Bachelor's or Master's degree in Technology, Analytics, Finance, or related field (preferred) Post-secondary education in data analytics Microsoft Power BI certification (e.g., PL-300) preferred Required Experience 10–15 years of overall experience in Business Intelligence, Data & Analytics 5 years of advanced Power BI development in Banking / Financial Services Proven experience supporting Capital, Risk, or Regulatory Reporting initiatives About the Client This client is a top 10 North American bank providing comprehensive retail, commercial, and wealth solutions, with operations spanning major financial centres across Canada and the United States. Employing tens of thousands of professionals across its network, the organization engages software engineers, data engineers, business intelligence developers, risk analysts, finance specialists, and technology project managers who collaborate across large-scale modernization programs. About GTT GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada. Job Number: 26-13445 Industry: Data & Analytics #df41bd

What you’ll do

Design and develop Power BI dashboards and semantic models to support Capital Measurement and Risk reporting within a banking environment. Collaborate with stakeholders to modernize reporting platforms and ensure data is regulator-ready and auditable.

Requirements

Requires 10-15 years of BI experience with at least 5 years of advanced Power BI development in financial services. Candidates should possess expert-level DAX and SQL skills and experience with regulatory reporting frameworks.

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Process Mapping · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Power BI
• DAX
• Power Query
• SQL
• Data Modeling
• ETL
• Power Automate
• Power Platform
• Capital Measurement
• Risk Reporting
• Regulatory Reporting
• Storytelling
• Version Control
• Python
• VBA
• Process Mapping

Job areas

• Data & Analytics
• Finance & Accounting
• Technology
• Engineering
• Consulting