Sr. BI Developer with PowerBI, DAX and Power Query experience to design, engineer, deploy, and support actionable PowerBI dashboards/apps that are part of

Business Unit: Cyber Engineering

Duration: 12 months, possibility of extension

Interview Process: Virtual 2 steps

Location (Remote, Hybrid ): 100% Remote 310 - 320 Front street TO (Must be in the GTA for some in office meetings )

CANDIDATE PROFILE DETAILS:

Degree/Certifications Required: Microsoft PL-300 certification preferred

Bachelors degree in technology, finance, business or equivalent

Years of experience: 8yrs

Reason for request/why opened: Staff aug supporting on new automation initiatives

% Interaction with Stakeholders: 30%

Project Scope: BI reporting T

eam Size: 2ppl

Selling Points of Position: Working within a leading FI organization

Background :implementation, administration, configuration and support of PowerBI dashboards/apps and Power Automate scripts

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).

• 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

• 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

• 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

Must Have :

• 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

Education & Experience

• 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.