Data Modeler

Midland Transport; Dieppe; On-site; CAD 75,000 - 90,000; Full time

Job summary

A leading Canadian transportation company is seeking a Data Modeler to join their Transformation Team in Dieppe. This role focuses on designing and optimizing data models that drive insights across the business, utilizing tools like Power BI. The ideal candidate will have 3+ years of experience and a degree in a related field. The position offers a dynamic work environment with rich benefits including a flexible health plan and 3 weeks' vacation, contributing to the company's commitment to excellence in logistics.

Benefits

Dynamic work environment

Flexible health, drug, dental, and vision plan

3 weeks' paid vacation

Employee & Family Assistance Programs

Onsite fitness center

Growth and progression opportunities

Qualifications

• 3+ years of relevant experience in a data-related role.
• Proven experience in dimensional data modeling and data architecture.
• Experience in the Transportation Industry is considered an asset.

Responsibilities

• Design, develop, and optimize reusable data models across business domains.
• Transform data into actionable insights by leveraging Power BI.
• Coach and mentor analysts and data consumers in the analytics community.

Skills

Data-driven problem solving

SQL querying

Reporting solutions in Power BI

Strong communication skills

Teamwork

Continuous learning

Education

University degree in business/engineering/computer science

Tools

Power BI

Job description

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.

Benefits To Joining Midland

• A dynamic, 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

Data Architecture & Modeling

• 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 team
• Passion 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 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. 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,, 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.