IT - Business Intelligence Developer V

Our client is a top financial institution with significant North American holdings.  They have operations across most major verticals, including institutional & corporate, wealth management, private clients, commercial banking, treasury, and retail banking.

 

Introduction :

Robertson is seeking a skilled IT - Business Intelligence Developer V to join our client in support of an existing vacancy.

Contract Period: 12 months with potential to extend and convert

Pay Rate: Starting from $72 per hour

Location : Toronto, ON

Location Type: Hybrid

Business Hours:  Monday-Friday, Core business hours

 

Job Responsibilities:

• Automate the communication of Power BI dashboards/apps to a dynamic targeted audience through e-mail and Teams via the 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 Power BI dashboards/apps that are part of the Workforce Identity and Access Management organization
• Design must be visually friendly, easy to navigation 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 our 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
• Be our Subject Matter Expert on Power BI, 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 our 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

Experience & Qualification Requirements:

• Post secondary degree required
• 10+ years of implementation, administration, configuration and support of Power BI dashboards/apps, Power Automate scripts and PowerApps experience required
• 2+ years of experience with AI tools such as CoPilot and VSCode
• Power Automate
• Power Apps
• Power BI design including dashboards and apps
• Building complex DAX and Power Query
• SQL data manipulation
• Strong experience managing large data sets (100 million+)
• SON, XML, XLSX, CSV and other data source experience
• Working knowledge of data warehouse including data management optimization
• Preferred information security knowledge (lifecycle management, privileged access and authN/authZ)
• Banking or financial institution experience
• Microsoft PL-300 certification

How to Apply: If you are a motivated professional looking to contribute to a leading team, please submit your resume outlining your qualifications and experience relevant to this role. Robertson & the clients we represent, value diversity and are committed to creating an inclusive workplace. We invite all qualified individuals to apply.

Background screening is required as part of the onboarding process. The type of screening required (criminal, credit, or other verifications) will vary based on the position and client requirements.

We use AI technology as part of our application review process to assist with screening and assessment. All applications are also reviewed by our recruitment team.

 

Robertson & the clients we represent are equal opportunity employers, committed to diversity and inclusion. Robertson is a certified diverse supplier and actively seeks to foster a representative and inclusive workforce. We welcome applications from all qualified individuals, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, Aboriginal status, or any other legally protected factors. We champion building a diverse and inclusive environment.