BI Developer

Diverse Lynx LLC; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

A technology services provider is seeking a Senior Business Intelligence Analyst in Toronto (Hybrid). The role involves automating PowerBI dashboards, designing data models, and collaborating with business partners to ensure actionable insights. Candidates should have extensive experience in Power Automate, Power Apps, and dashboard design. This position supports a diverse workforce and offers equal employment opportunities.

Qualifications

• Extensive experience with Power Automate, Power Apps, and Power BI.
• Skilled in building complex DAX and Power Query.
• Knowledge in SQL data manipulation and various data formats.

Responsibilities

• Automate PowerBI dashboards communication and improve engagement.
• Design and support actionable PowerBI dashboards.
• Work with business partners to ensure insights are actionable.

Skills

Power Automate

Power BI design

DAX and Power Query

SQL data manipulation

JSON

XML

XLSX

CSV

Job description

Overview

Role: Senior Business Intelligence Analyst - BI Developer

Location: Toronto (Hybrid)

Contract

Job Description

• 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.
• 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.
• Due to data sensitivity, 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, 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.

Technical & Professional Qualifications

• Extensive experience in :
• Power Automate
• Power Apps
• PowerBI design including dashboards and apps
• Building complex DAX and Power Query
• SQL data manipulation
• JSON, XML, XLSX, CSV and other data source experience
• Working knowledge of data warehouse

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.