Oracle ERP Financial Reporting Specialist
WellSpan Health · York, PA · 2 wk ago
AccountingFull-time
About the Role
Provides technical and functional skills to support WellSpan Health's ERP reporting needs. This role focuses on the full life-cycle of reporting, from requirements gathering and development to maintenance and end-user training. Serves as a subject matter expert on a team of developers, championing a standard reporting delivery model that includes development, documentation, and training across WellSpan's Oracle Fusion Cloud 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 in HCM and Finance, with an initial focus on 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.
- 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.
- Provide outstanding service to all customers; foster teamwork; and practice fiscal responsibility through improvement and innovation.
Requirements
- 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.
- 1 year of experience reporting within Oracle Fusion Cloud, utilizing Oracle BIP, OTBI, and/or FRS. Required.
- One or more certifications in Oracle ERP reporting products. Preferred upon hire.
Skills
- 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.
Travel
Occasional travel required.
Benefits
- Comprehensive health benefits.
- Retirement savings plan.
- Paid time off (PTO).
- Education assistance.
- Financial education and support, including DailyPay.
- Expanded Paid Parental Leave.