Business Intelligence Developer

Business Intelligence Developer

Location: Toronto, ON

Onsite Flexibility: Hybrid — 2 days in office, 3 days work from home (potential for 4 days in office in the future)

Contract Details

• Position Type: Contract
• Contract Duration: 1 year (with possibility of extension and conversion based on business needs and performance)
• Pay Rate: C$68.00–C$81.00 / Hour (CAD)
• Shift / Schedule: Monday–Friday, core business hours — 37.5 hours per week, 7.5 hours per day; overtime possible based on project needs
• Travel Requirements: Not required

Job Summary

The Workforce Identity and Access Management (IAM) team has an enterprise-wide focus on identity, authentication, authorization, and IAM governance. This ensures users have the right access at the right time for the right reasons. This position is for a Senior Business Intelligence Analyst reporting to the Senior Manager, Information Security. This role is to act as a functional team member for the Governance and Analytics team to provide outcome-driven actionable insights across the various information security principles and related software. The primary focus is on reducing risk and improving the bank's Workforce IAM security posture.

Key Responsibilities

• Automate the communication of PowerBI dashboards/apps to a dynamic targeted audience through e-mail and Teams via Power Automate, including dynamic tables for user consumption.
• Leverage artificial intelligence tools such as CoPilot, VSCode, etc. to reduce development build time and improve quality.
• Create workflow management scripts through PowerApps to improve engagement of data gathering from business partners and internal customers.
• Design, engineer, deploy, and support outcome-driven actionable PowerBI dashboards/apps that are part of the Workforce Identity and Access Management organization. Design must be visually friendly, easy to navigate, and inspire action by the user(s).
• Design multi-dimension data models leveraging data in many formats (SQL, XML, XLSX, CSV, SharePoint directories, websites, etc.) that allow in-depth analysis.
• Assist in developing solutions to ingesting and managing extremely large datasets (100M records) to provide an optimal user experience for the Power Platform users.
• Due to sensitivity of the data, work with business partners to secure dashboards/apps data in a secure manner via AD groups and row-level security based on data and role.
• Work with business partners and internal teams to ensure insights provided are actionable and meaningful based on key risk indicators (KRIs) and key performance indicators (KPIs).
• Build out a data management structure to allow re-use of data across multiple dashboards.
• Understand business, application, and security requirements provided by customers and translate these into technical specifications. Produce enterprise-level reporting to meet these requirements.
• Serve as Subject Matter Expert on PowerBI, Power Automate, and PowerApps. Provide consultation to business partners on best practices and standardization when building out dashboards/apps.
• Conduct unit testing and troubleshooting to ensure quality, audit-proof data is provided.
• Ensure successful deployment of the business intelligence strategy in collaboration with people leader, Power Platform team, and business partners.
• Create and maintain documentation on logic and processes followed to build out the dashboard and communicate with the target audience(s).
• Research and put forward new recommendations to create, automate, and improve processes.

Required Skills

• 10 years of experience in implementation, administration, configuration, and support of PowerBI dashboards/apps, Power Automate scripts, and PowerApps
• 2 years of experience with AI tools such as CoPilot and VSCode
• Extensive experience in Power Automate
• Extensive experience in Power Apps
• Extensive experience in PowerBI design including dashboards and apps
• Extensive experience building complex DAX and Power Query
• Extensive experience in SQL data manipulation
• Strong experience managing large datasets (100 million records)
• JSON, XML, XLSX, CSV, and other data source experience
• Working knowledge of data warehouse including data management optimization
• Strong communication skills (written and verbal)
• Strong time management; proactive and takes initiative
• Attention to detail; self-starter and adaptable
• Strong documentation skills
• Strong problem-solving and analytical thinking skills

Preferred Skills

• Knowledge of information security (lifecycle management, privileged access, and authentication/authorization)
• Banking or financial institution experience
• Microsoft PL-300 certification

Education Requirements

• Post-secondary education is an asset
• Microsoft PL-300 certification is an asset

Required Experience

• 10 years of overall experience in Business Intelligence development, including implementation, administration, configuration, and support of Power Platform tools (PowerBI, Power Automate, PowerApps)
• 2 years of experience with AI tools such as CoPilot and VSCode

About the Client

This client is a leading financial services and banking institution operating across Canada and internationally, with a workforce that includes solutions developers, business intelligence professionals, IT specialists, and technology teams collaborating across enterprise-wide programs. The organization employs thousands of professionals spanning technology, risk, governance, and operations, and is recognized for its strong collaborative culture, emphasis on innovation, and commitment to long-term employee development.

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.