Oracle Cloud Reporting Specialist

State of North Carolina•Wake County, NC

5d•$87,617 - $131,426•Remote

About The Position

The State Controller serves as an independent resource to protect the financial integrity of the State and to promote accountability in an objective and efficient manner through its accounting, disbursing, payroll, internal controls, data management, eCommerce, and financial reporting systems that serve state agencies, employees, and the public. The foundational principles of the office are Integrity/Ethics, Objectivity, and Accountability. OSC’s overall goals are to optimize operational execution, manage risk effectively and efficiently, and foster a high-performance culture. OSC will provide excellent customer service while achieving those goals. This position is Optional for 100% Remote. A $5,000 Sign on Bonus is available for selected candidate. The mission of the Office of the State Controller (OSC) is to protect the financial integrity of the State and promote accountability in an objective and efficient manner. This position is responsible for designing, developing, implementing, and supporting various reports using Oracle Cloud Financial reporting tools. Responsibilities include hands-on work on reporting tools, managing reports that are part of outbound interface, administration of report scheduling, and working with business counterparts. This Position is responsible for end-to-end implementation of the reporting solutions and outbound data integrations for Oracle Financials. The role is hands-on managing internal and external resources, monitoring existing reports and outbound data integrations.

Requirements

Documented technical experience in Oracle financials, preferably Oracle Cloud reporting with broad understanding of at least four modules from General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Supplier Portal, Employee Expense, Fixed Asset, Inventory, Cost Management and Grants
Documented strong hands-on experience with Oracle reporting tools, specifically BI Publisher (BIP), OTBI, and FRS, including report development, customization, and scheduling
Proven, solid understanding of Oracle Financials data structures, subject areas, and reporting architecture
Documented proficiency in Oracle ERP technologies, with hands-on experience in Oracle EBS R12 or higher; Oracle Fusion/Cloud ERP experience preferred
Proven, documented expertise in Oracle reporting tools including OTBI, BI Publisher, Smart View, and FRS, with deep knowledge of Oracle Financials architecture, report catalog security, and ESS job scheduling
Proven, documented advanced technical and automation skills, including SQL development, Visual Basic macros, and batch scripting for process optimization
Documented experience with version control, GIT/Subversion
Bachelor's degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system; or High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.

Nice To Haves

Documented technical experience in Oracle financials, preferably Oracle Cloud reporting with broad understanding of at least four modules from General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Supplier Portal, Employee Expense, Fixed Asset, Inventory, Cost Management and Grants
Documented strong hands-on experience with Oracle reporting tools, specifically BI Publisher (BIP), OTBI, and FRS, including report development, customization, and scheduling
Proven, solid understanding of Oracle Financials data structures, subject areas, and reporting architecture
Documented proficiency in Oracle ERP technologies, with hands-on experience in Oracle EBS R12 or higher; Oracle Fusion/Cloud ERP experience preferred
Proven, documented expertise in Oracle reporting tools including OTBI, BI Publisher, Smart View, and FRS, with deep knowledge of Oracle Financials architecture, report catalog security, and ESS job scheduling
Proven, documented advanced technical and automation skills, including SQL development, Visual Basic macros, and batch scripting for process optimization
Documented experience with version control, GIT/Subversion

Responsibilities

Assist with defining scope and estimates for new development work.
Support quarterly and Monthly upgrades/ patches to Oracle cloud by assessing its impact on reports.
Gather reporting requirements from stakeholders and lead the design of efficient, scalable reporting solutions. Providing technical direction and expertise related to reporting strategies.
Create and maintain design documents relating to reporting initiatives which may involve developing detailed data mapping and data transformation rules
Develop and support Oracle Cloud Financials reports using Oracle provided reporting tools.
Responsible for designing, developing, and supporting various reports and data extracts.
Analyze requirements and architect appropriate solutions, with detailed design documents
Ensures ad-hoc reporting requests are captured, prioritized and where possible create standardized dynamic reports to meet ad hoc reporting needs
Responsible for sharing knowledge about reports and outbound integrations with other team members and IT Customer Support team throughout the life cycle of project.
Collaborate with Finance and Accounting teams to define and document reporting requirements.
Maintain expert-level skills in Oracle ERP reporting tools, specifically BI Publisher (BIP), OTBI, and FRS.
Develop and maintain an up-to-date knowledge of Oracle quarterly product updates and its impact on reports and outbound integrations
Participate in cross-functional discussions to analyze requirements and recommend effective solutions.
Evaluate and optimize existing reports, ensuring performance, scalability, security, error logging, and auditing, and propose modifications to meet business needs.
Develop and implement automation strategies for reporting and simplify report delivery and usage wherever possible.
Plan and document projects to test architectural proposals, explore industry trends and new technologies, and provide guidance to senior management.
Support outbound data integrations and reporting processes within Oracle Cloud Financials
Assist in incident resolution and service requests related to Oracle Financials.
Monitor and maintain existing reporting processes to ensure accuracy and efficiency.