Data Analyst / Modeler

Scotiabank; Toronto; Hybrid; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a Data Analyst & Data Modeler to join their purpose-driven team. This role involves collaborating with business users to gather data requirements, designing data models, and implementing data architecture solutions. You will ensure data integrity and quality while supporting enterprise-wide data strategies. The company promotes an inclusive culture with opportunities for upskilling and competitive rewards. If you're passionate about data and technology, this is the perfect opportunity to make a significant impact in the financial services sector.

Benefits

Flexible vacation

Tuition assistance

Employee Resource Groups

Community engagement activities

Accessible workplace accommodations

Qualifications

• Experience in relational and dimensional data modeling.
• Proficiency in SQL, Python, Spark, and Hive.
• Knowledge of data architecture patterns and Cloud platforms.

Responsibilities

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

Skills

SQL

Python

Spark

Hive (Hadoop)

Data Modeling

Analytical Skills

Agile Methodologies

Education

Bachelor's degree in Computer Engineering

Diploma in Information Science

Tools

Erwin

GCP

Azure

IGC

Collibra

Job description

Job Description: Data Analyst & Data Modeler at Scotiabank

Join a purpose-driven, high-performing team committed to results and inclusivity. CB Data Services manages the Canadian Bank's data assets, focusing on designing and implementing data storage, movement, and integration solutions to meet project needs and support long-term enterprise goals.

Responsibilities

1. Collaborate with business users to gather data requirements and analyze source systems.
2. Design conceptual, logical, and physical data models for operational and analytical purposes.
3. Work with architects and developers to implement data architecture and solutions.
4. Communicate database designs and coordinate with database administrators for implementation.
5. Document data flows, sources, entities, relationships, and redundancies.
6. Ensure data integrity and quality, and maintain metadata for various data ingestion frameworks.
7. Define and document data architecture for databases, reporting, and provisioning platforms.
8. Support data strategies, standards, governance, and quality processes enterprise-wide.
9. Research and implement emerging technology solutions aligned with business strategies.

Qualifications

• Experience in relational and dimensional data modeling, with skills in Erwin.
• Proficiency in SQL, Python, Spark, and Hive (Hadoop).
• Knowledge of data architecture patterns, RDBMS, Hadoop, and Cloud platforms (GCP, Azure).
• Ability to translate business needs into technical solutions and strong analytical skills.
• Experience with XML, JSON, CSV, and Copybook data ingestion.
• Experience working in Agile environments.
• Knowledge of Data Governance, metadata, and lineage management tools (e.g., IGC, Collibra) is a plus.
• Domain knowledge in financial services is advantageous.
• Educational background: Bachelor's degree or diploma in computer engineering or information science.

Benefits and Work Environment

• Inclusive culture promoting diversity, equity, and inclusion, with Employee Resource Groups.
• Accessible workplace with accommodations for all employees.
• Opportunities for upskilling through courses, cross-functional projects, and tuition assistance.
• Competitive rewards, including bonuses, flexible vacation, and benefits.
• Community engagement activities and programs.

Work condition: Hybrid (Ontario, Toronto)

Scotiabank is committed to an inclusive environment and provides accommodations during the recruitment process. Candidates must apply online. Only shortlisted candidates will be contacted.