Data Analyst / Modeler Advisory

Scotiabank; Ontario; Hybrid; CAD 90,000 - 130,000; Full time

Job summary

Scotiabank is seeking a skilled Data Analyst & Data Modeler to join their CB Data Services team. This role focuses on developing enterprise data models and optimizing data flow, requiring extensive experience in data management and analysis. The position offers a hybrid work environment and promotes an inclusive culture with various benefits and opportunities for professional development.

Benefits

Inclusive culture promoting diversity, equity, and inclusion

Accessible workplace with accommodations

Opportunities for upskilling

Competitive rewards including bonuses and flexible vacation

Community engagement opportunities

Qualifications

• 10+ years in Data Management, analysis, modeling, architecture, and governance.
• Expertise in relational and dimensional data modeling, database design.
• Financial services domain knowledge is a strong asset.

Responsibilities

• Collaborate with business users to gather and analyze data requirements.
• Design and develop conceptual, logical, and physical data models.
• Ensure data integrity and quality.

Skills

Data Management

Data Analysis

Data Modeling

SQL

Python

Spark

Hive

Data Governance

Agile

Education

Bachelor’s degree or diploma in computer engineering or information science

Tools

Erwin

IGC

Collibra

Hadoop

GCP

Azure

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert :

Requisition ID : 224783

Join a purpose-driven, results-oriented team within an inclusive and high-performing culture.

The Team

CB Data Services manages the collective data assets for the Canadian Bank. The Data Services team designs and implements data storage, movement, and integration solutions to meet project needs and support the enterprise's long-term data strategy. We are seeking a skilled Data Analyst & Data Modeler to develop enterprise data models and data provisioning for target platforms, focusing on data analysis and architecture to optimize data flow and system performance.

Is this role right for you?

• Collaborate with business users to gather and analyze data requirements from source systems.
• Design and develop conceptual, logical, and physical data models for operational and analytical purposes.
• Work with technical and application architects and developers to implement data architecture and solutions.
• Communicate database designs to database administrators for implementation.
• Analyze source data (structured and unstructured) and business requirements.
• Document data flows, sources, entities, relationships, and redundancies.
• Ensure data integrity and quality.
• Maintain and generate metadata for Hadoop ingestion and other frameworks.
• Define and document data structures, meanings, and uses, collaborating with departments and data stewards.
• Establish data architecture for databases, reporting, and provisioning platforms.
• Support data governance, standards, and quality initiatives across the enterprise.
• Research and recommend emerging technology solutions aligned with business strategies.

Skills and experience required:

• 10+ years in Data Management, analysis, modeling, architecture, and governance.
• Expertise in relational and dimensional data modeling, database design, and Erwin.
• Proficiency in SQL, Python, Spark, and Hive (Hadoop).
• Knowledge of data architecture, patterns, and emerging technologies (RDBMS, Hadoop, Cloud).
• Experience with XML, JSON, Copybook, CSV ingestion.
• Financial services domain knowledge is a strong asset.
• Understanding of Data Governance processes, metadata, and lineage management; familiarity with tools like IGC, Collibra.
• Knowledge of cloud platforms such as GCP and Azure.
• Ability to translate business needs into technical solutions, with strong analytical skills.
• Experience creating architecture and strategy artifacts.
• Experience working in Agile environments.
• Knowledge of database administration, performance tuning, ETL processes, and data structures.
• Bachelor’s degree or diploma in computer engineering or information science.

What's in it for you?

• Inclusive culture promoting diversity, equity, and inclusion, with Employee Resource Groups (ERGs).
• Accessible workplace with accommodations for individuals with disabilities.
• Opportunities for upskilling through courses, cross-functional development, and tuition assistance.
• Competitive rewards including bonuses, flexible vacation, and benefits from day one.
• Community engagement opportunities through programs like hackathons.

Work conditions : Hybrid

LI-Hybrid

Scotiabank is a leading bank in the Americas, committed to helping customers and communities succeed. We value diverse skills and experiences and are dedicated to an inclusive, accessible environment. Candidates requiring accommodations during the recruitment process should inform our Recruitment team. All applicants must apply online; only selected candidates will be contacted for an interview.