Summer Student, Data Integration

Overview

Trimac isn't just a transportation company; it's an industry disruptor with a remarkable 80-year legacy of safely delivering products that improve people’s lives across North America.

Our workplace culture is centered on being safe, respectful, innovative and inclusive. We are committed to maintaining a rewarding work environment that allows employees to experience new opportunities and build their chosen careers. Across the company, we encourage open communication, champion integrity, celebrate individuality and cultivate diverse talents and perspectives. If you’re ready for a challenge that will help drive forward an industry leading team, we invite you to begin your journey with us.

Schedule

• This is a full-time summer student position working 40 hours per week, Monday through Friday.
• The successful candidate will be required to work in the office four (4) days per week, with one day per week eligible for remote work in accordance with company guidelines.
• The position is based at Trimac's corporate office and requires regular collaboration with team members and stakeholders across the organization.

Job Details

This Summer Student opportunity offers hands-on experience working alongside our IT team, including software developers, data engineers, data architects, and data analysts. You'll contribute to meaningful projects that support the business, such as developing reports, monitoring data quality, supporting automated processes, and helping improve data flows between systems.

As Trimac continues its migration to Snowflake, this is an exciting opportunity to gain exposure to modern data platforms and technologies. We will tailor projects and learning opportunities to align with your current skills, academic background, and career interests. You are not expected to have experience with every technology or responsibility listed below, but you should be eager to learn, collaborate, and contribute in a professional team environment.

Who You Are

Nobody has all of these. Tell us which ones you have and which ones you'd like to learn, and we'll shape your projects around them.

• Python: our newer ETLs and many of our automations are written in it

• APIs: calling RESTful or other APIs, usually from Python

• SQL and relational databases: querying and moving data in and out of databases

• Power BI: building reports; DAX is a bonus

• Snowflake: or another cloud data warehouse

• SSIS / SSAS: making small changes to existing packages or models

• Git and version control: branches, pull requests, build pipelines and working on shared code without overwriting others' changes

• Change control: following a process for reviewing, approving and releasing changes

• AI and LLM tools: using assistants to code, document and analyze more effectively

• Technical documentation: writing down how a report, ETL or process works so others can maintain it

• Messy data and business rules: working with poorly explained tables and inconsistent data, and meeting people to learn how it's used

Responsibilities

Power BI reporting

• Build new Power BI reports and dashboards with the business teams who use them

• Migrate existing reports to our new Snowflake data architecture, and modify them as needed

• Document the logic behind existing reports so the team can decide what to keep, rebuild or retire

Pipeline monitoring and alerting

• Monitor our data pipelines and ETL jobs (Python, SSAS, SQL Procedures)

• Build automated alerts that flag failures quickly and route them to the right people

• Help find the cause of failures and recurring problems

Automation and data movement

• Build new automations and data pipelines, mainly in Python and SQL, that move data into and out of our databases

• Review teammates' code and have yours reviewed through pull requests

• Deploy changes through our build pipelines and change control process

Across all of it

• Meet with people across the business to understand undocumented or inconsistent data and business rules

• Write clear documentation for the work you deliver

• Present what you built to the team at the end of your term

What you'll learn

• How a modern data platform works from end to end, from source systems through ETL to Snowflake and Power BI

• How a professional team ships code safely, with Git, pull requests, automated builds and change control

• How to use AI tools like LLM assistants well and responsibly on real work, with company-provided licenses

• How to turn messy, poorly documented data into something the business can trust
• How a North American transportation company runs, and how data supports its operations
• You'll have a dedicated mentor on the team and regular check-ins. You'll work on real projects from your first weeks.

Qualifications

• Currently enrolled in a post-secondary program in Computer Science, Software Engineering, Data Science, Information Systems, Business Analytics or a related field

• Working knowledge of some of the below technologies

• Curiosity and persistence when data doesn't make sense, and comfortable asking questions to find out why

• Clear written and spoken communication, including explaining technical work to people who aren't technical

• Legally eligible to work in Canada

Safety Commitments

• We make safety a part of every decision
• We make safety personal
• We have the courage to intervene