Data Modeler

J.D. Irving; Saint John; On-site; CAD 70,000 - 100,000; Full time

Job summary

J.D. Irving in Saint John, NB, is seeking a Data Modeler to design and govern enterprise data models that empower analytics and enable self-service reporting across business units.

You will collaborate with stakeholders to translate data needs into scalable models, maintain data integrity, document specifications, and stay current with industry trends in data modeling.

Qualifications

• Bachelor's degree in CS or related field with data modeling emphasis.
• 3–5 years of data modeling experience.
• Proficiency in ERD, UML, and advanced data modeling software.
• Strong SQL skills and relational database knowledge.
• Experience with big data technologies is advantageous.

Responsibilities

• Design and govern enterprise semantic data models for analytics.
• Create scalable data models to enable self-service reporting.
• Collaborate with stakeholders to translate data needs into models.
• Maintain data integrity across diverse data sources and systems.
• Document data model specifications and updates.
• Apply normalization, denormalization, and partitioning best practices.
• Optimize data storage and retrieval with data engineers and analysts.
• Conduct data model reviews and identify improvements.
• Stay current with data modeling trends.
• Provide guidance on data-related queries across teams.

Skills

Data modeling

SQL

Analytical thinking

Communication

Big data concepts

Education

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

Tools

ERD tools

UML

Data modeling software

Job description

• Business Unit Construction & Equipment Divisional Services

Saint John, NB, Canada

Job Description

As our Data Modeler, you'll be instrumental in creating and maintaining models that empower our business operations and analytics. Your data models will ensure accurate, reliable, and scalable data access, enabling self-service reporting and trusted metrics across various business units.

This key position will collaborate closely with stakeholders, translating their data needs into effective business models and help support driving data-driven decision-making throughout the organization.

Responsibilities

• Design and govern enterprise semantic data models, ensuring a unified and reliable data foundation for analytics.
• Create scalable data models to facilitate self-service reporting and trusted metrics across business units.
• Collaborate with stakeholders to understand their data requirements and translate them into efficient data models.
• Maintain data integrity and consistency across diverse data sources and systems.
• Document and update data model specifications, ensuring accessibility and transparency.
• Apply data modeling best practices, including normalization, denormalization, and data partitioning.
• Optimize data storage and retrieval processes in collaboration with data engineers and analysts.
• Conduct regular data model reviews, identifying areas for improvement and enhancement.
• Stay abreast of industry trends and emerging technologies in data modeling and analytics.
• Provide support and guidance to other teams on data-related queries, ensuring a smooth and efficient data environment.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field, with a focus on data modeling and database design.
• 3-5 years of experience in data modeling, with a proven track record of creating effective and scalable data models.
• Proficiency in data modeling techniques and tools, including ERD, UML, and advanced data modeling software.
• Strong understanding of relational databases and SQL, with the ability to write complex queries and optimize database performance.
• Experience with big data technologies and distributed systems is highly advantageous.
• Excellent analytical and problem-solving skills, with a track record of delivering innovative data solutions.
• Exceptional communication skills, enabling you to explain complex data concepts to both technical and non-technical audiences.
• Attention to detail and a commitment to data accuracy and quality are essential.
• Experience with data governance frameworks and practices is desirable, ensuring data integrity and compliance.
• A willingness to learn and adapt to new technologies and industry trends, staying at the forefront of data modeling advancements.

Job Info

• Job Identification 11307
• Job Category IT, Telecom & Internet
• Posting Date 07/29/2026, 07:32 PM
• Job Schedule Full time
• Locations 45 Gifford Road, Saint John, NB, E2M 5K7, CA
• Salary Range $70,000 - $100,000 undefined undefined

(Placement in the salary range will be based on relevant job-related factors like candidate experience, education, skills and qualifications. L’échelon salarial sera déterminé en fonction de facteurs pertinents liés au poste, notamment l’expérience, la formation, les aptitudes et les compétences de la personne retenue.)