Manager, Data Engineer

Scotiabank • Toronto, ON

35d • Hybrid

About The Position

Contributes to the overall success of the CBO Performance Enablement department by ensuring individual goals, plans, and initiatives are executed and delivered in support of the team’s business strategies and objectives. Responsible for supporting the end to end data development and enablement lifecycle, including sourcing and transforming data, building and maintaining reliable data solutions that enable reporting and performance insights, and supporting the underlying data platforms and infrastructure. Ensures all activities are conducted in compliance with governing regulations, internal policies, and established standards and procedures.

Requirements

• University degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• 3+ years of hands-on experience in data engineering, business intelligence, or analytics engineering roles, supporting reporting and performance enablement use cases.
• Strong experience designing, developing, and maintaining data solutions using Microsoft SQL Server in on premise and private cloud environments.
• Proven experience with ETL / data integration development using SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) to support scheduled, reliable, and scalable data pipelines.
• Experience working with Power BI, including developing and supporting semantic models, datasets, and reports in collaboration with analytics and business stakeholders.
• Solid understanding of dimensional and relational data modelling, data quality checks, data validation, and performance optimization.
• Experience developing and supporting SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) solutions is required.
• Comfortable working across the end to end data lifecycle, including data sourcing, transformation, validation, and enablement of downstream reporting and analytics.
• Experience supporting production data processes, including monitoring, issue triage, root-cause analysis, and implementation of controls and guardrails to ensure data reliability.

Nice To Haves

• Exposure to Python and related data libraries is considered an asset.

Responsibilities

• Champions a customer-focused culture to deepen client relationships and leverage broader Bank relationships, systems and knowledge.
• Designs, builds, and maintains scalable data architectures and data pipelines using SQL Server (on premise and private cloud) to support periodic data integration, transformation, validation, and enablement of operational and performance reporting. Ensures solutions align with data management principles, technology strategy, and governance standards.
• Works in an Agile environment, adapting quickly to evolving business and technical requirements, tight timelines, and competing priorities. Supports data driven decision making by enabling timely, well structured, and trusted data for downstream analytics and reporting teams.
• Identifies opportunities to automate manual and repetitive data processes, driving continuous improvement in efficiency, reliability, and maintainability through the effective use of tools, standards, and engineering best practices.
• Applies iterative development practices across all phases of data solution delivery, including data profiling, ingestion, transformation, modeling, cleansing, conforming, enrichment, and aggregation, establishing a strong foundation for downstream reporting and performance insights (limited direct visualization work).
• Ensures the availability, reliability, and integrity of data products through monitoring, controls, and support processes. Builds strong partnerships with enterprise architecture, infrastructure, application, and technology teams to meet performance, availability, and support expectations.
• Supports structured analysis and issue resolution by enabling accessible, well designed data assets and participating in root-cause analysis, triage, and remediation of data quality or pipeline failures.
• Proactively recommends and executes improvements to engineering practices, tooling, and delivery approaches to enhance operational efficiency, solution quality, and long term sustainability of data platforms.
• Understands how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions. Actively pursues effective and efficient operations of his/her/their respective areas, while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to operational risk, regulatory compliance risk, AML/ATF risk and conduct risk, including but not limited to responsibilities under the Operational Risk Management Framework, Regulatory Compliance Risk Management Framework, AML/ATF Global Handbook and the Guidelines for Business Conduct.

Benefits

• A rewarding career path with diverse opportunities for professional development
• A culture that promotes teamwork and cross-functional collaboration to achieve business goals. Inclusive workplace that values diversity of thought, background, and experience
• A competitive compensation and benefits package
• Opportunity to work with a very enthusiastic team that helps our clients by ensuring the Bank is able to continue to operate to deliver key business services.
• Hybrid working environment allowing for work/life balance

What This Job Offers

• Job Type: Full-time
• Career Level: Manager
• Education Level: Associate degree