T
Data Modeler
Tredence
Sherbrooke · On-site Full-time Senior Today
About the role
About
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
Skills
ER modelingETLERwinER/StudioInformation SystemsOraclePowerDesignerPostgreSQLSQLSQL ServerStar schemaSnowflake schemadata modelingdata warehousingdimensional modeling
Don't send a generic resume
Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.
Get started free