Oracle ERP Financial Reporting Specialist

WellSpan Health; York (York County); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health benefits

Retirement plan

PTO

Education assistance

DailyPay

Parental leave

Job summary

WellSpan Health is seeking an experienced Oracle Fusion reporting specialist to lead full lifecycle reporting from gathering requirements to end-user training across the ERP environment.

You will design and maintain Oracle Fusion Cloud reports and dashboards, develop SQL queries, and collaborate with business users to deliver timely analytical solutions. The role emphasizes data integrity, documentation, and adherence to development standards.

Qualifications

• Bachelor's degree required in IS/CS/Accounting/Finance.
• Master's degree (MBA/Data Science) preferred.
• 1 year of experience reporting within Oracle Fusion Cloud; using Oracle BIP/OTBI/FRS preferred.
• One or more certifications in Oracle ERP reporting products (preferred).

Responsibilities

• Design, develop, test, and maintain Oracle Fusion Cloud reports and dashboards using BIP, OTBI, FDI, and FRS.
• Create, modify, and support SQL queries and data extracts.
• Work with business users to gather requirements and deliver timely solutions.
• Troubleshoot report errors, data discrepancies, and performance issues.
• Maintain documentation for report designs, data sources, and standards.

Skills

SQL proficiency

Oracle Fusion knowledge

FDI exposure

Analytical skills

Communication skills

Documentation skills

Education

Bachelor's degree in Information Systems/CS/Accounting/Finance

MBA/Data Science preferred

Tools

Oracle BIP

OTBI

FRS

Job description

Job Description

Provides technical and functional skills to WellSpan Health's system needs for ERP reports. The primarily responsibility of this role is full life cycle reporting, from requirements gathering, development, maintenance through end-user training on the tools to deliver the content. Serves as a subject matter expert on a team of developers championing a standard reporting delivery model encompassing development, documentation, and training across WellSpan's Health ERP system.

Responsibilities

• Design, develop, test, and maintain Oracle Fusion Cloud reports and dashboards, including data models, reports, and templates, using BIP, OTBI, FDI, and FRS, based on business requirements
• Create, modify, and support SQL queries and data extracts to meet reporting and analytical needs
• Utilize Oracle Fusion subject areas and data structures to build accurate, efficient reports that combine data across multiple modules
• Support reporting requirements across Oracle Fusion ERP applications, primarily across HCM and Finance, with an initial focus in areas such as Core HR, Recruiting, Talent, General Ledger, Accounts Payable, and Projects
• Work directly with business users to gather requirements, clarify reporting needs, and deliver timely solutions
• Troubleshoot report errors, data discrepancies, performance issues, and security-related reporting concerns
• Assist with administration and maintenance of reporting catalogs, scheduling, bursting, and report security
• Support Oracle quarterly update testing to ensure reports and analytics continue to function as expected
• Maintain documentation for report designs, data sources, business requirements, and development standards
• Participate in report validation, user acceptance testing, and deployment activities
• Evaluate report enhancement requests and help identify the most effective reporting solution
• Assist in educating users on available Oracle Fusion reporting tools and capabilities
• Follow established development standards, change management procedures, and documentation requirements

Common Expectations

• Maintain a strong working knowledge of Oracle Fusion ERP applications and reporting tools, staying current on new features and releases
• Communicate effectively with both technical and non-technical stakeholders
• Manage multiple report requests and priorities in a fast-paced, deadline-driven environment
• Exercise sound judgment in balancing report accuracy, performance, and turnaround time
• Maintain confidentiality and data security standards when working with financial and operational data
• Collaborate professionally and constructively within a remote/distributed team environment
• Provides outstanding service to all customers; fosters teamwork; and practices fiscal responsibility through improvement and innovation

Travel Requirements

• Estimated Amount: - Occasional travel.

Qualifications

Minimum Education

• Bachelor's degree in Information Systems, Computer Science, Accounting, Finance, or related field. Required
• Master's Degree In Business Administration, Data Science, or related field. Preferred

Work Experience

• 1 year Experience reporting within Oracle Fusion Cloud, utilizing Oracle BIP, OTBI, and/or FRS. Required

Courses And Training

• One or more certifications in Oracle ERP reporting products. Upon Hire Preferred

Knowledge, Skills, And Abilities

• Proficiency in SQL, including writing and troubleshooting complex queries against relational databases
• Working knowledge of Oracle Fusion subject areas and data structures (Core HR, Recruiting, Talent, GL, AP, and/or Projects preferred)
• Exposure to Oracle Fusion Data Intelligence (FDI) preferred
• Strong analytical and problem-solving skills, with the ability to translate business requirements into technical solutions
• Excellent written and verbal communication skills
• Strong documentation and organizational skills

Benefits Offered

• Comprehensive health benefits
• Retirement savings plan
• Paid time off (PTO)
• Education assistance
• Financial education and support, including DailyPay
• Expanded Paid Parental Leave

For additional details: Benefits & Incentives | WellSpan Careers (joinwellspan.org)