Senior Data Engineer/ Data Modeler

Spruce InfoTech Inc.; Toronto; Hybrid; CAD 96,000 - 165,000; Full time

Job summary

Spruce InfoTech Inc. is seeking a hands-on Senior Data Engineer / Data Modeler for a 6–12 month engagement in Toronto, hybrid work.

The role demands strong expertise in both data engineering and data modeling, with excellent Python and PySpark coding, and solid SQL/Data Modeling experience in Banking/Financial Services. The ideal candidate will design data models, build scalable data pipelines, perform JSON data modeling, optimize performance, and translate business requirements into robust data

Qualifications

• 8+ years of experience in Data Engineering and Data Modeling.
• Hands-on coding experience in Python.
• Hands-on coding experience in PySpark.
• Strong SQL Data Modeling / JSON Data Modeling experience.
• Strong SQL and ETL/ELT experience.
• Knowledge of conceptual, logical, and physical data modeling.
• Experience with dimensional modeling and data warehouse concepts.

Responsibilities

• Design conceptual, logical, and physical data models for banking data.
• Develop and optimize scalable data pipelines using Python, PySpark, and SQL.
• Perform SQL Data Modeling and JSON Data Modeling for structured and semi-structured data.
• Perform data transformation, integration, mapping, and quality validation.
• Translate business requirements into data models and engineering solutions.
• Write, optimize, and troubleshoot Python and PySpark code for large-scale data processing.
• Optimize data processing and troubleshoot pipelines for performance and scalability.

Skills

Data Engineering

Data Modeling

Python

PySpark

SQL

JSON Data Modeling

ETL/ELT

Job description

Experience: 8+ Years | Location: Toronto, ON – Hybrid | Duration: 6–12 Months

Role Overview: We are looking for a hands-on Senior Data Engineer / Data Modeler with strong expertise in both Data Engineering and Data Modeling. The consultant must have excellent Python and PySpark coding skills, strong SQL/Data Modeling experience, and experience working in the Banking/Financial Services domain.

Key Responsibilities

• Design conceptual, logical, and physical data models for banking data.
• Develop and optimize scalable data pipelines using Python, PySpark, and SQL.
• Perform SQL Data Modeling and JSON Data Modeling for structured and semi-structured data.
• Perform data transformation, integration, mapping, and quality validation.
• Translate business requirements into data models and engineering solutions.
• Write, optimize, and troubleshoot Python and PySpark code for large-scale data processing.
• Optimize data processing and troubleshoot pipelines for performance and scalability.

Mandatory Skills

• 8+ years of experience in Data Engineering and Data Modeling.
• Strong hands-on coding experience in Python.
• Strong hands-on coding experience in PySpark.
• Strong SQL Data Modeling / JSON Data Modeling experience.
• Strong SQL and ETL/ELT experience.
• Strong knowledge of conceptual, logical, and physical data modeling.
• Experience with dimensional modeling and data warehouse concepts.
• Experience with large-scale data processing and modern data platforms.

Ideal Candidate: We are looking for one consultant who can perform both Data Modeling and Data Engineering, with a strong emphasis on hands-on Python and PySpark development. The candidate should have practical experience with SQL and JSON data modeling. This is not a pure Data Modeler role.