Analyst, Programmer

Trimac Transportation System; Calgary; On-site; CAD 90,000 - 120,000; Full time

Job summary

Trimac Transportation System in Calgary seeks a Programmer Analyst to support and enhance core ERP systems, focus on SQL development, ETL, and integrations. You’ll work with operational teams to resolve data and system issues, maintain C# applications and APIs, and contribute to upgrades and integrations.

This role emphasizes hands-on work with enterprise systems, data processing, and backend stability, not BI or frontend development.

Qualifications

• Bachelor's degree in CS/IT or related field required.
• 3–5+ years in SQL-focused ERP/systems support.
• Experience with integrations and enterprise applications.

Responsibilities

• Support, maintain, and enhance Trimble ERP systems (TMW Suite, TMT Fleet Maintenance).
• Troubleshoot complex production and data issues and implement backend fixes.
• Design, build, and maintain integrations (B2B/EDI, API, file-based).
• Develop and optimize T-SQL queries and database objects; maintain SSIS packages.
• Create and maintain SSRS reports for operational needs.
• Develop and maintain C#/.NET applications and APIs.
• Assist with ERP upgrades and module implementations.
• Collaborate with stakeholders and vendors; participate in on-call rotation.

Skills

Problem solving

Data integrity

Communication

Independence

Enterprise systems

Education

Bachelor's degree in Computer Science, Information Technology, or related field

Tools

SQL Server

SSIS

SSRS

C# / .NET

Git

Job description

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 position is Monday to Friday, with a requirement to be available for on-call support for two weeks every two months to support business operations. This is a 12-month contract position.

Job Details

Reporting to the Supervisor, Integrations and Application Support, the Programmer Analyst plays a key role in supporting and enhancing our core business systems, with a strong focus on ERP platforms, data processing, and system integrations.

This role is centered on backend system reliability, SQL development, and integration workflows. You will work closely with operational teams to resolve complex data and system issues, build and maintain integrations, and support ongoing system improvements and upgrades. In addition to SQL and integration work, you’ll contribute to maintaining and enhancing a set of internally developed C# applications and APIs that support data processing and system integrations.

This is not a BI/analytics, data science, or front-end/web development role. Instead, it is ideal for someone who enjoys working deeply with enterprise systems, data, and integrations in a hands-on, problem-solving environment.

Responsibilities

The responsibilities of this role include, but are not limited to:

• Support, maintain, and enhance Trimble ERP systems (TMW Suite, TMT Fleet Maintenance, and related tools)
• Troubleshoot and resolve complex production and data issues, including backend data fixes resulting from system bugs
• Design, build, and maintain integrations (B2B/EDI, API-based, and file-based data exchanges)
• Develop, optimize, and maintain T-SQL stored procedures, queries, and database objects
• Build and support SSIS packages for ETL and data movement processes
• Develop and maintain SSRS reports to support operational needs
• Create and maintain PowerShell and Python scripts for automation, data extraction, and file processing (non-analytics use cases)
• Maintain and enhance C#-based applications and APIs that support integrations and backend processing
• Troubleshoot and debug issues in existing .NET applications as part of production support
• Support ERP upgrades, module implementations, and system enhancements
• Investigate and resolve integration and data flow issues across systems and partners
• Collaborate with business stakeholders to translate operational requirements into technical solutions
• Work with vendors and external consultants on system support and project delivery
• Participate in an on-call support rotation (approx. one week/month) and occasional planned after-hours work for upgrades

Qualifications

What You’ll Bring:

• Strong problem-solving skills with a focus on root cause analysis and data integrity
• Ability to manage multiple priorities in a fast-paced, operational environment
• Clear communication skills and the ability to work with both technical and non-technical stakeholders
• A self-starter mindset with the ability to work independently and collaboratively
• Experience supporting and maintaining enterprise business systems

Technical Expertise

Required

• Strong experience with Microsoft SQL Server (2019+) and advanced T-SQL development
• Hands-on experience with SSIS (ETL/data integration)
• Experience developing and maintaining SSRS reports
• Experience troubleshooting production issues and data-related problems in enterprise systems

Nice to Have

• Experience with Trimble platforms (TMW Suite, TotalMail, TMT Fleet Maintenance)
• Experience with integration platforms such as Cleo Integration Cloud, Digibee, or similar B2B/EDI tools
• Experience working with API integrations and file-based data exchange
• Familiarity with PowerShell and/or Python for automation and data processing (non-BI use cases)
• Experience with C# / .NET for backend applications and APIs
• Experience with version control tools (e.g., Git)

Who You Are

What You’ll Need:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience)
• 3-5+ years of experience in a SQL-focused, ERP, or systems support role
• Proven experience working with integrations and enterprise applications

Safety Commitments

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