Data Analyst

Trimac Transportation System; Calgary; On-site; CAD 60,000 - 95,000; Full time

Job summary

An established industry player seeks a Data Analyst to join their innovative team. In this role, you'll leverage your analytical skills to develop data infrastructure and create insights that enhance operational efficiency. You'll work closely with cross-functional teams to build sophisticated analytical tools and dashboards, ensuring data integrity and compliance. This position offers the opportunity to mentor junior team members and lead impactful projects that drive the company's success. If you're passionate about data and want to make a difference in the transportation sector, this is the perfect opportunity for you.

Benefits

Medical, Dental, Vision Insurance

Paid Vacation

Paid Time Off for Volunteer Activities

Pension Plan

Tuition Reimbursement

Continuous Learning and Career Development

Qualifications

• 5+ years of experience in data/business analysis focusing on data infrastructure.
• Strong proficiency in SQL and data query languages for analysis.

Responsibilities

• Develop data infrastructure and create analytical models to improve performance.
• Lead the Business Intelligence team in managing analytical projects.

Skills

Data Analysis

SQL

Data Visualization

Problem Solving

Communication Skills

Project Management

Education

Bachelor's Degree in Data Science

Master's Degree in Data Science

Tools

Tableau

Power BI

Hadoop

Spark

AWS

Azure

Google Cloud

Excel

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.

Job Details

Seeking a Data Analyst to work with cross-functional teams to develop data infrastructure, create analytical models, and generate insights business and operations insights that will improve performance across all facets of the business. Your work will directly impact the efficiency and effectiveness of our transportation operations, commercial and go to market activities and back office functions.

Responsibilities

• Business & Operational Insights: Use knowledge of Trimac’s complex data systems and business analytics to proactively source required data, identify trends and opportunities within the data based on an understanding of Trimac’s business requirements/analytics. Create solutions and/or identify areas of improvement across all areas of our business including operations, commercial, and back office functions based on insights gleaned from analysis of our data and your understanding of our business and sector.
• Analytical Tools & Reporting: Independently build simple yet sophisticated tools, including traditional and predictive analytics, automated reporting and analysis, and visibility dashboards leveraging Excel, BI, and existing Trimac systems. Partner with business stakeholders in turning insights and recommendations into actions that improve performance through data backed decision making.
• BI Team Workflow Management: Take a leadership role within the analytics organization in managing, organizing and prioritizing the Business Intelligence (BI) team’s workflow with an agile project development approach. Ensure that the team’s efforts and time lead to timely delivery of analytical projects, focused on initiatives that can deliver the highest impact to the organization, financial or otherwise, while maintaining alignment with key business objectives and strategic initiatives.
• Team Development and Mentorship: Take an informal leadership role within the analytics and BI team, coaching and developing junior team members, working closely with the Director. Provide guidance and mentorship in areas of analysis, data sourcing, project development and management, best practices, analytical approaches and tool creation. Directly oversee the accountabilities for interns that may be brought into the group from time to time.
• Data Infrastructure, Architecture & Governance: Actively lead, maintain, and optimize the pipeline of data analytical projects, delineating between maintenance of the corporate level BI, and stakeholder specific analytics, reporting and visibility. Ensure data integrity and compliance with company data management, governance, and security is in line with the scope and breadth of projects/initiatives, updating those standards from time to time as required.
• Collaboration: Work closely with internal teams (e.g., operations, Sales, IT) to continually understand business needs, define data requirements, and deliver data solutions that improve performance.

Qualifications

• Minimum 5 years of experience in a data/business analyst role, with a focus on building and optimizing data infrastructure, analytical tools, and dashboards.

Benefits

We invest in our employee’s growth through training and development programs. We offer a comprehensive benefits package such as:

• Medical, Dental, Vision, Life Insurance, and many more health and wellness benefits
• Paid vacation, sick time, and company holidays
• Paid time off for volunteer activities to help give back to our communities
• Pension Plan
• Tuition Reimbursement Program to achieve your educational goals
• Continuous learning and career development

Who You Are

• Analytical Mindset: Strong problem-solving skills with the ability to interpret complex data sets and generate actionable business insights independently.
• Business Acumen: Understanding of financial metrics/analytics and decision making process. Experience with standard financial analysis techniques such as Internal Rate of Return (IRR), Net Present Value (NPV), and other ROI calculations, to evaluate investment opportunities/calculate returns on investment
• Transportation/Logistics Knowledge: Experience in the transportation or logistics industry.
• Communication Skills: Ability to communicate complex technical data and analytical insights in a clear, concise manner to both technical and non-technical stakeholders.
• Education: Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, Engineering, or a related field.
Preferred Skills:
• Experience with transportation management systems (TMS) or fleet management software.
• Knowledge of machine learning models or predictive analytics in the context of logistics optimization.
• Strong project management skills and the ability to lead data-centric initiatives.

• Strong proficiency in SQL and data query languages.
• Expertise in data visualization tools such as Tableau, Power BI, or similar platforms.
• Experience with big data technologies (e.g., Hadoop, Spark) and cloud platforms (e.g., AWS, Azure, Google Cloud).
• Familiarity with data integration, ETL processes, and API management.
• Advanced knowledge of Python, R, or other programming languages for data analysis and automation.
Expertise in excel with experience in statistical analysis and forecasting methods

Safety Commitments

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