Senior Business Intelligence Developer

About the job
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 client, commercial banking, treasury, and retail banking.

Contract Period: 5 months with potential to extend or convert

Location: Toronto, ON

Location Type: Hybrid; onsite 2 days per week

Job Responsibilities:

Design, engineer, deploy, and support actionable PowerBI 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).Automate the communication of PowerBI dashboards/apps to a dynamic targeted audience through e-mail and Teams via the Power Automate including dynamic tables for user consumption.Design multi-dimension data models leveraging data in many formats (SQL, xml, xlsx, csv, SharePoint directories, websites, etc.) that allow in-depth analysis.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 PowerBI and Power Automate. 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 (where required) on logic and processed 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:

8+ years of experience in implementation, administration, configuration and support of PowerBI dashboards/apps and Power Automate scriptsPowerBI design including dashboards and appsPower AutomateWorking knowledge of DAX and Power QueryWorking knowledge of SQL data manipulationXML, XLSX, CSV and other data source experienceWorking knowledge of data warehouse

****ALL CANDIDATES MUST COMPLETE A CRIMINAL AND CREDIT CHECK AS PART OF THE APPLICATION PROCESS****

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.

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.