PPM Data Analytics & Power BI Specialist

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

Job summary

Join a leading financial services company as a PPM Data Analytics & Power BI Specialist. In this role, you will extract, analyze, and visualize data to enhance project performance and resource utilization. Collaborate with stakeholders to design tailored BI solutions, ensuring data quality and operational efficiency. Enjoy a supportive environment with growth opportunities and a competitive compensation package.

Benefits

Inclusive environment

Growth opportunities

Casual dress code

Access to training resources

Qualifications

• 4+ years as a Power BI developer and data engineer.
• 3+ years working with Clarity PPM.

Responsibilities

• Extract and clean data from Clarity PPM and other systems.
• Develop and maintain dashboards and reports using Power BI.
• Work closely with project managers to translate reporting needs.

Skills

Analytical

Communication

Collaboration

Education

Bachelor's degree

Tools

Power BI

SQL

Clarity PPM

Job description

Requisition ID: #

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

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 insights into project performance, resource utilization, and portfolio management. You will design BI dashboards and reports to enhance business and operational efficiency, collaborating with various stakeholders to understand their needs and deliver tailored Power BI solutions that adhere to quality standards.

What will you do?

1. Data Modeling and Transformation: Extract and clean data from Clarity PPM and other systems, perform analysis to identify trends and KPIs, and design data models.
2. Dashboard and Report Development: Develop and maintain dashboards and reports using Power BI, supporting real-time insights into project and resource metrics.
3. Data Integration & Building Solutions: Understand data from various sources to create comprehensive views of project and portfolio performance, building stakeholder solutions.
4. Performance Optimization: Optimize reports and queries for speed and efficiency, especially with large data volumes.
5. Data Quality: Implement data validation processes to ensure accuracy and integrity.
6. Stakeholder Collaboration: Work closely with project managers and leaders to understand and translate reporting needs into BI solutions, managing expectations and prioritizing initiatives.
7. Documentation and Training: Document BI solutions and provide user training and support.

What do you need to succeed?

1. Bachelor's degree in relevant fields.
2. 4+ years as a Power BI developer and data engineer, preferably in financial services.
3. 3+ years working with Clarity PPM, preferably in financial services.
4. Strong analytical, communication, and collaboration skills.
5. Experience with data modeling, SQL, and relational databases.
6. Knowledge of software lifecycle, project management, and financial processes.
7. Proven experience developing dashboards in Power BI.
8. Understanding of financial metrics, risk management, and regulatory reporting.
9. Familiarity with cloud data platforms and relevant certifications.

What's in it for you?

• Inclusive, collaborative environment fostering creativity and growth.
• Tools and technology to create meaningful customer experiences.
• Opportunity to learn from industry leaders.
• Growth opportunities and career development support.
• Casual dress code and access to extensive training resources.
• Competitive compensation package including salary, bonuses, benefits, and more.

Location:

Canada: Ontario: Toronto

About Scotiabank:

Guided by our purpose: "for every future," we help our customers and communities succeed through a broad range of financial services. We value diversity and are committed to an inclusive environment. Accommodation requests during recruitment are welcomed.