Manager, Analytics & Insights

Scotiabank; Toronto; On-site; CAD 80,000 - 110,000; Full time

Job summary

Join a forward-thinking financial institution as a Manager in Analytics & Insights, where you will play a crucial role in bridging data engineering and analysis. Your expertise will help design and implement scalable data pipelines, ensuring that the data infrastructure supports rapid and high-quality analytics products. Collaborate with Business Intelligence teams to create robust data models and automate processes, enhancing decision-making across the organization. This is an exciting opportunity to contribute to a culture of innovation and inclusivity while driving impactful business insights.

Qualifications

• 3-5 years of experience in Data Science/Analytics/Business Intelligence/Data Engineering.
• Strong knowledge in SQL Server and Power BI.

Responsibilities

• Manage development of analytical infrastructure/data models for accurate reporting.
• Automate processes and ensure reliability of data pipelines and dashboards.

Skills

Data Science

Business Intelligence

Data Engineering

ETL tools

SQL

Data Modeling

Data Infrastructure Management

Microsoft Excel

Education

Bachelor's Degree in Computer Science

Bachelor's Degree in Finance

Bachelor's Degree in Mathematics

Bachelor's Degree in Economics

Bachelor's Degree in Statistics

Tools

Power BI

Visual Studio

SQL Server

Azure

Talend

dbt

Job description

Requisition ID: 214176

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

As the Manager, Analytics & Insights, you will bridge the gap between data engineering and analysis, ensuring that our data infrastructure supports the creation of rapid, high-quality, and scalable data analytics products. You will work closely with Business Intelligence managers and stakeholders to design and implement scalable data pipelines, create robust data models, and provide the foundation for data-driven decision-making.

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

• Work closely with data engineering teams to manage the development of analytical infrastructure/data models that support accurate reporting and value-added business insights; interact with multiple data sources, leverage the Enterprise Data Lake to extract and transform data into simplified data models that supports reporting for key stakeholders in Finance, Operations and Leadership.
• Gather technical requirements and build and optimize data models, in collaboration with Business Intelligence Managers, to ensure accurate, reliable, and well-structured datasets for analysis.
• Automate repetitive processes and ensure the reliability and performance of data pipelines and/or existing Power BI dashboards and reports.
• Enhance and improve dataflows created in Visual Studio, optimize SQL queries, and manage the SQL Server database to ensure efficient and scalable data processing.
• Create and maintain clear documentation for data pipelines, models, and analytical workflows to ensure knowledge sharing and continuity within the team.
• Be responsible for the development, maintenance and distribution of reports and dashboards focused on key performance measures for Scotia Securities Inc (SSI) distribution channels including, but not limited to, mutual funds sales, assets under administration, tier 1 supervision, and compliance reporting.

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

• A Bachelor's Degree in Computer Science, Finance, Mathematics, Economics or Statistics.
• 3-5 years of experience in Data Science/Analytics/Business Intelligence/Data Engineering.
• 3-5 years of experience with ETL tools (Talend, dbt or similar), cloud platforms (Azure) and data modeling (dimensional modeling, snowflake etc.).
• Advanced experience in SQL Server/Power BI/Visual Studio. Python/R knowledge is an asset.
• Strong knowledge and proficiency in data infrastructure management - data mining, profiling, modeling, cleansing, enriching as well as extract, transform, load (ETL) solutions and scripting.
• An understanding of Canadian Retail Banking and Wealth Management Distribution.
• An ability to translate technical knowledge into business value.
• Expert proficiency in Microsoft Excel.

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