Senior Business Intelligence Analyst (Power Automate / Apps)

TD; Canada; On-site; CAD 76,000 - 116,000; Full time

Job summary

A leading company in Toronto seeks a skilled professional to automate and enhance PowerBI dashboards and applications. This role involves collaborating with stakeholders, ensuring data quality, and translating business needs into technical specifications. Candidates should possess extensive experience with PowerBI and related tools, along with strong communication skills. This position offers growth opportunities and competitive compensation.

Qualifications

• 8+ years in PowerBI, Power Automate, PowerApps, with certification preferred.
• Knowledge of information security is a plus.

Responsibilities

• Automate PowerBI dashboards/apps communication via email and Teams using Power Automate.
• Design, deploy, and support PowerBI dashboards/apps that are user-friendly.
• Collaborate with partners to ensure insights are actionable based on KRIs and KPIs.

Skills

Power Automate

Power Apps

PowerBI

DAX

Power Query

SQL

JSON

XML

XLSX

CSV

Education

Bachelor's in technology

Bachelor's in security

Bachelor's in finance

Job description

Work Location:

Toronto, Ontario, Canada

Hours:

37.5

Line of Business:

Analytics, Insights, & Artificial Intelligence

Pay Details:

$76,800 - $115,200 CAD

TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are key features of the colleague experience at TD. Our policies allow colleagues to progress through the salary range as they advance in their roles. The actual offered pay may vary based on skills, experience, knowledge, location, and organizational needs. Candidates are encouraged to discuss compensation with recruiters for more details.

Job Description:

Responsibilities

• Automate PowerBI dashboards/apps communication via email and Teams using Power Automate, including dynamic tables.
• Create workflow scripts with PowerApps for data gathering from stakeholders.
• Design, deploy, and support PowerBI dashboards/apps that are user-friendly and action-inspiring.
• Build multi-dimensional data models from various data formats for analysis.
• Secure dashboards/apps data using AD groups and row-level security.
• Collaborate with partners to ensure insights are actionable based on KRIs and KPIs.
• Develop data management structures for reuse across dashboards.
• Translate business and security requirements into technical specifications and reports.
• Serve as SME on PowerBI, Power Automate, and PowerApps, advising on best practices.
• Perform testing and troubleshooting to ensure data quality.
• Support deployment of BI strategies in collaboration with teams.
• Document logic and processes for dashboards and communicate with users.
• Research and recommend process improvements.

Technical & Professional Qualifications

• Experience with Power Automate, Power Apps, PowerBI, DAX, Power Query, SQL, JSON, XML, XLSX, CSV, and data warehousing.

Education & Experience

• 8+ years in PowerBI, Power Automate, PowerApps, with certification preferred.
• Knowledge of information security is a plus.
• Bachelor's in technology, security, finance, or related field.
• Strong stakeholder engagement and communication skills.