Oracle EBS Analyst

Position Summary

We are seeking a detail-oriented Identity & Access Governance (IAG) Analyst to support user access management, application onboarding, and access review initiatives across enterprise platforms. This role will play a key part in improving the quality, accuracy, and sustainability of access governance processes, particularly as applications are integrated with our Identity Governance and Administration (IGA) platform, Saviynt. The ideal candidate combines strong analytical skills, Oracle EBS security knowledge, experience working with large data sets, and the ability to investigate root causes through critical thinking and pattern recognition. Success in this role requires an individual who is comfortable questioning assumptions, identifying process gaps, and providing objective feedback to drive continuous improvement.

Key Responsibilities

• Analyze and validate user access and security data within Oracle EBS and related systems.
• Execute and review Oracle SQL and PL/SQL queries, including writing and modifying SELECT statements to support access governance activities.
• Perform backend analysis of Oracle EBS responsibilities, role assignments, and security configurations.
• Support application onboarding efforts into Saviynt by ensuring access models, entitlements, and user populations are accurately represented.
• Conduct user access reviews and evaluate completeness and accuracy of security data using structured methodologies.
• Investigate access-related issues by identifying patterns, behaviors, and root causes across source systems and identity governance platforms.
• Compare disparate data sets using standardized templates and analytical approaches to identify inconsistencies, gaps, and risks.
• Maintain detailed documentation of analysis performed, issues identified, and remediation actions taken.
• Develop concise status updates and findings presentations for stakeholders using PowerPoint.
• Collaborate with application owners, security teams, auditors, and governance stakeholders to improve access management processes and reporting designs.
• Provide candid, objective feedback when processes, controls, or data quality concerns are identified.
• Participate in walkthroughs and observation sessions to understand application access management processes and evaluate design effectiveness.

Required Qualifications

Technical Skills

• Experience working with Oracle Database, including: strong knowledge of Oracle PL/SQL; ability to execute and analyze SQL SELECT statements; understanding of query performance considerations and data analysis techniques.
• Experience with Oracle EBS R12 security administration concepts.
• Knowledge of Oracle EBS responsibilities, role assignments, and security models, including the ability to retrieve relevant information through backend queries.
• Strong proficiency with Microsoft Excel for data analysis and reconciliation activities.
• Experience performing data validation, completeness and accuracy reviews, and structured data comparisons.

Analytical & Business Skills

• Demonstrated ability to investigate unfamiliar systems and identify patterns, behaviors, and root causes using analytical and heuristic techniques.
• Experience applying audit-style methodologies to evaluate complex data sets and operational processes.
• Strong critical thinking skills with the ability to recognize anomalies and challenge assumptions.
• Ability to independently track work, document findings, and communicate progress and issues in a timely manner.

Professional Competencies

• Comfortable providing constructive, objective feedback when issues, inconsistencies, or process gaps are identified.
• Highly organized with strong attention to detail.
• Self-motivated learner with a desire to understand how systems operate and how processes can be improved.
• Ability to manage multiple tasks while maintaining quality and accuracy.

Preferred Qualifications

• Experience with Oracle Identity Manager (OIM).
• Experience using ServiceNow reporting capabilities to locate and analyze audit trail or request item records.
• Experience using Power Query in Excel for data transformation and automation.
• Experience working with Identity Governance and Administration (IGA) platforms such as Saviynt.
• Understanding of identity lifecycle management concepts including: Joiner-Mover-Leaver (JML) processes; user provisioning and deprovisioning; access certification and review processes; aggregation and reconciliation strategies; role and entitlement management.
• Experience conducting process walkthroughs, requirements gathering sessions, and documenting operational procedures.
• Ability to evaluate access management designs and identify gaps between intended controls and actual user populations.
• Audit, compliance, or software development experience.
• Experience collecting and managing Information Provided by Entity (IPE) and supporting defensible audit evidence documentation.

Benefits

• Supplemental benefits including medical, dental, vision, life, disability, and other insurance plans
• ESPP (employee stock purchase program)
• 401K program with company match after 12 months of tenure
• HSA (Health Savings Account on the HDHP plan)
• SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions
• Corporate discount savings program and other discounts
• On-demand training program
• Access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure
• Certification discounts and perks through associations including CompTIA and IIBA
• Dedicated customer service team for Consultants to address benefits and resource questions
• Certified Career Coach
• Welcome Packet with full list of benefits, programs, support teams, and resources