Senior Oracle EBS Tech Analyst – R12, GL & Integrations

SMX; Lansing (MI); On-site; USD 73,000 - 122,000; Full time

Benefits offered by this job

Health insurance

Paid leave

Retirement

Job summary

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications in Lansing, MI. You will design and develop custom applications, reports, and workflows within Oracle EBS and build interfaces for data migration and integration using XML Publisher or APIs.

The role requires strong SQL/PLSQL skills, Oracle EBS architecture knowledge, and experience with EBS R12 and core financial modules (GL, AP, AR).

Qualifications

• Active clearance or public trust (sponsor dependent).
• Proficiency in SQL and PL/SQL, with experience in Oracle EBS development tools and a strong understanding of the EBS application architecture.
• Oracle EBS core financial accounting knowledge with a concentration in GL, Cash Management, and Treasury Management modules experience to include financial accounting experience for transition of legacy financial statements and interrelated data functionality from legacy system to the modules.
• Strong analytical and problem-solving skills to troubleshoot and resolve technical and functional issues.
• A good grasp of business processes, especially in areas like financials (AP, AR, GL) or other functional modules.
• Experience with data integrity, system optimization, and working within a Software Development Lifecycle (SDLC).
• A bachelor’s degree in computer science, information technology, or a related field.
• Minimum of 15 years’ experience. Directly related postgraduate study may be substituted for experience at the rate of three credit hours for three months of experience up to 36 credit hours.
• Oracle APEX experience (or similar report writer).
• Oracle E-Business Suite R12 experience.
• Procurement and projects costing module experience.

Responsibilities

• Development and customization: Design and develop custom applications, reports, extensions, and workflows within Oracle EBS to meet business needs.
• Integration: Build and maintain interfaces for data migration and integration with other systems, often using tools like XML Publisher or APIs.
• Technical support: Provide day-to-day support, troubleshoot issues, and perform root cause analysis for the Oracle EBS environment.
• System administration: Perform system analysis, conduct upgrades, and ensure system performance, stability, and data integrity.
• Testing: Perform functional testing and debugging of RICE (Reports, Interfaces, Conversions, Extensions) components.
• Documentation: Create and maintain detailed documentation for all development processes and solutions.

Skills

SQL

PL/SQL

Oracle EBS development tools

EBS architecture knowledge

Financials modules (GL, AP, AR)

SDLC experience

Analytical thinking

Education

Bachelor's degree in CS/IT or related field

15 years of experience (or postgraduate substitute)

Tools

Oracle APEX

Oracle E-Business Suite R12

XML Publisher or APIs

Procurement and projects costing module

Job description

SMX is seeking accomplished Associates to develop, customize, and maintain Oracle E-Business Suite applications in Lansing, MI. You will design and develop custom applications, reports, and workflows within Oracle EBS and build interfaces for data migration and integration using XML Publisher or APIs.

The role requires strong SQL/PLSQL skills, Oracle EBS architecture knowledge, and experience with EBS R12 and core financial modules (GL, AP, AR).