Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
Tailor your resume to this Data Analyst role.
Rezi rewrites your resume against Scotiabank's job description. Free.
Tailor your resume to this Data Analyst role.
Rezi rewrites your resume against Scotiabank's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst posting at Scotiabank — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Analyst posting at Scotiabank — free, in seconds.
About the Role
The Data Analyst will support business operations through data analysis, reporting, process improvement, system implementation, and operational support. This role is responsible for delivering analytical insights, managing data migration initiatives, supporting financial and operational processes, and developing solutions to improve efficiency, accuracy, and control effectiveness. The position plays a key role in maintaining data integrity, supporting system transitions, and ensuring successful business outcomes by working closely with business stakeholders, operations teams, finance partners, and technology teams.
Responsibilities
- 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.
- 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.
- 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.
- 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.
- 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.
Requirements
- 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.
- Strong foundational knowledge of Microsoft Excel and data manipulation.
- Strong foundational knowledge of reporting and dashboard development.
- Basic understanding of database concepts and data structures.
- Basic understanding of data validation, reconciliation, and quality control processes.
- Software development or data engineering fundamentals.
- Experience through work, internships, co-op placements, or academic projects with data analysis and reporting.
- Experience through work, internships, co-op placements, or academic projects with large datasets and data-driven decision-making.
- Experience through work, internships, co-op placements, or academic projects with process improvement or automation initiatives.
- Ability to analyze data and identify trends, issues, and anomalies.
- Ability to translate business requirements into analytical solutions.
- Ability to support testing, implementation, and operational activities.
- Ability to 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.
- 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.
Skills
- SQL
- Data analysis
- Microsoft Excel
- Data manipulation
- Reporting
- Dashboard development
- Database concepts
- Data structures
- Data validation
- Reconciliation
- Quality control processes
- Software development fundamentals
- Data engineering fundamentals
- Python
- ACL
- SAS
- VBA
- BI tools
- Visualization tools
- Power BI
- Tableau
- OBIEE
- ThoughtSpot
- ETL tools
- DataStage
- Informatica
- OFSAA
- Financial data management platforms
- Chart of Accounts (CoA/CoFA) design
- Financial hierarchies
- Regulatory reporting
- Risk data environments
- Data lineage
- Metadata repositories
- Governance frameworks
- PeopleSoft 9.2 (PS92)
- ERP platforms
- Financial system migrations
- Ledger conversions
- Financial Close processes
- Audit
- Regulatory compliance initiatives
Location
- Canada : Ontario : Toronto
Work Type
- Onsite
Experience Level
- 3 years of experience
Education Level
- Bachelor’s degree in business, Finance, Accounting, Computer Science, Information Systems, Analytics, or a related field.
Benefits
- Competitive total rewards package
- Performance bonus
- Company matching programs (on pension & profit sharing)
- Generous vacation
About the Company
- 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 close 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.
- 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.
- 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.
Equal Opportunity
- 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.