The Programmer Analyst supports Astec Industries’ corporate IT team, focusing on the design, development, and maintenance of customized ERP and related business systems. This hybrid role combines business analysis and programming responsibilities, adapting to business needs.

Key duties include troubleshooting and enhancing ERP systems, managing SQL databases and custom applications, and supporting the transition from legacy Access databases.

This is a remote work position. The employee can be based in the US or in Canada and will be supporting our BTI site in Thornbury, Ontario, CA.

Develop and optimize SQL queries for Syteline ERP.

Serve as Subject Matter Expert (SME) for Infor Syteline ERP system.

Administer SQL databases; Provide / maintain Crystal Decisions / SSRS reports and Microsoft SQL server – administer SQL databases and be proficient in writing SQL queries.

Develop an understanding of all business processes and functions (including sales, production scheduling, manufacturing, order fulfillment, transfer orders, multi-currency, multi-site operations and inventory control) and the IT systems and applications that support those business functions.

Analyze, develop, implement, and maintain new processes, procedures, and reporting data to support the business in driving efficiency and strategic decision making.

Collaborate with Astec IT team to troubleshoot and resolve technical issues within Syteline or other systems.

Learn,



maintain and administer additional custom applications that use Syteline data.

Evaluate business data to identify areas for improvement and partner with leadership to implement solutions.

Bachelors' degree in computer science, information systems, OR comparable experience is preferred.

Must be proficient in SQL.

Must have experience with MS SQL Management Studio and SSRS Tools.

Working knowledge of Microsoft Office.

Ability to work independently with minimal supervision is required.

Must be able to organize and manage multiple projects and priorities.

Ability to communicate orally and in written form in English.

Strict adherence to corporate IT SOPs, including change management.

Provide exceptional customer service for reported application issues – researching and identifying problems and working with IT and business towards a quick and appropriate resolution.

Continuous devotion to meeting the needs of our customers.

Safety, quality and productivity as means to ensure success.

As an Equal Prospect Employer, Astec does not discriminate on the basis of race, creed, color, religion, gender (sex), sexual orientation, gender identity, marital status, national origin, ancestry, age, disability, citizenship status, a person’s veteran status or any other characteristic protected by law or executive order.

Mid-Senior level

Full-time

Information Technology

📌 Applications Support Analyst - Remote (Ottawa)
🏢 ASTEC
📍 Ottawa