16 Nov
|
Trimac Transportation
|
Alberta
16 Nov
Trimac Transportation
Alberta
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 protected, 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
#J-18808-Ljbffr
📌 Summer Student, Data Integration (Alberta)
🏢 Trimac Transportation
📍 Alberta