SyteLine Programmer/Analyst

ASTEC; Canada; Remote; CAD 70,000 - 90,000; Full time

Job summary

A leading machinery manufacturing company is seeking a Programmer Analyst to support their corporate IT team. This hybrid role focuses on designing, developing, and maintaining customized ERP systems. Responsibilities include troubleshooting ERP systems, managing SQL databases, and enhancing business processes. The ideal candidate will have 2-5 years of experience with Infor SyteLine, a Bachelor's degree is preferred, and strong SQL skills are essential. This role offers the flexibility of remote work from Canada or the US.

Qualifications

• 2 – 5 years’ experience with Infor SyteLine 8.03.20 in an admin role.
• Basic understanding of business practices like accounting and sales.
• Self-motivated with the ability to work independently.
• Experience at a publicly traded company preferred.

Responsibilities

• Troubleshoot and enhance ERP systems.
• Manage SQL databases and custom applications.
• Analyze and improve business processes for efficiency.
• Collaborate with IT team for technical issue resolution.

Skills

SQL proficiency

MS SQL Management Studio

SSRS Tools

Crystal Decisions reporting Tools

Interpersonal skills

Communication skills

Problem-solving

Education

Bachelor's degree in computer science or information systems

Tools

Microsoft Office

Job description

ABOUT THE POSITION

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.

LOCATION

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.

Key Activities & Responsibilities

• Develop and optimize SQL queries for Syteline ERP.
• Serve as Subject Matter Expert (SME) for Infor Syteline ERP system.
• Administer SQL databases; maintain Crystal Decisions and SSRS reports.
• Analyze and improve business processes and reporting to drive efficiency.
• 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.

To be successful in this role, your experience and competencies are:

• 2 – 5 years’ experience with Infor SyteLine 8.03.20 in an admin type role.
• Basic understanding of business practices, including accounting, procurement, sales, and production cycles.
• 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.
• Must have experience with Crystal Decisions reporting Tools.
• Working knowledge of Microsoft Office.
• Experience at a publicly traded company and SOX compliance is preferred.
• Must be highly self-motivated.
• Ability to work independently with minimal supervision is required.
• Must be able to solve problems at both a strategic and functional level.
• Must be able to organize and manage multiple projects and priorities.
• Strong interpersonal skills and communication skills are required.
• Must be able to work satisfactorily as a team member.
• Ability to write reports, business correspondence, and procedure manuals is required.
• Ability to communicate orally and in written form in English.
• An understanding of manufacturing custom heavy gauge steel products is helpful.
• Strict adherence to corporate IT SOPs, including change management.
• Maintain effective communication with leaders and team members.
• Provide exceptional customer service for reported application issues – researching and identifying problems and working with IT and business towards a quick and appropriate resolution.

Our Culture and Values

• Continuous devotion to meeting the needs of our customers.
• Honesty and integrity in all aspects of business.
• Respect for all individuals.
• Preserving entrepreneurial spirit and innovation.
• Safety, quality and productivity as means to ensure success.

EQUAL OPPORTUNITY EMPLOYER

As an Equal Opportunity 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.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• Machinery Manufacturing