Jobs
>
Toronto

    Power BI - Toronto, Canada - Scotiabank

    Scotiabank
    Scotiabank background
    Description

    As a Power BI expert and Data Analytics Specialist you will be at the forefront of analysing and visualizing data from Clarity PPM (and other sources) to provide stakeholders with actionable insights into key indicators like time tracking, project performance, resource utilization and portfolio management. You will be responsible for designing BI dashboards/reports that drive business and operational efficiency. You will collaborate closely with various stakeholders/teams/ management representatives across the bank to understand business objectives and reporting needs, unique requirements and deliver comprehensive Power BI solutions that meet their needs while adhering to quality and standards.

    Is this role right for you? In this role you will:

    Data Modeling and Transformation: Extract/download data from Clarity PPM and other relevant systems/sources , clean, massage and reprocess data as needed. perform in-depth analysis to identify trends, patterns, and key performance indicators related to project management, time tracking and resource allocation. Design and implement robust data models.
  • Dashboard and Report Development: Maintain & Develop visually appealing and intuitive dashboards, reports, and visualizations using Power BI. Support stakeholders with real-time insights into data related to project management, statuses, resource utilization/allocation, budget variance, time tracking and other critical metrics..
  • Data Integration: Understand the data from various systems - Clarity PPM data & other data sources such as financial systems or HR databases, to provide a comprehensive view of project performance and portfolio management.
  • Performance Optimization: Optimize BI reports and queries to ensure fast and efficient performance, specially when dealing with large volumes of data.
  • Data Quality: Implement rigorous data quality checks and validation processes to ensure the accuracy, consistency, and integrity of data used in Power BI dashboards/solutions.
  • Stakeholder Collaboration: Collaborate closely with project managers, business analysts, directors, senior Leaders & other stakeholders to understand their reporting requirements and translate them into effective BI solutions (that drive informed decision-making) following a well defined work intake process. Regularly prioritize the initiatives with the stakeholders and set the right expectations.
  • Documentation and Training: Create comprehensive documentation for BI solutions, including data models, report specifications, and user guides. Provide training and support to end users to ensure they can effectively utilize BI reports and dashboards.
  • Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

  • Bachelor's degree in Computer Science, Information Systems, Finance, or a related field.
  • 4 years of experience working as a Power BI developer and data engineer preferably in financial services industry.
  • 3 years of experience working on Clarity PPM ( project portfolio management technology) preferably in financial services industry.
  • Excellent analytical skills with a keen attention to detail.
  • Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
  • Experience with data modeling techniques and best practices, particularly in the context of project management, time tracking, resource management, Dashboard reporting, data extracts and other banking data.
  • Proficiency in Structured Query Language for data manipulation and querying, with a solid understanding of relational data structures and schema.
  • Strong knowledge of software lifecycle, project management, time tracking, financial management and processes
  • Proven track record of developing insightful dashboards and reports using Power BI in an enterprise environment.
  • Familiarity with financial performance metrics, risk management principles, and regulatory reporting
  • Knowledge of Clarity CA-PPM, programming languages, data analysis and automation
  • What's in it for you?

    Hybrid work model allowing for flexibility and work/life balance.
  • A rewarding career path with diverse opportunities for professional development
  • A culture that promotes teamwork and cross-functional collaboration to achieve business goals. Inclusive workplace that values diversity of thought, background, and experience
  • A competitive compensation and benefits package
  • An organization committed to making a difference in our communities – for you and our customers.
  • Get a great overview of how the Bank operates by joining the COO team within Technology & Operations in a role that has widespread impact across all major business lines and functions.


  • DNV Toronto, Canada

    **About us**: · We are the independent expert in assurance and risk management. Driven by our purpose, to safeguard life, property, and the environment, we empower our customers and their stakeholders with facts and reliable insights so that critical decisions can be made with co ...

  • Atlantis IT group

    Power Bi

    3 weeks ago


    Atlantis IT group Toronto, Canada

    **PowerBI Developer** · **Toronto, ON** · **Long Term** · **Must Have**: · **Roles & Responsibilities**: · Work with the business to define report requirements and translate those requirements into reporting deliverables. Design complex business intelligence and analytic solution ...

  • Digitronic Tech Savvy Inc.

    Power Platform

    5 days ago


    Digitronic Tech Savvy Inc. Toronto, Canada

    Minimum 4 years of Experience with Microsoft Dynamcis 365 Customer Engagement · Hands on experience · - At least 5 Canvas Apps built in the past · - Very good understanding of Microsoft Dateverse and Model-driven Apps · - Strong fluency with Power Automate Cloud Flows, RPA is a p ...

  • Top Technologies

    Power Platform

    5 days ago


    Top Technologies Toronto, Canada

    Minimum 4 years of Experience with Microsoft Dynamcis 365 Customer Engagement · Hands on experience · - At least 5 Canvas Apps built in the past · - Very good understanding of Microsoft Dateverse and Model-driven Apps · - Strong fluency with Power Automate Cloud Flows, RPA is a p ...

  • Virtusa

    Power Bi

    4 days ago


    Virtusa Toronto, Canada

    About Virtusa: · Virtusa Corporation is a global provider of Digital Business Transformation, Digital Engineering, and Information Technology (IT) outsourcing services that accelerate our clients' journey to their Digital Future. Virtusa serves Global 2000 companies in Banking, F ...


  • McCain Foods (Canada) Toronto, Canada

    **Position Title**:Power Platform Administrator · **Position Type**: Regular - Full-Time · **Position Location**:Toronto HQ · **Requisition ID**: 24478 · **Position Summary** · **Duties and responsibilities** · - Administer and manage the Microsoft Power Platform suite, including ...


  • Toronto Hydro Toronto, Canada

    Our certified and skilled tradespeople are at the heart of what we do. From our Certified Power Line Persons to our Certified Meter Mechanics, Distribution System Technologists and Power System Controllers, our tradespeople have the skills and experience to help us provide safe a ...

  • CareRx Corporation

    Power BI Specialist

    3 weeks ago


    CareRx Corporation Toronto, Canada

    **About CareRx** · CareRx is Canada's leading provider of specialty pharmacy services to seniors. We serve more than 92,000 residents in over 1,500 seniors and other communities (long-term care homes, retirement homes, assisted living facilities, and group homes). We are a nation ...

  • Jacobs

    Power Systems Intern

    3 weeks ago


    Jacobs Toronto, Canada

    Our People & Places Solutions business - reinforces our drive to improve the lives of people everywhere and epitomizes the "why" of what we do - the tremendous positive impact and value our solutions bring to our communities and society as a whole. From facilities delivering life ...


  • Toronto Hydro Toronto, Canada

    **WORK ILLUSTRATION**: · The Power Line Technician constructs, operates, maintains and repairs overhead and underground electrical and distribution systems. They erect and maintain steel, wood, fiberglass, laminate and concrete poles, structures, and other related hardware. They ...

  • Berendsen

    Power Unit Drafter

    3 weeks ago


    Berendsen Toronto, Canada

    Berendsen Fluid Power (BFP) is one of North America's largest distributors of hydraulic and pneumatic products and services. We have one of the largest dedicated field sales forces in both the hydraulics and pneumatics industries with 42 locations across the US and Canada. With t ...

  • EPIC WEBSOFT TECHNO SOLUTIONS LLP

    Power BI Analyst

    2 weeks ago


    EPIC WEBSOFT TECHNO SOLUTIONS LLP Toronto, Canada

    7+ years of experience working with the Microsoft Business Intelligence Stack (Power BI, SSAS, and SSIS) · - Minimum three years of extensive experience with Power BI. · - Experience with tools and languages SSAS, SSMS, Tabular Editor, and DAX. · - Understanding of and experience ...


  • The MEARIE Group Toronto, Canada

    **Job Title: Power System Controller - Apprentice** · WORK ILLUSTRATION: · The Power System Controller Apprentice is responsible for operating the electrical distribution system to ensure a safe, reliable and cost-effective delivery of electrical power on a 24-hour basis. In perf ...

  • SickKids

    Power BI Analyst

    2 weeks ago


    SickKids Toronto, Canada

    **About SickKids**: · Dedicated exclusively to children and their families, The Hospital for Sick Children (SickKids) is one of the largest and most respected paediatric healthcare centres in the world. As innovators in child health, we lead and partner to improve the health of c ...

  • SickKids

    Power BI Analyst

    2 weeks ago


    SickKids Toronto, Canada

    **About SickKids**: · Dedicated exclusively to children and their families, The Hospital for Sick Children (SickKids) is one of the largest and most respected paediatric healthcare centres in the world. As innovators in child health, we lead and partner to improve the health of c ...


  • themesoft Toronto, Canada

    Hi Professionals; · **This is Thiru from Themesoft INC.** · **Kindly let me know if you are interested in this opportunity** · BA with power platform · Long term · Toronto Canada-onsite · **Job Type**: Fixed term contract · Contract length: 8 months · Pay: $60.00-$65.00 per hour ...

  • SLR Consulting

    Power Sector Lead

    3 weeks ago


    SLR Consulting Toronto, Canada

    Take on a strategic role in helping to drive the growth of SLR Canada. · - Grow the delivery of environmental services to the power sector in Canada. · - Develop business strategy to expand SLR's presence in the market. · - Collaborate with fellow sector leads and technical teams ...

  • Infinity Quest

    Ibm Data Power

    1 week ago


    Infinity Quest Toronto, Canada

    Monitors, restores service, changes, supports, and handles day-to-day activities 7/24/365 required to run the mission critical systems for the company ensuring business service levels are met and environments are managed. · - Provides the Help/Service Desk support, as well as coo ...

  • Toronto Hydro

    Power Line Technician

    2 weeks ago


    Toronto Hydro Toronto, Canada

    **WORK ILLUSTRATION**: · The Power Line Technician Apprentice constructs, operates, maintains and repairs overhead and underground electrical and distribution systems. They erect and maintain steel, wood, fiberglass, laminate and concrete poles, structures, and other related hard ...


  • Atlantis IT Group Toronto, Canada

    **Power BI With Snowflake** · **TORONTO, ON - ONSITE** · **Long Term Contract** · **Client: TCS/TD Bank** · Job Description: Data Analytics, PowerBi and Service Now reporting development Roles and · Responsibilities: Communication with partners, building requirements, report deve ...