Senior Business Intelligence Analyst

page for more information.
*
* Work Location:

** Toronto, Ontario, Canada
*
* Hours:

** 37.5
** Line of Business:
** Analytics, Insights, & Artificial Intelligence
** Pay Details:**$81,600 - $115,200 CADTD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience  compensation policies and practices have been designed to allow colleagues to progress through the salary range over time as they progress in their role. The base pay actually offered may vary based upon the candidate's skills and experience, job-related knowledge, geographic location, and other specific business and organizational needs.

As a candidate, you are encouraged to ask compensation related questions and have an open dialogue with your recruiter who can provide you more specific details for this role.
*
* Job Description:

** We are seeking a skilled Microsoft Power Platform / Business Intelligence Developer to design, develop, and maintain dashboards and reports using Microsoft Power Platform tools (Power BI, Power Automate, Power Apps and SharePoint (Lists).The developer will be responsible for analyzing data sources, building data models, creating DAX formulas, and delivering intuitive dashboards and data visualizations that support business decision-making.
*
* Key Responsibilities:

*** Develop and maintain Power BI dashboards and reports with advanced DAX calculations
* Automate workflows and notifications using Power Automate to streamline processes.
* Integrate and transform data from multiple sources into Power

BI for analysis and visualizations.
* Collaborate with business stakeholders to understand requirements and deliver effective BI solutions.
* Ensure data quality, consistency, and governance in alignment with enterprise standards.
* Provide technical expertise on BI systems, database administration, data modelling, and data integration
* Optimize dashboards and reports for performance, scalability and user adoption.
** CUSTOMER
* ** Produce specialized reporting packages, dashboards and scorecards for businesses, with focus on understanding objectives and delivering insights for: (1) product design and development; (2) customer engagement; (3) account management; and (4) business decision making.
* Use various methodologies to rapidly generate impactful interactive visualizations or tools.
* Lead the implementation of initiatives in support of overall business/function strategy.
* Conduct analysis to provide enhanced BI to inform management leadership team.
* Create complex and comprehensive BI reporting packages and dashboards utilizing data infrastructure, localized Data Mart's and external data sources and transform into visual stories using appropriate systems to support client objectives.
* Identify and propose data presentations to meet evolving business's needs; utilize various technology/ applications/ methodologies to rapidly generate impactful visualizations.
* Build basic layouts and templates to be utilized by internal partners.
* Validate the quality and integrity of the data included in the Reporting Packages and Dashboards
* Develop meaningful and insightful commentary/ insights on new and existing reporting packages.
* Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts.
* Adopt, implement and effectively evolve report automation and/or visualization standards.
* May as a subject matter expert, to provide advisory or consultative services for supported colleagues and/or businesses regarding multi-format data visualization techniques
** SHAREHOLDER
* ** Adhere to enterprise frameworks or methodologies that relate to activities for our business area.
* Consistently exercise discretion in managing correspondence, information and all matters of confidentiality; escalate issues where appropriate.
* Ensure business operations are in compliance with applicable internal and external requirements (e.g. financial controls, segregation of duties, transaction approvals and physical control of assets)
* Participate in cross-functional / enterprise / initiatives as a subject matter expert helping to identify risk / provide guidance for complex situations.
* Conduct internal and external research projects; support the development/ delivery of presentations / communications to management or broader audience.
* Conduct meaningful analysis at the functional or enterprise level using results to draw conclusions, make recommendations, assess the effectiveness of programs/ policies/ practices.
* Monitor service, productivity and assess efficiency levels within own function and implement continuous process / performance improvements where opportunities exist.
* Lead / facilitate and/or implement actions / remediation plans to address performance / risk /governance issues.
* Actively manage relationships within and across various business lines, corporate and/or control…