Manager, Analytics & Insights

Scotiabank; Canada; On-site; CAD 100,000 - 125,000; Full time

Job summary

An established industry player is seeking a Manager of Analytics & Insights to bridge the gap between data engineering and analysis. In this pivotal role, you will design and implement scalable data pipelines, ensuring that the data infrastructure supports high-quality analytics products. Collaborating closely with Business Intelligence managers, you will gather technical requirements, optimize data models, and automate processes to enhance reporting and decision-making. This position offers a unique opportunity to contribute to a purpose-driven team that values inclusivity and innovation while providing essential insights to drive business success.

Qualifications

• 3-5 years of experience in Data Science, Analytics, or Business Intelligence.
• Strong knowledge in SQL Server, Power BI, and ETL processes.

Responsibilities

• Manage development of analytical infrastructure and data models.
• Automate processes and ensure reliability of data pipelines.
• Create and maintain documentation for data workflows.

Skills

Data Science

Business Intelligence

Data Engineering

SQL

Data Modeling

ETL Tools

Microsoft Excel

Python

R

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

Talend

dbt

Azure

Job description

Requisition ID: #

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:

1. 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.
2. 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.
3. Automate repetitive processes and ensure the reliability and performance of data pipelines and/or existing Power BI dashboards and reports.
4. Enhance and improve dataflows created in Visual Studio, optimize SQL queries, and manage the SQL Server database to ensure efficient and scalable data processing.
5. Create and maintain clear documentation for data pipelines, models, and analytical workflows to ensure knowledge sharing and continuity within the team.
6. 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:

1. A Bachelor's Degree in Computer Science, Finance, Mathematics, Economics or Statistics.
2. 3-5 years of experience in Data Science / Analytics / Business Intelligence / Data Engineering.
3. 3-5 years of experience with ETL tools (Talend, dbt or similar), cloud platforms (Azure) and data modeling (dimensional modeling, snowflake etc.).
4. Advanced experience in SQL Server/Power BI/Visual Studio. Python/R knowledge is an asset.
5. Strong knowledge and proficiency in data infrastructure management - data mining, profiling, modeling, cleansing, enriching as well as extract, transform, load (ETL) solutions and scripting.
6. An understanding of Canadian Retail Banking and Wealth Management Distribution.
7. An ability to translate technical knowledge into business value.
8. 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. If you require technical assistance, please click here. Candidates must apply 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.