Senior Manager, Ppm Data & Analytics (Power BI and Data Analytics)

Requisition ID: 214674

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

The role:

As a Power BI expert and Data Analytics 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 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 Data Warehouse 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.

What do you need to succeed?

• Bachelor's degree in Computer Science, Information Systems, Finance, or a related field.
• 5 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.