Power BI & Data Analytics Specialist

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 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, pleaseclick here (https://www.scotiabank.com/careers/en/careers/technical-support-for-applicants.html) . 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.