Power BI Specialist (Sr Manager)

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

Job summary

An established industry player is seeking a Power BI Specialist to drive data analytics and visualization efforts. In this role, you will extract and analyze data from various sources, including Clarity PPM, to create insightful dashboards that enhance project performance and resource management. Collaborating with cross-functional teams, you will ensure that stakeholders receive real-time insights that facilitate informed decision-making. This is an exciting opportunity to leverage your analytical skills in a dynamic environment that values creativity and collaboration, while also offering a competitive rewards package and opportunities for professional growth.

Benefits

Competitive rewards package

Performance bonus

Company matching programs on pension

Paid vacation

Personal & sick days

Medical, vision, and dental insurance

Access to online and in-person courses

Inclusive and collaborative working environment

Qualifications

• 4+ years of experience as a Power BI developer in financial services.
• Strong analytical skills and attention to detail required.

Responsibilities

• Extract and analyze data from Clarity PPM for actionable insights.
• Develop and maintain dashboards and reports using Power BI.

Skills

Power BI

Data Analysis

Data Modeling

SQL

Clarity PPM

Communication Skills

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

Job description

Press Tab to Move to Skip to Content Link

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

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.