Power BI Specialist (Sr Manager)

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

Job summary

Join a leading bank as a PPM Data Analytics & Power BI Specialist in Toronto. You'll extract and analyze data to provide actionable insights, design BI dashboards, and collaborate with various teams. Ideal candidates have strong analytical skills, experience with Power BI, and a background in financial services. Enjoy a collaborative environment with opportunities for growth and a competitive rewards package.

Benefits

Competitive rewards package

Paid vacation

Medical, vision, and dental

Access to online courses

Qualifications

• 4 years of experience as a Power BI developer.
• 3 years of experience with Clarity PPM in financial services.

Responsibilities

• Extract, analyze, and visualize data from Clarity PPM.
• Design and implement BI dashboards and reports using Power BI.
• Collaborate with stakeholders to understand reporting needs.

Skills

Analytical Skills

Communication

Interpersonal Skills

Data Modeling

Attention to Detail

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Finance

Tools

Power BI

Clarity PPM

Structured Query Language

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Title: PPM Data Analytics & Power BI Specialist

Requisition ID: 223310

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

The role:

As a PPM Data Analytics & Power BI Specialist you will be at the forefront of extracting, analysing and visualizing data from Clarity PPM ( and other sources) to provide stakeholders with actionable insights into 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 reps 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.

What will you do?

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 & Building Solutions: 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. Build solutions that meet the stakeholders requirements/expectations from power bi dashboard reporting standpoint.

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.

What do you need to succeed?

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.

Extensive Experience with Power BI dashboards and data management in the banking industry.

Knowledge of Clarity CA-PPM, programming languages, data analysis and automation.

Familiarity with cloud-based data platforms

Relevant certifications in Power BI, data engineering, or banking systems data analytics.

What's in it for you?

We have an inclusive and collaborative working environment that encourages creativity and curiosity and celebrates success

We provide you with the tools and technology needed to create meaningful customer experiences

You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world

We hire you for your talent — not just a job — so you can grow with us. We’ll equip you for success not only in your role, but also in your career as a whole

Dress codes don't apply here: being comfortable does

Access to thousands of online and in-person courses so you can hone your current skills, or learn new ones

A competitive rewards package that includes a base salary, a performance bonus, company matching programs on pension and profit sharing, paid vacation, personal & sick days, medical, vision, and dental and much more

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.

At Scotiabank, we value the unique skills and experiences each individual brings to the Bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. If you require technical assistance, please click here . Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.