At a Glance
- Tasks: Lead data modeling and analytics for regulatory reporting automation.
- Company: Join Scotiabank, a leading bank in the Americas with a purpose-driven culture.
- Benefits: Competitive rewards package, performance bonuses, and generous vacation time.
- Other info: Inclusive environment that fosters innovation and continuous learning.
- Why this job: Make an impact in finance while working with cutting-edge technology and diverse teams.
- Qualifications: 7+ years in data modeling and analytics; strong stakeholder management skills.
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:
- Data modeling and analytical solutions for the regulatory reporting automation and other initiatives that support the Finance and risk users.
- 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 application 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.
Lead Data Engineering and Analytics in Toronto employer: Scotiabank
Scotiabank is an exceptional employer that fosters a purpose-driven and inclusive culture, making it an ideal place for professionals seeking to excel in the financial services industry. With a strong focus on employee growth, you will have access to comprehensive training and development opportunities while working alongside senior leadership in a collaborative environment. Located in vibrant cities like Calgary and Vancouver, you will enjoy a dynamic work-life balance and the chance to make a meaningful impact on ultra-high net worth clients across Canada and internationally.
