Data Engineer Manager - Business Intelligence

Requisition ID: 211184

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

Contributes to the overall success of Fraud Management - ensuring specific individual goals, and initiatives are delivered in support of business strategies and priorities to protect the Bank and our customers. As Manager, Data Engineer, you will be a key member of our Fraud Business Intelligence team that provides fact based operational insights to Canada Fraud Operations. Leveraging your expertise in data modeling, data engineering, data visualization, and strong analytical background, to organize and transform raw data into actionable meaningful information. You will be responsible for the full scorecard and metric development lifecycle that includes analysis and requirements gathering, data profiling/mapping, data modelling and ETL development.

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

• This is a highly technical role that requires close stakeholder engagement, main accountabilities are:
• Work closely with stakeholders to understand business needs, data specifications and translate requirements into metrics, technical design and wireframe; Define and develop actionable KPIs/metrics that align with strategic goals within Fraud Management
• Act as subject matter expert on Fraud datasets and source systems
• Develop data pipelines and design dimensional data model that will provide insights into business problems within Azure Cloud
• Support Senior Manager, Business Intelligence on establishing and enhancing BI framework and standards, and optimizing change management process
• Production Level 1 support to sustain BI features after release, prioritize fixes for defects, monitor report usage and identify value-add functionalities to improve adoption
• Be an active member of a scrum team, leveraging agile methodology for incremental and early delivery of MVP features; actively participate in scrum ceremonies to continuously improve BI product
• Capable of working on multiple activities simultaneously in a highly dynamic environment and capable of understanding complex requirements and meeting project deadlines

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

• Post-secondary degree in Computer Science, Engineering, or related STEM discipline
• 5+ years of hands-on experience in Business Intelligence/Data Warehousing
• Expert knowledge of SQL and dimensional data modelling
• 1-2 years working with Azure Cloud - SQL MI, Data Factory, and Data Flow
• 1-2 years working with Azure DevOps pipeline and TFS code repository
• Minimum of 1 year developing data visualizations using Power BI
• Experience working within a scrum team and an agile environment
• Experience working with Power platform (PowerApps, PowerAutomate, PBI copilot) as asset
• Prior experience supporting Fraud KPI reporting as asset
• Strong verbal, written, presentation & communication skills
• Proactive, organized, excellent analytical and problem-solving skills

What's in it for you?

• 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, technical yet fun 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

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.