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 effective 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

📌 Data Modeler (Canada)
🏢 Tredence
📍 Canada