Summer Student, Data Integration (Calgary)

Summer Student, Data Integration (Calgary)

17 Nov
|
Trimac Transportation
|
Calgary

17 Nov

Trimac Transportation

Calgary

OverviewTrimac 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.ScheduleThis 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 DetailsThis 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 AreNobody 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 itAPIs: calling RESTful or other APIs, usually from PythonSQL and relational databases: querying and moving data in and out of databasesPower BI: building reports; DAX is a bonusSnowflake: or another cloud data warehouseSSIS / SSAS: making small changes to existing packages or modelsGit and version control: branches, pull requests, build pipelines and working on shared code without overwriting others' changesChange control: following a process for reviewing, approving and releasing changesAI and LLM tools: using assistants to code, document and analyze more effectivelyTechnical documentation: writing down how a report, ETL or process works so others can maintain itMessy data and business rules: working with poorly explained tables and inconsistent data, and meeting people to learn how it's usedResponsibilitiesPower BI reportingBuild recent Power BI reports and dashboards with the business teams who use themMigrate existing reports to our new Snowflake data architecture, and modify them as neededDocument the logic behind existing reports so the team can decide what to keep, rebuild or retirePipeline monitoring and alertingMonitor our data pipelines and ETL jobs (Python, SSAS,



SQL Procedures)Build automated alerts that flag failures quickly and route them to the right peopleHelp find the cause of failures and recurring problemsAutomation and data movementBuild new automations and data pipelines, mainly in Python and SQL, that move data into and out of our databasesReview teammates' code and have yours reviewed through pull requestsDeploy changes through our build pipelines and change control processAcross all of itMeet with people across the business to understand undocumented or inconsistent data and business rulesWrite clear documentation for the work you deliverPresent what you built to the team at the end of your termWhat you'll learnHow a modern data platform works from end to end, from source systems through ETL to Snowflake and Power BIHow a professional team ships code safely, with Git, pull requests, automated builds and change controlHow to use AI tools like LLM assistants well and responsibly on real work, with company-provided licensesHow to turn messy, poorly documented data into something the business can trustHow a North American transportation company runs, and how data supports its operationsYou'll have a dedicated mentor on the team and regular check-ins. You'll work on real projects from your first weeks.QualificationsCurrently enrolled in a post-secondary program in Computer Science, Software Engineering, Data Science, Information Systems, Business Analytics or a related fieldWorking knowledge of some of the below technologiesCuriosity and persistence when data doesn't make sense, and comfortable asking questions to find out whyClear written and spoken communication, including explaining technical work to people who aren't technicalLegally eligible to work in CanadaSafety CommitmentsWe make safety a part of every decisionWe make safety personalWe have the courage to intervene

📌 Summer Student, Data Integration (Calgary)
🏢 Trimac Transportation
📍 Calgary

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: summer student, data integration (calgary) / calgary