Senior Power BI Developer Data Engineer
Job Summary
Location: Toronto ON
Onsite Flexibility: Hybrid 4 days in office
- Position Type: Contract
- Contract Duration: 6 months (with potential for extension)
- Pay Rate: C$85.00C$105.00 / Hour (CAD)
- Shift / Schedule: Monday to Friday 9:00 AM 5:00 PM
- Travel Requirements: Not required
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).
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.
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 BI Power Automate M queries DAX
- Report development
- Process mapping
- Storytelling
Power Platform & Tools
- Power Automate
- 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
- Coachable Learners Mindset
- Willingness to Deliver
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
- Python scripting
- PBI Service management
- Version Control
- Power Platform
- VBA / Macros (legacy reporting environments)
- Process mapping and operating model documentation
- Bachelors or Masters degree in Technology Analytics Finance or related field (preferred)
- Post-secondary education in data analytics
- Microsoft Power BI certification (e.g. PL-300) preferred
- 1015 years of overall experience in Business Intelligence Data & Analytics
- 811 years of overall experience
- 5 years of advanced Power BI development in Banking / Financial Services
- Proven experience supporting Capital Risk or Regulatory Reporting initiatives
- Experience working in a complex dynamic and ambiguous environment with changing business requirements
- Experience with Power BI storytelling and active demonstration of work
- Experience in data developer roles with a learners mindset and adaptive approach
- Medical Vision and Dental Insurance Plans
- 401k Retirement Fund
This client is a leading financial services and banking institution operating across Canada and internationally with teams spanning technology risk finance capital management and regulatory reporting functions. The organization employs professionals across roles including solutions developers data engineers release strategists and IT specialists who collaborate in fast-paced agile environments. With a strong emphasis on data modernization governance and regulatory compliance this institution is recognized for its scale and commitment to long-term digital transformation across its banking operations.
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: Software Engineering
#df41bd #LI-Hybrid #LI-GTT #gttca
Required Experience:
Senior IC