Data Modeler

J.D. Irving; Dieppe; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading transportation company in Dieppe is seeking a Data Modeler to enhance customer experience and modernize operations. This role involves designing scalable data models, collaborating with cross-functional teams, and transforming data into actionable insights using Power BI. Ideal candidates will have a degree in a related field with over 3 years of relevant experience, proficiency in SQL, and skills in data modeling. The company offers perks such as health plans, paid vacation, and growth opportunities within a dynamic work environment.

Benefits

Flexible health, drug, dental, and vision plan

RRSP matching program

Employee & Family Assistance Programs

Health & Wellness reimbursements

3 weeks' paid vacation

Free parking

Onsite fitness center

Onsite cafeteria

Maternity leave top‑up program

Qualifications

• 3+ years of relevant experience.
• Bachelor's degree in business, engineering, or computer science.
• Proven experience in dimensional data modeling or data architecture.
• Experience in the Transportation Industry is an asset.
• Microsoft Certified: Power BI Data Analyst Associate is an asset.

Responsibilities

• Design and optimize reusable data assets across business domains.
• Document data assets for governance and maintenance.
• Transform data into actionable insights using Power BI.
• Coach and mentor analysts in best data practices.

Skills

Dimensional data modeling

SQL querying

Power BI reporting

Problem-solving with data

Strong communication skills

Teamwork

Education

University degree in business/engineering/computer science

Tools

Power BI

Job description

Midland Transport is on an exciting transformation journey to improve customer experience and modernize our operations.As we kick this off, we are seeking a Data Modeler to join our Transformation Team. Located in the Irving Building in Dieppe and reporting to the Senior Analytics Lead, this role shapes the trusted data foundation that powers insights and decision‑making across the business. You will design, develop, and document scalable data models; partner closely with cross‑functional teams across the business; and refine models for accuracy, performance, and reusability. If you’re ready to turn complex data into meaningful outcomes that help drive results, this role offers the opportunity to make a tangible impact.

• Adynamic, safe, and rewarding work environment
• A flexible health, drug, dental, and vision plan
• RRSP matching program
• Employee & Family Assistance Programs
• Health & Wellness reimbursements include gym memberships, fitness classes or online workout programs
• 3 weeks' paid vacation
• Free parking, an onsite fitness center open 24/7, and an onsite cafeteria
• Maternity leave top‑up program
• Growth and progression opportunities within Midland Transport and large network of the JD Irving group of companies

Responsibilities

• Design, develop, and optimize reusable and standardized data assets across multiple business domains
• Partner with data architects, data solutions developers, and business stakeholders to ensure models fit seamlessly into our Data Lakehouse architecture and are aligned to Midland’s data strategy
• Document data assets so they can be easily understood, governed, and maintained
• Engage in ongoing skill development to sharpen technical depth and keep your toolkit modern

Insight Enablement & Analytics

• Transform data into actionable insights by designing and developing Power BI assets
• Monitor asset performance and optimize models and visuals to improve reliability and usage
• Maintain documentation for models, reports, and insights and set role‑based access to ensure secure consumption

Community, Coaching, and Standards

• Coach and mentor analysts and data consumers, identifying coaching opportunities and building capability across the broader analytics community
• Champion best practices in data modeling, documentation, and asset reusability

Qualifications

• You have 3+ years of relevant experience
• University degree (business/engineering/computer science) or a related field
• Proven experience in dimensional data modeling, data architecture, or a similar role
• Proven ability to solve problems using data‑driven insights
• Proficient in querying data with SQL
• Proficient in designing and implementing reporting solutions in various business intelligence tools (Power BI preferred)
• Strong written and verbal communication skills
• Ability to work independently and as part of a teamPassion for learning and continuous improvement
• Experience in the Transportation Industry is considered an asset
• Microsoft Certified: Power BI Data Analyst Associate (or equivalent certification) is considered an asset

About the Team

At Midland, we’re not just moving freight — we’re building the next generation of transportation. We’ve been one of the most trusted carriers in Canada and the United States for over 55 years. We are driven by superior quality service, innovation, and a commitment to excellence. We’re investing in technology to deliver measurable customer‑focused solutions, and we’re also committed to sustainability and growth.

Joining Midland means becoming part of a dynamic company that values safety, continuous improvement, and results. Our employees are the driving force behind our success, and we’re proud to foster a workplace where talent thrives, ideas are valued, and careers are built for the long haul. Whether on the road or in a service centre or office, every Midland employee helps build lasting relationships with our customers. We’re looking for motivated and skilled people who want to contribute to our high‑performing team and be part of a business that is growing, evolving, and setting the standard in transportation and logistics.

Let’s drive success together.

About Us

Founded in 1882, J.D. Irving, Limited (JDI) has operations in Canada and the United States and are a team of 20,000 dedicated employees. At J.D. Irving, Limited, you are part of a dynamic team of professionals who lead with integrity and are passionate about delivering results. With a culture that nurtures talent and creates an inclusive workplace, you can grow your career across our various operating divisions.

We are committed to creating accessible environments for our colleagues, candidates, and customers. Requests for accommodation due to a disability (which may be visible or invisible, temporary, or permanent) can be made at any stage of application and employment. We encourage candidates to make their accommodation needs known so that we can provide equitable opportunities.

Worried you do not meet all the requirements? Studies have shown that many applicants apply only to job opportunities when they feel they meet 100% of the criteria. We promote an inclusive environment where everyone is appreciated, recognized, and empowered to contribute fully. If you are interested in this position but are worried you did not meet all the requirements, we would encourage you to still apply.

We appreciate your interest in our company however only those candidates selected for an interview will be contacted.

Job Info

• Job Identification 7607
• Job Category Data Analytics/Warehousing & Business Intelligence
• Posting Date 01/09/2026, 02:35 PM
• Job Schedule Full time
• Locations 100 Midland Drive, Dieppe, NB, E1A 6X4, CA