✨ Fill and validate PDF forms with InstaFill AI. Save an average of 34 minutes on each form, reducing mistakes by 90% and ensuring accuracy. Learn more

Senior Epicor Programmer Analyst (Remote)

ASTEC Remote
senior epicor programmer analyst remote erp sql data databases team sd programmer analyst
April 9, 2023
ASTEC
Yankton, South Dakota

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Professional YANKTON, SD, Yankton, SD, US

30+ days ago Requisition ID: 2229

BUILT TO CONNECT

Astec is a global, environmentally focused infrastructure and manufacturing company of asphalt road building and aggregate processing. Our mission is to design and build the most innovative products for the industries we serve. Leveraging innovative solutions and technologies, we serve customers all over the world.

ABOUT THE POSITION

The Programmer Analyst is part of the corporate Information Technology team at Astec Industries, Inc. Reporting to the Director of Global ERP, this key position will gather requirements, design, build, and support a customized ERP as well as other critical systems that are used in the daily operation of the business. This is a hybrid role defined as 50% Business Analyst and 50% Programmer. This ratio can change with the requirements of the business. The Programmer Analyst will be relied upon to 1) assist with troubleshooting of and improvements to the ERP and any data conversions, 2) manage the SQL databases and Report Server, and 3), assist with the upkeep and phase-out of existing Access databases. This position can be remote for the candidate possessing the stated job knowledge, skills, and abilities.

Remote: This position can be remote, but must be able to travel to our site in Yankton, SD each quarter.

Key Activities & Responsibilities

  • Manage and update Kolberg-Pioneer s Access databases and other applications, including Employee Relations Department, Service Department, etc.
  • Write queries for individuals to run based on ERP tables.
  • Subject Matter Expert (SME) for Epicor and Microsoft Dynamics CRM.
  • Support the data conversion and implementation of new ERP software (currently Epicor9/Epicor10 ~ moving towards Oracle)
  • Incorporate several of the existing Access databases into the ERP system so data resides in one specific application.
  • Provide / maintain SSRS reports and Microsoft SQL server administer SQL databases and be proficient in writing SQL queries.
  • HTML and ASP coding (Visual Basic) including Visual Studio.net.
  • Develop an understanding of all business processes and functions (including sales, production scheduling, manufacturing, order fulfillment 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 Epicor or other systems.
  • Evaluate business data to identify areas for improvement and partner with leadership to implement solutions.
  • Strict adherence to corporate IT change management policy.
  • 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.

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

  • 3 - 8 years experience with Epicor 9/10 (programming, BAQs, BPMs, Dashboards, DMTs).
  • 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 (TSQL).
  • Must have experience with MS SQL Management Studio and SSRS Tools.
  • Working knowledge of Microsoft Office with expert knowledge of Access.
  • Experience at a publicly traded company and SOX compliance is required.
  • 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 and Spanish would be a plus.

Report this job

Similar jobs near me