Oracle Cloud Reporting Specialist

Agency

Office of the State Controller

Division

OSC Information Technology

Job Classification Title

Database Administrator II (NS)

Position Number

60087138

Grade

DT10

About Us

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.

Description of Work

This position is Optional for 100% Remote.

A $5,000 Sign on Bonus is available for selected candidate.

See eligibility for Sign-on Bonus below after the description of work.

Please Note: OSC does not use 3rd parties to conduct job interviews.

OSC is interested in every qualified candidate who is eligible to work in the United States. However, we cannot sponsor visas at this time.

Successful candidate will be subject to a criminal background check.

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.

NOTE: This job posting will close at 11:59 p.m. the night before the closing date.

Salary Range for DT10 is $87,617 - $131,426. Selected candidate's salary will be based on education, experience, and availability of funds.

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.

Responsibilities are as follows.

Design and Development

• 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

Knowledge Management

• 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

Process Improvement

• 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.

Production Support

• 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.

Eligibility for Sign-on Bonus

Qualified applicants must be selected from the candidate pool of this posting and meet the State policy following requirements:

A newly hired permanent full time or permanent part-time employee who works 30 to 40 hours per week is eligible for a sign-on bonus (this will be prorated for employees working less than 40 hours per week). The sign on bonus will be paid in three installments.

An employee is not eligible for a sign-on bonus if:

(1) the employee has held a position in North Carolina State government, including the judicial system, or the University of North Carolina system within the last 12 months (the employee shall remain ineligible for 12 months from the separation date);

(2) the employee has previously received a sign-on bonus from any State agency;

This Sign-on Bonus is contingent upon budget and final eligibility determination as of the effective date of hire.

Before receiving this sign-on bonus, the hired applicant must agree to repay the bonus on a pro-rated basis should he/she not have a performance rating of at least Meets Expectations or separates employment with OSC within 18 months of the hire date.

Knowledge Skills and Abilities/Management Preferences

• 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
• Proven, documented expertise in Oracle Workflow and Personalization

Minimum Education and Experience

Some state job postings say you can qualify by an "equivalent combination of education and experience." If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details.

NOTE: Transcripts must be uploaded to Workday and attached to your application to receive credit for any training and educational requirements, to qualify for the position.

All degrees must be received from appropriately accredited institutions.

All work history, training, and education must be listed on the official application, along with attached transcripts, to receive credit. Applications must be completed in full. "See Resume" or "See Attached" will not be accepted.

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.

EEO Statement

The State of North Carolina is an Equal Employment Opportunity Employer and dedicated to providing employees with a work environment free from all forms of unlawful employment discrimination, harassment, or retaliation. The state provides reasonable accommodation to employees and applicants with disabilities; known limitations related to pregnancy, childbirth, or related medical conditions; and for religious beliefs, observances, and practices.

Recruiter:

Pamela Denise Hamm

Recruiter Email:

PAMELA.HAMM@NCOSC.GOV