Lead Data Engineering and Analytics with Axiom

Scotiabank; Toronto; On-site; CAD 120,000 - 170,000; Full time

Benefits offered by this job

Performance bonus

Pension matching

Profit sharing

Generous vacation

Job summary

Scotiabank in Toronto, Canada seeks a Lead Data Engineering and Analytics professional to design data models and analytics solutions for regulatory reporting automation across Global Finance. You will partner with business, risk, and architecture teams to deliver scalable data platforms and end-to-end data governance.

The role emphasizes hands-on work with Axiom SL, ETL pipelines, and performance optimization while ensuring data quality and stakeholder alignment across Finance and Risk.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or related discipline.
• Master's degree considered as an asset.

Responsibilities

• Gather requirements, design and build new features.
• Collaborate with product owner, project manager and other application teams.
• Data mapping and ETL pipeline design, collaborate with data engineers for automation solutions.
• Experience with Axiom SL data models/schemas and reporting workflows.

Skills

Data modeling

ETL pipelines

Axiom SL v9/10/11

SQL

Python

Stakeholder mgmt

Regulatory reporting

Education

Bachelor's degree in CS/IS/DS/Engineering

Master's degree (asset)

Tools

Axiom SL

Data Stage ETL

ERWin

Python

Spark

Oracle SQL

Job description

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

Title: Lead Data Engineering and Analytics with Axiom

Requisition ID: 272406

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

The Team

Our team is responsible for the technology data platforms that support Global Finance, ranging from Financial and Regulatory Reporting, Budgeting and Planning, and Control.

Is this role right for you? In this role, you will:

This role would be data modeling and analytical solutions for the regulatory reporting automation and other initiatives that support the Finance and risk users. The successful candidate will work closely with various stakeholders including business partners in Global Finance and Risk; Business analyst, Architects, and infrastructure and support to understand business requirements and drive the analysis and design of quality technical solutions that best support the business need.

Some of the key accountabilities include:

• Gather requirements, design and build new features
• Collaborate with the product owner, project manager and other apploication teams
• Data mapping and ETL Pipeline Design, collaborate with the data engineers for the automation solutions
• Experience of Axiom SL V9/10/11 – Hands on experience with Axiom data models/ schemas/ portfolios, tabular/Freeform reports and workflows to support complex data governance and transformation requirements.
• Ensure best possible performance, quality and responsiveness of the applications
• Identify bottlenecks and bugs, and devise solutions to these problems
• Excellent understanding of developer life cycle and enterprise developer tools

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

Education

• Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, or related discipline.
• Master's degree considered as an asset.

Experience

• 7+ years of experience in data modeling, analytics and data management within financial services
• Proven experience owning business data definitions, data backlog, prioritizing deliverables by business ROI, and translating complex platform data into business‑ready reporting assets through detailed requirement documentation (PRDs/BRDs) and source-to-target data mappings
• Demonstrated ability to enable and coach non‑technical stakeholders to self‑serve data responsibly, with strong stakeholder management skills partnering across Technology Teams, Operations, Technology Controls
• Strong understanding of banking products, Financial Accounting; Finance Datawarehouse design and working with regulatory reporting teams.
• Experience with OFSAA, IFRS17, OSFI reporting, or related regulatory frameworks preferred.

Technical Skills

• Solid grasp of relational data modelling tools (e.g. ERWin), schema design, and Master Data Management; familiarity with AI/ML concepts is an asset.
• Strong understanding of Data Stage ETL tool.
• Proficiency in other tools (e.g. Python NumPy/Panda, Spark framework) Data mapping and ETL Pipeline Design and build, collaboration with Engineers on Data integration and transformation, analysis, testing and automation.
• Strong knowledge of Axiom SL v9/10/11
• Advanced Oracle SQL on data extraction, indexing and performance tuning
• Hands-on familiarity with data analysis on Data Lake Platform
• Familiarity with Agile and SDLC methodologies – JIRA / Confluence

What’s in it for me

• 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.