Oracle ERP CRS – Washington DC

AHU Technologies Inc.; Washington (District of Columbia); Hybrid; USD 100,000 - 130,000; Full time

Job summary

AHU Technologies Inc. seeks a senior BI specialist to design, develop, and maintain OTBI/BIP reports for Oracle Fusion Financials. The role covers analyzing data, building reports, and supporting ERP cloud modules for procurement and projects, with hybrid work in the DMV area.

You will collaborate with workstream leads, implement automated extractions, and contribute to quarterly cloud upgrades while ensuring end-user training and robust documentation.

Qualifications

• 5+ years with Oracle Fusion Financials.
• 4+ years developing OTBI/BIP reports.
• 4+ years with Oracle ERP Cloud.
• Deep Fusion Financials schema knowledge.
• Full lifecycle implementations with Oracle Fusion/ERP.
• Experience with modern ETL/ELT tools.
• Automated data extraction from Oracle Fusion using native tools.
• Experience with reconciliation automation and audit trails.
• Proficient with enterprise BI reporting.
• Experience with Oracle Integration Cloud is a plus.

Responsibilities

• Design, develop, maintain and deliver dashboards and reports.
• Create, test and deploy OTBI/BIP reports and data extracts.
• Support day-to-day operations and end-user help desk tasks.
• Develop custom reports where out-of-box options fall short.
• Deploy and schedule reports using ESS.
• Collaborate with workstream leads to document requirements.
• Create training materials for end-users.
• Support quarterly Oracle Cloud upgrades and impact assessments.
• Assist with data warehousing solutions as needed.
• Provide ongoing support for ERP, Procurement and Project/Grants Cloud reporting.

Skills

Oracle Fusion Financials

OTBI

BIP Reports

Data analysis

End-user support

Education

Bachelor's Degree in Computer Science

Tools

OTBI

BIP

Oracle ERP Cloud

Oracle Fusion Financials

Oracle Integration Cloud (OIC)

ETL/ELT tools

Job description

Work Status: US Citizen, GC

Work Arrangement: Hybrid

Worksite Address: Washington, DC

Hybrid role -- candidates local to DMV only

Duties and Responsibilities

1. 1.Design, develop, maintain, and deliver critical dashboards scheduled and ad hoc reports and queries that meet the business needs of stakeholders and support all areas of Oracle ERP, Procurement and Project/Grants Cloud
2. 2.Responsible for designing, developing, and supporting various reports and data extracts.
3. 3.Support the day-to-day operations, including help desk issues and end-user support.
4. 4.Develop custom reports using OTBI/Business Intelligence Publisher (BIP)
5. 5.Develop, unit test, performance tuning and implementation of Custom Reports
6. 6.Deploy and Schedule reports using ESS
7. 7.Collaborate with the workstream leads to create reporting specs that accurately document required functionality
8. 8.Create BIP reports where requirements cannot be met through out-of-the-box reports and Oracle Transactional Business Intelligence (OTBI)
9. 9.Create end-user training documentation, ensuring that the functionality of the report is fully understood
10. 10.Support unit testing and user acceptance test for Oracle ERP, Procurement and Project/Grants Cloud reporting
11. 11.Support quarterly upgrades to Oracle cloud by assessing its impact on reports.

Education

1. Bachelor's Degree in Computer Science or related field

Qualifications

• 5+ years of experience dealing with Oracle Fusion Financials.
• 4+ years of experience developing OTBI/BIP Reports
• 4+ years of Experience with Oracle ERP Cloud
• Deep understanding of Fusion Financials database schema
  (GL_LEDGERS, XLA subledger accounting tables, AP/AR transaction tables, Project-Grants Management tables)
• Full lifecycle implementations using government-compliant data warehousing solutions with Oracle Fusion Financials or Oracle ERP
• Experience with at least one modern ETL/ELT tool.
• Implement automated data extraction from Oracle Fusion Financials using native Oracle tools (BICC, OIC, OTBI) or third-party extraction platforms
• Worked on Automation of reconciliation between Oracle Fusion and warehouse, fund balance validation, audit trail documentation, and support for government audit cycles.
• Excellent understanding of Financial Modules and Data structure
• Built self-service reporting using enterprise BI platforms for Oracle Fusion Financials
• Experience with Oracle Integration Cloud development is a plus