Data Analyst

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

Benefits offered by this job

Performance bonus

Company matching programs (pension &/2

Generous vacation

Job summary

Scotiabank is seeking a Data Analyst in Toronto to support business operations through data analysis, reporting, and process improvements. You will work with finance, operations and technology to maintain data integrity and enable successful system transitions, including PeopleSoft 9.2 migration.

The role requires strong analytical skills, data modeling and the ability to translate business requirements into analytical solutions within a fast-paced environment.

Qualifications

• Bachelor’s degree in business, Finance, Accounting, Computer Science, Information Systems, Analytics, or a related field.
• 3 years of experience in data analysis, reporting, operations support, technology, or a related field.
• Strong foundational knowledge of SQL and data analysis, Excel, reporting and dashboard development.

Responsibilities

• Collect, validate, analyze, and interpret data from multiple business systems.
• Develop and maintain reports, dashboards, and performance metrics for decision-making.
• Conduct ad hoc analyses and provide actionable recommendations to stakeholders.
• Monitor data quality, identify anomalies, and investigate discrepancies.
• Support data migration initiatives involving legacy systems and PS92.

Skills

SQL and data analysis

Microsoft Excel

Reporting and dashboard development

Data validation and quality control

Strong analytical skills

Stakeholder collaboration

Education

Bachelor’s degree in business, Finance, Accounting, Computer Science, Information Systems, Analytics, or related field

Tools

PeopleSoft 9.2 (PS92)

Data modeling

Job description

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

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

Please be advised that our Careers site will be unavailable from November 28 at 12am ET to November 29 12am ET for scheduled system maintenance.

Title: Data Analyst

Requisition ID: 269197

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

Team

The Data team within Global Finance & Risk Technology (GFRT) provides enterprise-level analytics, data services, governance support, and operational data management for Global Finance initiatives. The team plays a critical role in supporting financial c lose processes, financial reporting, data migration initiatives, system implementations, and ongoing operational activities while ensuring the delivery of high-quality Financial Data Management, Data Analysis, Data Quality, and Data Governance services across the organization.

Role

• We are seeking a Data Analyst to support business operations through data analysis, reporting, process improvement, system implementation, and operational support activities.
• The role is responsible for delivering analytical insights, managing data migration initiatives, supporting financial and operational processes, and developing solutions that improve efficiency, accuracy, and control effectiveness.
• Working closely with business stakeholders, operations teams, finance partners, and technology teams, the position plays a key role in maintaining data integrity, supporting system transitions, and ensuring successful business outcomes.
• The successful candidate will combine strong technical expertise in data engineering, programming, data analysis, data modeling, and database design with a solid understanding of finance, accounting, and operational processes.
• This individual must be highly analytical, proactive, detail-oriented, and capable of working effectively with stakeholders across Finance, Operations, Technology, and Vendor teams. Experience supporting system implementations, data migrations, financial reconciliations, and process automation initiatives is highly desirable.

What will we expect from you?

Data Analysis & Reporting

• Collect, validate, analyze, and interpret data from multiple business systems.
• Develop and maintain reports, dashboards, and performance metrics to support decision-making.
• Conduct ad hoc analysis and provide actionable recommendations to stakeholders.
• Monitor data quality, identify anomalies, and investigate discrepancies.

Process Improvement & Automation

• Identify opportunities to streamline and automate operational processes.
• Develop and maintain reporting, reconciliation, and analytical solutions.
• Support the implementation of process enhancements, system upgrades, and operational efficiencies.
• Create and maintain process documentation, user guides, and operational procedures.

Data Migration & System Implementation

• Support data migration initiatives involving the transition from legacy systems and local ledgers to enterprise platforms, including PeopleSoft 9.2 (PS92).
• Coordinate data extraction, validation, transformation, and loading activities.
• Establish and validate historical balances and reference data within the new system environment.
• Perform reconciliation activities to ensure completeness and accuracy between source and target systems.
• Collaborate with business and technology stakeholders to resolve migration and conversion issues.
• Support User Acceptance Testing (UAT), parallel runs, production readiness, and go-live activities.
• Provide post-implementation support, including issue investigation, defect resolution, process stabilization, and end-user assistance following deployment.

Stakeholder Management & Governance

• Partner with business, operations, finance, and technology teams to gather requirements and deliver solutions.
• Communicate findings, risks, and recommendations to stakeholders and management.
• Support audit requests, control testing, and regulatory compliance requirements.
• Maintain strong governance and control practices over data, reporting, and operational processes.

Operational Support

• Support day-to-day operational and financial processes.
• Prepare, review, and coordinate special entries, adjustments, corrections, and related operational transactions.
• Investigate, resolve, and escalate operational issues as required.
• Perform reconciliations and exception analysis to ensure data accuracy and completeness.
• Support month-end, quarter-end, and year-end operational activities.

What You Will Bring to Succeed

• Bachelor’s degree in business, Finance, Accounting, Computer Science, Information Systems, Analytics, or a related field.
• 3 years of experience in data analysis, reporting, operations support, technology, or a related field.
• Strong foundational knowledge of:
  • SQL and data analysis
  • Microsoft Excel and data manipulation
  • Reporting and dashboard development
  • Basic understanding of:
  • Database concepts and data structures
  • Data validation, reconciliation, and quality control processes
• Experience through work, internships, co-op placements, or academic projects with:
  • Data analysis and reporting
  • Large datasets and data-driven decision-making
  • Process improvement or automation initiatives

Ability to:

• Analyze data and identify trends, issues, and anomalies
• Translate business requirements into analytical solutions
• Support testing, implementation, and operational activities
• Learn new technologies and business processes quickly
• Strong analytical, problem-solving, and organizational skills.
• Excellent verbal and written communication skills.
• Ability to work effectively both independently and within a team environment.

Nice-to-Have Skills:

• Python, ACL, SAS, VBA, or similar scripting and automation tools
• BI and visualization tools (Power BI, Tableau, OBIEE, ThoughtSpot)
• ETL tools (DataStage, Informatica, or equivalent)
• OFSAA or other financial data management platforms

Exposure to:

• Chart of Accounts (CoA/CoFA) design and financial hierarchies
• Regulatory reporting and risk data environments
• Data lineage, metadata repositories, and governance frameworks
• PeopleSoft 9.2 (PS92) or comparable ERP platforms
• Experience supporting:
• Financial system migrations and ledger conversions
• Audit and regulatory compliance initiatives

Soft Skills Required:

• Strong analytical and problem-solving mindset with the ability to resolve complex data and operational issues.
• Highly detail-oriented with a focus on data accuracy, integrity, and control effectiveness.
• Excellent communication and stakeholder management skills across business and technology teams.
• Ability to work proactively and independently in a fast-paced environment.
• Strong collaboration skills with cross-functional teams and external partners.
• Effective prioritization, organization, and multitasking abilities.
• Demonstrated adaptability and willingness to learn new technologies and business processes.
• Reflective and open-minded attitude, with the ability to incorporate feedback for continuous personal and professional growth.
• Strong documentation, governance, and process management capabilities.

The Workplace

• We are technology partners who help the business transform how our employees around the world work
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success!
• You'll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world
• We foster an environment of innovation and continuous learning
• We care about our people, allowing them to design how they work to deliver amazing results
• We offer a competitive total rewards package, including a performance bonus, company matching programs (on pension & profit sharing), and generous vacation

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 . Job Segment: Data Analyst, Test Engineer, Data Conversion, Business Process, Computer Science, Data, Engineering, Management, Technology