Job Description
The Oracle Application Data Analyst will provide functional and analytical support for Oracle E-Business Suite (EBS) R12 modules within the client's enterprise environment. This position supports ongoing operations, modernization initiatives, and financial reporting efforts aligned with federal accounting, procurement, and data governance standards.
The ideal candidate will have hands-on experience across Oracle Financials, Procurement, HRMS, and Supply Chain modules, combined with strong analytical and integration skills. This role requires experience in federal financial management, SOX and FISMA compliance, and a strong understanding of data governance and audit readiness.
Key Responsibilities
Functional and Application Support
• Provide functional and data analysis support for Oracle E-Business Suite R12 modules including Financials, Procurement, HRMS, and Supply Chain Management (SCM).
• Participate in at least three full-cycle EBS implementations, including configuration, testing, data migration, and post-production support.
• Support month-end and year-end closing processes, ensuring data integrity and timeliness of financial reporting.
• Analyze and troubleshoot ERP data flows across modules; identify and resolve cross-functional data dependencies.
• Ensure compliance with SOX, OMB A-123, and FASAB standards for internal controls and audit readiness.
• Document system configurations, data mappings, and business process flows in accordance with client change management protocols.
________________________________________
Integration and System Tools
• Support integration of Oracle EBS with external systems using Electronic Data Interchange (EDI), APIs, XML Gateway, Web Services, and SFTP.
• Utilize tools such as Toad, SQL Developer, Excel (macros, Power Query), and Power BI for data analysis, visualization, and reporting.
• Develop and maintain Unix/Linux shell scripts for automation, data movement, and batch processing.
• Apply version control practices (Git, SVN) and maintain SDLC documentation aligned with federal IT standards.
• Assist with data cleansing, transformation, and validation for migration or reconciliation activities.
________________________________________
Business Analysis and Collaboration
• Conduct business requirements gathering, process mapping, and fit-gap analysis for Oracle EBS enhancements or modernization efforts.
• Translate functional requirements into technical specifications for developers and integration teams.
• Perform root cause analysis and recommend process or data quality improvements.
• Create dashboards, visualizations, and data stories to communicate business insights to program and executive stakeholders.
• Collaborate with functional, technical, and cybersecurity teams to ensure seamless operation and security compliance.
• Support User Acceptance Testing (UAT), end-user training, and post-implementation stabilization.
• Operate under Agile or Waterfall methodologies, depending on project requirements.
________________________________________
Federal Compliance and Data Governance
• Ensure data governance, integrity, and security in compliance with OMB, FISMA, FedRAMP, and Privacy Act requirements.
• Maintain alignment with NIST SP 800-53 and agency-specific IT security baselines.
• Support audit documentation, system change tracking, and continuous monitoring (ConMon) reviews.
• Ensure compliance with CFO Act, Treasury reporting, and OMB Circular A-123 controls.
• Contribute to Authority to Operate (ATO) documentation and security assessment activities.
• Interface with federal systems (e.g., DoD, Treasury, or other client components) ensuring secure data exchange and reporting.
• Utilize ServiceNow, SharePoint, and version control tools for change management, issue tracking, and documentation.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
• Bachelor’s degree in Information Systems, Business Administration, or a related field (or equivalent experience).
• 5+ years of experience as an Oracle Application Data Analyst, Functional Analyst, or similar role supporting EBS R12 modules.
• Experience with:
o At least three full-cycle Oracle EBS implementations in the past five years.
o Oracle Financials, Supply Chain, HRMS, or Projects modules.
o Month-end and year-end close processes and reconciliations.
o ERP data flows and cross-module dependencies.
o SOX compliance, audit support, and data governance.
• Proficiency with SQL, Toad, SQL Developer, Excel (macros/pivot tables), and Power BI.
• Experience integrating Oracle EBS with other systems using APIs, XML Gateway, or Web Services.
• Familiarity with Unix/Linux scripting, version control tools, and SDLC documentation.
• Ability to obtain and maintain a Public Trust clearance.
Nice to Have Skills & Experience
• Oracle E-Business Suite R12 Certified Implementation Specialist.
• Oracle Certified Professional (OCP) – Database or Developer track.
• Oracle Analytics Cloud Certified.
• Certified Business Analyst Professional (CBAP) or Agile Analyst (IIBA-AAC).
• Prior experience supporting HHS, DoD, or other federal agencies in financial or HR system environments.
• Knowledge of Federal Financial Management (FFM) processes, Procurement, and Asset Management.
• Familiarity with Oracle Scheduler, batch jobs, and automation tools.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.