ERP Solutions Analyst | SQL, Power BI & ABL Expert

Ace Controls; Farmington Hills (MI); On-site; USD 80,000 - 110,000; Full time

Job summary

Ace Controls is seeking an ERP Program Analyst to oversee ERP management, backups, and documentation from Farmington Hills, MI. The role requires deep knowledge of Progress and QAD MFGPRO ERP systems, plus hands-on SQL, Power BI and OpenEdge ABL programming to customize reports for manufacturing processes.

The ideal candidate will have 5–10 years of related experience and a Bachelor’s degree in Technology or Business Information Systems, with onsite work in a collaborative IT environment.

Qualifications

• Bachelor's degree in Technology or Business Information Systems.
• 5–10 years related experience, and/or training, or equivalent.
• Experience overseeing ERP management, backups, recovery and documentation.

Responsibilities

• Oversee ERP management including backup, recovery and documentation.
• Serve as technical resource for Progress and QAD MFGPRO ERP users.
• Develop and run ERP reports and monitor user issues.
• Manage budgets and coordinate with vendors as needed.
• Maintain ERP documentation and support global IT standards.
• Program in SQL, Power BI and OpenEdge ABL to customize reports.

Skills

SQL programming

Power BI

ERP management

IT project coordination

Budget management

Education

Bachelor's degree in Technology or Business Information Systems

Tools

Progress database

QAD MFGPRO ERP

OpenEdge ABL

Job description

Ace Controls is seeking an ERP Program Analyst to oversee ERP management, backups, and documentation from Farmington Hills, MI. The role requires deep knowledge of Progress and QAD MFGPRO ERP systems, plus hands-on SQL, Power BI and OpenEdge ABL programming to customize reports for manufacturing processes.

The ideal candidate will have 5–10 years of related experience and a Bachelor’s degree in Technology or Business Information Systems, with onsite work in a collaborative IT environment.