Power BI

7 months ago


Toronto, Canada Scotiabank Full time

Requisition ID: 199165

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

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.

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our pur


  • Power Bi

    5 days ago


    Toronto, Canada NR Consulting LLC Full time

    Job Title/Role Power BI Experience Level Required Mid or Senior Level Experience Please share the Detailed Job Description - Power BI (mainly) along with Tableau (preferred) - Should be expert in Full stack Power BI. Also has Tableau exp. - Need to have experience building Dashboards, Reporting, Data Visualization, Data analytics etc. - Should have excellent...

  • Power Bi

    5 days ago


    Toronto, Canada NR Consulting LLC Full time

    Job Title/Role Power BI Experience Level Required Mid or Senior Level Experience Please share the Detailed Job Description "Power BI (mainly) along with Tableau (preferred) "Should be expert in Full stack Power BI. Also has Tableau exp. "Need to have experience building Dashboards, Reporting, Data Visualization, Data analytics etc. "Should have excellent...

  • Power Bi

    6 months ago


    Toronto, Canada Virtusa Full time

    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, Financial Services, Insurance, Healthcare, Telecommunications, Media,...

  • Power BI Administrator

    4 months ago


    Toronto, Canada Bridgemarq Real Estate Services Manager Limited Full time

    **Date**:September 16, 2024 **Work Status**:Full time role, Hybrid **Reporting To**: SVP, Technology **Department**:IT **Location**:39 Wynford Drive, Toronto, ON M3C-3K5 **Hours Worked**:35 hours per week **Career Stream & Level**: P2 - Experienced **Salary Band Grade**:$54,700, $68,400, $82,100 **Bonus Eligible: 10%** **About RPS Real Property...

  • Power BI Specialist

    7 months ago


    Toronto, Canada CareRx Corporation Full time

    **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 national organization with a large network of pharmacy fulfillment centers that...

  • Power BI Administrator

    3 months ago


    Toronto, Canada Computershare Full time

    **Location: Toronto, ON** This is a hybrid position primarily based in our Toronto office. We’re committed to your flexibility and wellbeing and our hybrid strategy currently requires three days a week in the office, giving you the option to work remotely for some of your working week. Find out more about our culture of flexible working. **We give you a...

  • Power BI Administrator

    2 months ago


    Toronto, Canada Computershare Full time

    **Locations**:Toronto, ON or Richmond Hill, ON (Hybrid) In this position, you'll be based in one of the above noted US offices for a minimum of three days a week, with the flexibility to work from home for some of your working week. Find out more about our flexible work culture at computershare.coM/Flex **We give you a world of potential**: Computershare...

  • Power BI Specialist

    4 months ago


    Toronto, Canada CareRx Corporation Full time

    **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 national organization with a large network of pharmacy fulfillment centers that...

  • Power BI Specialist

    2 months ago


    Toronto, Canada ZS Full time

    : **ZS** is a place where passion changes lives. As a management consulting and technology firm focused on improving life and how we live it, our most valuable asset is our people. Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping life-changing solutions for patients, caregivers and consumers, worldwide. ZSers drive...

  • Power BI Analyst

    7 months ago


    Toronto, Canada Zeitview Full time

    Zeitview (formerly DroneBase) is the leading intelligent aerial imaging company for high-value infrastructure, providing businesses with actionable, real-time insights to recover revenue, reduce risk and improve build quality. Zeitview serves customers in the solar, wind, insurance, construction, real estate, and critical infrastructure industries. Trusted...

  • Power BI Consultant

    4 weeks ago


    Greater Toronto Area, Canada Dimensional Strategies Inc. Full time

    Job Summary:We are seeking a highly skilled and motivated Power BI Consultant to help our clients implement and optimize data analytics solutions using Microsoft Power BI. The successful candidate will work with business leaders and stakeholders to understand their reporting needs and create data-driven insights that empower decision-making. This position...

  • Power BI Developer

    4 days ago


    Toronto, Canada VLink Inc Full time

    Job Title: Power BI DeveloperLocation: Toronto -HybridEmployment Type: Long term contractJob Description:We are seeking a skilled and proactive Power BI Developer to join our team in Toronto. This role involves leveraging Power BI to deliver data-driven insights, collaborating with cross-functional teams, and ensuring the seamless migration and integration...

  • Power BI Developer

    4 days ago


    Toronto, Canada VLink Inc Full time

    Job Title: Power BI Developer Location: Toronto -Hybrid Employment Type: Long term contract Job Description: We are seeking a skilled and proactive Power BI Developer to join our team in Toronto. This role involves leveraging Power BI to deliver data-driven insights, collaborating with cross-functional teams, and ensuring the seamless migration and...

  • Power BI Developer

    5 days ago


    Toronto, Canada VLink Inc Full time

    Job Title: Power BI DeveloperLocation: Toronto -HybridEmployment Type: Long term contractJob Description:We are seeking a skilled and proactive Power BI Developer to join our team in Toronto. This role involves leveraging Power BI to deliver data-driven insights, collaborating with cross-functional teams, and ensuring the seamless migration and integration...

  • Power BI Developer

    4 days ago


    Toronto, Canada VLink Inc Full time

    Job Title: Power BI DeveloperLocation: Toronto -HybridEmployment Type: Long term contractJob Description:We are seeking a skilled and proactive Power BI Developer to join our team in Toronto. This role involves leveraging Power BI to deliver data-driven insights, collaborating with cross-functional teams, and ensuring the seamless migration and integration...

  • Power BI Consultant

    1 month ago


    Greater Toronto Area, Canada, Ontario Dimensional Strategies Inc. Full time

    Job Summary:We are seeking a highly skilled and motivated Power BI Consultant to help our clients implement and optimize data analytics solutions using Microsoft Power BI. The successful candidate will work with business leaders and stakeholders to understand their reporting needs and create data-driven insights that empower decision-making. This position...

  • Business Intelligence

    7 months ago


    Toronto, Canada CareRx Corporation Full time

    **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 national organization with a large network of pharmacy fulfillment centres that...

  • Power BI Analyst

    7 months ago


    Toronto, Canada EPIC WEBSOFT TECHNO SOLUTIONS LLP Full time

    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 with Agile delivery and Scrum ceremonies. - **Testing exp. is mandatory.**: -...

  • Power BI Analyst

    7 months ago


    Toronto, Canada SickKids Full time

    **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 children through the integration of healthcare, leading-edge research and...

  • Power BI Analyst

    7 months ago


    Toronto, Canada SickKids Full time

    **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 children through the integration of healthcare, leading-edge research and...