Data Modeler

Confiar Services; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

Confiar Services seeks an experienced Data Modeler to design and maintain scalable data models for payment systems within a Banking context. The role collaborates with business and technical teams to deliver accurate, efficient, and compliant data solutions.

You will design data models across conceptual, logical, and physical layers and support SQL, ETL, and data warehousing initiatives, ensuring data quality and governance throughout the data lifecycle.

Qualifications

• Strong experience in data modeling within banking/payments.
• Proficiency in SQL and relational databases.
• Experience with ERwin, ER/Studio or PowerDesigner.
• Knowledge of ETL and data warehousing concepts.
• Excellent communication and stakeholder management.

Responsibilities

• Design conceptual, logical, and physical data models.
• Translate business requirements into scalable data models.
• Support payment transaction and processing systems.
• Ensure data quality, consistency, and compliance with standards.
• Collaborate with engineering teams on SQL, ETL, and data warehouse initiatives.
• Work with stakeholders to understand and deliver business needs.

Skills

Data Modeling

Payments/Banking domain

SQL

ETL/Data Warehousing concepts

Communication & Stakeholder mgmt

Tools

ERwin

ER/Studio

PowerDesigner

Job description

We are looking for an experienced Data Modeler with a strong Banking background to design and maintain scalable, high-quality data models supporting payment systems. The ideal candidate will work closely with business and technical teams to deliver accurate, efficient, and compliant data solutions.

Key Responsibilities

• Design conceptual, logical, and physical data models.
• Translate business requirements into scalable data models.
• Support payment transaction and processing systems.
• Ensure data quality, consistency, and compliance with standards.
• Collaborate with engineering teams on SQL, ETL, and data warehouse initiatives.
• Work with stakeholders to understand and deliver business needs.

Required Skills

• Strong experience in Data Modeling.
• Hands-on experience in the Payments/Banking domain.
• Proficiency in SQL and relational databases.
• Experience with data modeling tools such as ERwin, ER/Studio, or PowerDesigner.
• Knowledge of ETL and Data Warehousing concepts.
• Excellent communication and stakeholder management skills.