Data Modeler

Tredence Inc.; Canada; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading data solutions company in Canada is seeking a detail-oriented Data Modeler to design, develop, and maintain data models that support business processes and analytics. The ideal candidate will collaborate with data engineers and stakeholders to ensure data consistency and scalability. The position requires a bachelor's degree and over 10 years of experience in data modeling or database design. The company offers opportunities for professional growth and innovation.

Qualifications

• 10+ years of experience in data modeling or database design.
• Strong knowledge of data modeling techniques (ER modeling, dimensional modeling).
• Understanding of data warehousing concepts and ETL processes.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Translate business requirements into efficient data structures.
• Develop data models for data warehouses, data lakes, and transactional systems.

Skills

Data modeling techniques

SQL

Analytical skills

Problem-solving skills

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

ER/Studio

ERwin

PowerDesigner

SQL Server

Oracle

PostgreSQL

Job description

We are looking for a detail-oriented Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business processes and analytics. The ideal candidate will work closely with data engineers, analysts, and business stakeholders to ensure data is structured, consistent, and scalable.

Key Responsibilities

• Design and maintain conceptual, logical, and physical data models
• Translate business requirements into efficient data structures
• Develop data models for data warehouses, data lakes, and transactional systems
• Define relationships, keys, indexes, and constraints for optimal performance
• Ensure data consistency, integrity, and quality across systems
• Collaborate with data engineers to implement models in databases and pipelines
• Optimize database performance through proper modeling techniques
• Maintain data dictionaries, metadata, and documentation
• Support data governance and standardization initiatives
• Work with BI/reporting teams to enable analytics and reporting solutions

Required Skills & Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or related field
• 10+ years of experience in data modeling or database design
• Strong knowledge of:
• Data modeling techniques (ER modeling, dimensional modeling)
• Star schema and snowflake schema design
• SQL and relational databases (e.g., SQL Server, Oracle, PostgreSQL)
• Experience with data modeling tools (e.g., ER/Studio, ERwin, PowerDesigner)
• Understanding of data warehousing concepts and ETL processes
• Strong analytical and problem-solving skills