Sql programmer Offres d'emploi - Cambridge, ON

Challenger Motor Freight Inc. is an equal opportunity employer committed to creating a diverse, inclusive, and accessible workplace. We welcome applications from women, visible minorities, Indigenous peoples, persons with disabilities, and all qualified individuals.

If you require an accommodation at any stage of the recruitment process, please contact us at [email protected] and we will work with you to meet your needs.Challenger, part of the Fastfrate Group, is a leading North American transportation and logistics provider, offering Full Truck Load (FTL) services across North America, supported by integrated logistics solutions. With advanced fleet capabilities, modern facilities, and a strong commitment to service excellence, Challenger supports a wide range of industries with safe, reliable, and efficient operations.

Employees at Challenger are part of a performance-driven culture focused on safety, innovation, and continuous improvement. Through advanced technology, ongoing training, and diverse career opportunities across driving, operations, maintenance, logistics, and administration, Challenger provides an environment where motivated individuals can build long-term, rewarding careers.Why you’ll love working here:

• A workplace where you can learn, grow, and build your career
• A culture that encourages new ideas and continuous improvement
• Supportive leaders who provide guidance while giving you autonomy
• A team-focused environment
• A competitive total-rewards package, including group benefits and a company-sponsored retirement savings plan
• Support for professional memberships, training, and certifications

The Opportunity:
This is your chance to join a team where your work truly makes an impact. In this role, you will contribute directly to the success of our customers, our operations, and the Fastfrate Group as a whole. You’ll work in a supportive environment that values collaboration, problem-solving, and continuous learning.

Role Summary:
The Analytics and Process Improvement Specialist is responsible for providing operational support, analysis, and recommendations for a variety of corporate initiatives, leveraging automation and analytics technologies. This role will also assist in the development of process strategies for projects and supporting the process improvement cycle from strategy, analysis, design, and implementation through to monitoring the effective use of new or upgraded processes.

The individual will place a high emphasis on data science practices as it relates to improvements in business decision making and process. They will also be accountable for liaising with various departments to develop action plans and create technical solutions to help address the identified opportunities. The Analytics and Process Improvement Specialist will provide customer and network analysis and recommendations to internal stakeholders.

Hours of Work:
Monday to Friday, 8:00am–4:30pm

Work Arrangement:
On-site

Position Type:
Non-Union

Employment Status:
Permanent

Compensation:
Salary Range: $70,000 to $90,000

Work Location & Environment:
300 Maple Grove Rd., Cambridge, ON Canada
Office environmentKey Accountabilities:

• Operational Analytics and Data Recommendations – 30%Leads or supports operational projects; provides analysis and data-driven recommendations as needed.Liaise with Operations team members.Leverages various Development Applications (including but not limited to SQL, Knime, etc.) to conduct deep data analysis on network performance; reports out periodicallyUnderstands the business problems we are seeking to create solutions for. Identify KPI’s required and add them to dashboards such as PowerBI. Provide support for on-demand data requests from user groups.
• Customer-Specific Lane Optimization – 30%Manage customer-specific lane optimization for Challenger’s largest customers on a regular basis.Lead monthly changeover design within the TMS system to minimize resources and ensure an optimized network.Leads in Annual Pricing Review of major customers’ business.
• Lean Process Improvement Implementation – 30%Use design thinking methodologies to identify, analyze and document current business processes.Apply Lean improvement methodologies to all initiatives, always place emphasis on the problem, not the solution.Manage process recommendation documents including presentations, process models, supporting metrics, business requirements and related impact analysis.Responsible for leading ad hoc project teams and the execution of new processes with necessary stakeholders.
• Project Management – 5%Identifies opportunities for process innovation.Creates clear project management plans and documentation for any process changes and projects.Drives the analysis, design, and modelling of business processes by conducting user interviews / meetings.Provides ongoing support to all internal and external stakeholders for all process changes including training, troubleshooting and ongoing guidance to end users.Reviews data post-implementation to measure process outcomes and impacts.
• Continuous innovation and skill development – 5%Focuses on continuous skill development and learning in following areas:Automation (UiPath, Power Automate)Change managementProject managementPython CodingR ScriptMachine Learning Data ManagementProcess MiningProcess StandardizationSix Sigma Practices
• Performs other duties as required

Qualifications
We’re looking for someone who brings:

Education & Experience:

• Bachelor’s Degree in Finance, Economics, Mathematics, Data Analytics or a related field required.
• Experience with design thinking, process improvement practices required.
• Experience with UiPath or other RPA software an asset.
• Experience in project management considered an asset.
• Experience with process simulations and standard operating procedures.
• Experience with Low Code Development applications such as Alteryx or Knime an asset.
• Experience with Microsoft Power BI an asset.
• Experience with Microsoft Visio an asset.
• Advanced Microsoft Office skills, in-depth knowledge of Excel required.
• Experience with SQL, Python and R Script considered an asset.
• Lean Six Sigma Green Belt considered an asset.

Skills & Attributes:

• Able to collaborate with a variety of stakeholders and work effectively with multiple departments, while also working independently at times to solve problems with ambiguous solutions.
• Ability to apply critical thinking and problem solving.
• Strong attention to detail.
• Time management skills: ability to prioritize and comfortable handling competing priorities.
• Resilient and adaptable to change.
• Highly developed written and verbal communication skills, with the ability to prepare and deliver presentations.

How To Apply:
If you’re interested in joining our team, please submit your application through our online career portal. We appreciate all applicants; however, only those selected for an interview will be contacted.

Disclaimer: We use some technology-based tools, which may include artificial intelligence (AI), to support application screening; however, all hiring decisions include human review.