ERP Program Analyst — SQL, Power BI & QAD MFGPRO

Stabilus; Farmington Hills (MI); On-site; USD 70,000 - 100,000; Full time

Job summary

ACE Controls, Inc., a Stabilus company, in Farmington Hills, MI, seeks an ERP Program Analyst to oversee ERP management, backups, recovery and documentation across Progress and QAD MFGPRO ERP systems.

The ideal candidate has a Bachelor’s in Technology or BIS and 5–10 years of related experience, with hands-on SQL, Power BI and OpenEdge ABL programming, and a collaborative mindset within a global IT team.

Qualifications

• Bachelor's Degree in Technology or Business Information Systems.
• 5-10 years related experience, and/or training, or equivalent combination of higher education, certification and experience.
• Experience with ERP systems (QAD MFGPRO) and database management is preferred.

Responsibilities

• Serves as a technical resource to managers and other staff, both IT and non-IT, on both the Progress database and the QAD MFGPRO ERP system.
• Maintains ERP databases and monitors and troubleshoots system and end user issues.
• Develops and/or runs both routine and end user ERP reports.
• Manages budget requirements with supervision of leadership.
• Consults and/or contracts with necessary outside vendors within the approved budget.
• Maintains and develops documentation for all projects implemented.
• Along with other IT staff, provides technical assistance to all end users on all user issues.
• Consults with other IT employees within the global technology team regarding the ERP systems, relative to both hardware and software.
• Technical project management of ERP and IT related initiatives.
• Comfortable programming in SQL, Power Bi, and OpenEdge Advanced Business Language (ABL – Progress 4GL) to customize reports based on organizational needs.
• Functions as a working member of the global IT team to meet global ERP standards and effect manufacturing process improvements.

Skills

SQL

Power BI

OpenEdge ABL (Progress 4GL)

ERP management

Budget management

Documentation

Education

Bachelor's Degree in Technology or Business Information Systems

Tools

QAD MFGPRO ERP

Progress database

Job description

ACE Controls, Inc., a Stabilus company, in Farmington Hills, MI, seeks an ERP Program Analyst to oversee ERP management, backups, recovery and documentation across Progress and QAD MFGPRO ERP systems.

The ideal candidate has a Bachelor’s in Technology or BIS and 5–10 years of related experience, with hands-on SQL, Power BI and OpenEdge ABL programming, and a collaborative mindset within a global IT team.