Business Intelligence Developer IV

ICONMA; Toronto; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

A leading banking company is seeking a Business Intelligence Developer IV for a hybrid role in Toronto. The position involves designing and supporting PowerBI dashboards, automating processes, and ensuring data security. Ideal candidates will have over 8 years of experience with PowerBI and strong communication skills.

Benefits

Health Benefits

Referral Program

Excellent growth and advancement opportunities

Qualifications

• 8+ years of experience in PowerBI and Power Automate.
• Strong knowledge of SQL and data manipulation.
• Ability to communicate technical issues in business language.

Responsibilities

• Design and support PowerBI dashboards/apps.
• Automate communication of dashboards.
• Ensure data security and compliance.

Skills

PowerBI

Power Automate

DAX

Power Query

SQL

Data Warehousing

Interpersonal Skills

Communication

Job description

Our Client, a Banking company, is looking for a Business Intelligence Developer IV for their Toronto, ON/ Hybrid location.

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

Requirements:

• 8+ years of experience in implementation, administration, configuration and support of PowerBI dashboards/apps and Power Automate scripts
• PowerBI design including dashboards and apps
• Power Automate
• Working knowledge of DAX and Power Query
• Working knowledge of SQL data manipulation
• XML, XLSX, CSV and other data source experience
• Working knowledge of data warehouse
• Strong coordination and interpersonal skills as this role require significant interaction with different stakeholders across the Workforce IAM organization.
• Strong oral and written communication skills and ability to simplify and explain technical issues into understandable business language.

Why Should You Apply?

• Health Benefits
• Referral Program
• Excellent growth and advancement opportunities

As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.