Software Engineer with ETL and DataStage Development

Requisition ID: 258729

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

The Team

The primary role of Global Finance Technology is to work with the Bank's finance community to re-engineer finance processes to enhance effectiveness and efficiency. The unit is also responsible for developing and implementing Financial and MIS applications services to meet the changing needs of Finance and the Bank. These applications have an enterprise-wide user community, and are an integral part of Finance's performance measurement, reporting and control infrastructure.

The Role

We are seeking a Level 7 Senior ETL Developer to support enterprise reporting applications for Finance teams. This role requires deep technical expertise in ETL design and development, strong engagement across all phases of the SDLC, and the ability to perform business analysis, DevOps, and operational support activities across Agile and Waterfall delivery models.

Operating within a highly regulated environment, this role partners closely with Finance, Accounting, Regulatory Reporting, Risk, Compliance, Audit, and Technology teams to deliver accurate, controlled, and scalable reporting solutions and analytics, in alignment with bank policies, regulatory expectations, and enterprise SDLC standards.

Key Responsibilities

ETL Design & Development

• Provide senior‑level technical expertise in the design, development, testing, and deployment of ETL processes supporting finance and regulatory reporting.
• Develop robust, scalable, and efficient data pipelines using enterprise ETL tools and advanced SQL.
• Ensure ETL solutions meet performance, data quality, reconciliation, auditability, and resiliency requirements.
• Apply best practices for exception handling, logging, monitoring, and restart-ability.
• Ensure end‑to‑end data traceability, lineage, and reconciliation to support audit and regulatory requirements.
• Translate accounting and finance business requirements into technical ETL and data solutions.
• Provide production support, including incident investigation, root cause analysis, and remediation.
• Maintain operational runbooks, job schedules, monitoring dashboards, and support procedures. Ensure solutions meet production support standards, including SLAs, monitoring, alerting, and recovery.

Business Analysis & Stakeholder Engagement

• Perform business analysis functions, including gathering, analyzing, and documenting business and data requirements.
• Creating functional specifications, data mappings, and source‑to‑target ETL documents.
• Conducting impact analysis across upstream and downstream systems.
• Act as a liaison between business stakeholders and technology teams to ensure shared understanding and successful delivery.
• Collaborate closely with Finance, Risk, Compliance, Data Governance, Architecture, QA, DevOps, and Operations teams.
• Communicate complex technical concepts clearly to both technical and non‑technical audiences.
• Support audit, risk, and regulatory inquiries by providing ETL documentation, data flows, and operational evidence.

Required Qualifications & Experience

• +5 years of hands‑on experience in ETL design and architecture within large, complex enterprise environments.
• Strong proficiency in Oracle and SQL server (+5 years), and relational database technologies.
• Experience with enterprise ETL tools (+5 years) (e.g., DataStage, SSIS, or equivalent).
• Proven experience working in Agile and Waterfall delivery models.
• Knowledge of using Jira for development, defect tracking, and operational work.
• Experience supporting DevOps, CI/CD pipelines, and production operations.
• Demonstrated experience performing business analysis activities in technical roles.

Nice to Have Qualifications

• +3 years Power BI development
• Familiarity with data governance, metadata management, and data lineage tools.
• Exposure to cloud or hybrid data platforms.
• Experience with scheduling tools and monitoring platforms.

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