PPM Data Analytics & Power BI Specialist

Scotiabank; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

Join a leading financial institution as a PPM Data Analytics & Power BI Specialist. You will be responsible for extracting and visualizing data to enhance project performance and resource utilization. Collaborate with teams to design BI solutions and optimize reports for efficiency. This role offers growth opportunities and a supportive work culture.

Benefits

Inclusive environment

Tools and technology for customer experiences

Growth opportunities

Casual dress code

Access to training resources

Competitive compensation package

Qualifications

• At least 4 years of experience as a Power BI developer and data engineer.
• Minimum 3 years of experience with Clarity PPM.

Responsibilities

• Extract, analyze, and visualize data from Clarity PPM and other sources.
• Create and maintain dashboards and reports using Power BI.
• Work closely with project managers and senior leaders to gather requirements.

Skills

Analytical Skills

Communication

Collaboration

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Finance

Tools

Power BI

SQL

Clarity PPM

Job description

Requisition ID: 223310

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

The role:

As a PPM Data Analytics & Power BI Specialist, you will extract, analyze, and visualize data from Clarity PPM and other sources to provide stakeholders with actionable insights into project performance, resource utilization, and portfolio management. Your responsibilities include designing BI dashboards and reports that enhance business and operational efficiency. You will collaborate with various teams across the bank to understand their reporting needs and deliver comprehensive Power BI solutions that meet quality standards.

What will you do?

1. Data Modeling and Transformation: Extract data from Clarity PPM and other sources, clean, process, and analyze it to identify trends and KPIs. Design robust data models.
2. Dashboard and Report Development: Create and maintain visually appealing, intuitive dashboards and reports using Power BI, providing real-time insights into project statuses, resource utilization, budget variances, and other key metrics.
3. Data Integration & Building Solutions: Integrate data from multiple systems to offer a comprehensive view of project and portfolio performance. Build solutions aligned with stakeholder requirements.
4. Performance Optimization: Optimize BI reports and queries for speed and efficiency, especially with large data volumes.
5. Data Quality: Implement data validation processes to ensure accuracy and consistency in dashboards and reports.
6. Stakeholder Collaboration: Work closely with project managers, analysts, and senior leaders to gather requirements, prioritize initiatives, and set expectations.
7. Documentation and Training: Document BI solutions thoroughly and provide user training and support for effective utilization.

What do you need to succeed?

• Bachelor's degree in Computer Science, Information Systems, Finance, or related field.
• At least 4 years of experience as a Power BI developer and data engineer, preferably in financial services.
• Minimum 3 years of experience with Clarity PPM, ideally in financial services.
• Strong analytical skills and attention to detail.
• Excellent communication and collaboration skills.
• Experience with data modeling, SQL, and relational databases.
• Knowledge of project management, financial processes, and data analysis.
• Proven experience developing enterprise dashboards with Power BI.
• Familiarity with financial metrics, risk principles, and regulatory reporting.
• Experience with cloud data platforms and relevant certifications.

What's in it for you?

• An inclusive, collaborative environment that fosters creativity and success.
• Tools and technology to create meaningful customer experiences.
• Opportunities to learn from industry leaders worldwide.
• Growth opportunities aligned with your talent and interests.
• Casual dress code and a supportive work culture.
• Access to extensive training resources.
• Competitive compensation package including salary, bonuses, benefits, and more.

Location: Toronto, Ontario, Canada

Scotiabank is committed to diversity and inclusion. We provide accommodations for applicants with disabilities. Candidates must apply online. Only shortlisted candidates will be contacted.