Location: Washington DC
Position Type: Hybrid
Hybrid Schedule: 3 days onsite
Contract Length: Long-term with annual extensions
Position Overview:This role is responsible for designing developing and supporting enterprise reporting and analytics solutions across Oracle ERP Procurement and Project/Grants Cloud to meet complex business and financial reporting needs. The position partners closely with functional leads and stakeholders to deliver accurate scalable and compliant dashboards reports and data extracts while supporting ongoing operations and system upgrades.
Duties:Design develop maintain and deliver scheduled and ad hoc dashboards reports and queries supporting Oracle ERP Procurement and Project/Grants Cloud.
Design develop and support custom reports and data extracts to meet business and regulatory requirements.
Provide day-to-day operational support including help desk issue resolution and end-user assistance.
Develop custom reports using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP).
Perform unit testing performance tuning and implementation of custom reporting solutions.
Deploy and schedule reports using Enterprise Scheduler Service (ESS).
Collaborate with workstream leads to define and document detailed reporting specifications.
Create BIP reports where out-of-the-box and OTBI reporting capabilities do not meet requirements.
Develop end-user training and documentation to ensure clear understanding of report functionality.
Support unit testing and user acceptance testing for Oracle Cloud reporting solutions.
Assess and remediate reporting impacts associated with quarterly Oracle Cloud upgrades.
Support automated data extraction reconciliation audit trail documentation and validation activities related to financial reporting and compliance.
Required Skills:5 years of experience working with Oracle Fusion Financials.
4 years of experience developing reports using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP).
4 years of experience with Oracle ERP Cloud implementations and support.
Demonstrated deep understanding of Fusion Financials database schema including GLLEDGERS XLA subledger accounting tables AP/AR transaction tables and Project/Grants tables.
Proven experience delivering full lifecycle implementations using government-compliant data warehousing solutions integrated with Oracle Fusion Financials or Oracle ERP.
Hands-on experience with at least one modern ETL/ELT tool.
Experience implementing automated data extraction from Oracle Fusion Financials using native Oracle tools (such as BICC OIC and OTBI) or third-party extraction platforms.
Experience automating reconciliation between Oracle Fusion and data warehouses including fund balance validation audit trail documentation and support for government audit cycles.
Strong understanding of Oracle Financial modules and underlying data structures.
Experience building self-service reporting solutions using enterprise BI platforms for Oracle Fusion Financials.
Bachelors degree in Computer Science or a related field.
Required Experience:
Senior IC
Location: Washington DCPosition Type: HybridHybrid Schedule: 3 days onsiteContract Length: Long-term with annual extensionsPosition Overview:This role is responsible for designing developing and supporting enterprise reporting and analytics solutions across Oracle ERP Procurement and Project/Grants ...
Location: Washington DC
Position Type: Hybrid
Hybrid Schedule: 3 days onsite
Contract Length: Long-term with annual extensions
Position Overview:This role is responsible for designing developing and supporting enterprise reporting and analytics solutions across Oracle ERP Procurement and Project/Grants Cloud to meet complex business and financial reporting needs. The position partners closely with functional leads and stakeholders to deliver accurate scalable and compliant dashboards reports and data extracts while supporting ongoing operations and system upgrades.
Duties:Design develop maintain and deliver scheduled and ad hoc dashboards reports and queries supporting Oracle ERP Procurement and Project/Grants Cloud.
Design develop and support custom reports and data extracts to meet business and regulatory requirements.
Provide day-to-day operational support including help desk issue resolution and end-user assistance.
Develop custom reports using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP).
Perform unit testing performance tuning and implementation of custom reporting solutions.
Deploy and schedule reports using Enterprise Scheduler Service (ESS).
Collaborate with workstream leads to define and document detailed reporting specifications.
Create BIP reports where out-of-the-box and OTBI reporting capabilities do not meet requirements.
Develop end-user training and documentation to ensure clear understanding of report functionality.
Support unit testing and user acceptance testing for Oracle Cloud reporting solutions.
Assess and remediate reporting impacts associated with quarterly Oracle Cloud upgrades.
Support automated data extraction reconciliation audit trail documentation and validation activities related to financial reporting and compliance.
Required Skills:5 years of experience working with Oracle Fusion Financials.
4 years of experience developing reports using Oracle Transactional Business Intelligence (OTBI) and Business Intelligence Publisher (BIP).
4 years of experience with Oracle ERP Cloud implementations and support.
Demonstrated deep understanding of Fusion Financials database schema including GLLEDGERS XLA subledger accounting tables AP/AR transaction tables and Project/Grants tables.
Proven experience delivering full lifecycle implementations using government-compliant data warehousing solutions integrated with Oracle Fusion Financials or Oracle ERP.
Hands-on experience with at least one modern ETL/ELT tool.
Experience implementing automated data extraction from Oracle Fusion Financials using native Oracle tools (such as BICC OIC and OTBI) or third-party extraction platforms.
Experience automating reconciliation between Oracle Fusion and data warehouses including fund balance validation audit trail documentation and support for government audit cycles.
Strong understanding of Oracle Financial modules and underlying data structures.
Experience building self-service reporting solutions using enterprise BI platforms for Oracle Fusion Financials.
Bachelors degree in Computer Science or a related field.
Required Experience:
Senior IC
View more
View less