Sr. IT Business Analyst

L&L Products•Romeo, MI

17h

About The Position

The Senior IT Business Analyst identifies opportunities to use information systems and technologies to improve the company and supports its business applications and PC applications. The role works with business departments to design, develop, test, train, and coordinate implementations of enhancements to existing applications and new applications. It also undertakes projects, develops and maintains application procedures, supports IT standards and general computer controls, and collaborates with team members to deliver high-quality customer support. The position is responsible for keeping current in its field through appropriate training and seminars. The business applications currently include Oracle, Loftware label printing, EDI processing, and custom applications. Supported PC applications currently include Microsoft Word, Excel, PowerPoint, Access, Visual Basic, Central Desktop, and other applications implemented at L&L Products. The role develops ad-hoc SQL queries and/or programming and supports Oracle EBS, with a concentration in Oracle R12.2.x. The job requires a bachelor's degree in Information Technology, Computer Science, or Engineering and 15 or more years of IT experience in Oracle ERP/CRM/Financials environments in automotive OEM and supplier manufacturing and supply-chain-focused industries. Relevant expertise includes end-to-end business process flows, Oracle applications and implementation/support, EDI transactions, SQL, and AIM methodology and RICE requirements design.

Requirements

Bachelor’s degree in Information Technology, Computer Science, or Engineering.
15 or more years of Information Technology experience in an Oracle ERP/CRM/Financials environment across automotive OEM and supplier automotive manufacturing and supply-chain-focused industries.
Subject matter expertise in end-to-end business process flows following industry best practices for order-to-cash, procure-to-pay, demand-to-build, financials, and planning.
Experience with ad-hoc SQL queries and strong knowledge of EBS applications, with a concentration in Oracle R12.2.x.
Experience understanding and setting up EDI transactions in Oracle for customers and suppliers.
Expertise in AIM Methodology and proficiency in designing requirements for RICE.
Ability and responsibility to keep current in the field.

Nice To Haves

Experience in an Oracle R12.2 upgrade.
Hands-on experience with at least two full-lifecycle Oracle implementations and production support in Oracle R12.2.x.
Experience with Oracle R12.2.x Financials modules (AP, AR, PO, GL, CM, FA, iProcurement, iSupplier) and/or Supply Chain modules (OM, INV, PLM, BOM, WIP, SCP, ASCP, PA, QA, QP, WSH, MWA, RLM).

Responsibilities

Identify opportunities to use information systems and technologies to improve the company.
Understand and support business applications on company computer systems, including Oracle, Loftware label printing, EDI processing, and custom applications.
Develop ad-hoc queries and/or programming using SQL.
Understand and support PC applications supported by the IT department, including Microsoft Word, Excel, PowerPoint, Access, Visual Basic, Central Desktop, and other implemented applications.
Work with departments to design, develop, test, train, and coordinate implementation of enhancements to existing applications and modules.
Work with departments to design, develop, test, train, and coordinate implementation of new applications and modules.
Undertake projects and participate in project teams as required.
Develop, train, use, and maintain application procedures for supported systems.
Keep current in the field, including attending training classes and seminars as appropriate.
Assist in improving and documenting standards and practices relating to IT general computer controls and procedures.
Collaborate with team members to ensure delivery of a high level of customer support.