DescriptionThe Oracle Report Writer is responsible for the design, development, and maintenance of enterprise reporting solutions supporting the organization’s Human Resources systems and Oracle Enterprise Performance Management (EPM) platform. This position provides technical expertise in data extraction, report development, analytics, and reporting governance to ensure leadership, HR, Finance, and operational teams have accurate, timely, and actionable information for workforce planning, financial management, compliance, and strategic decision-making. The Oracle Report Writer serves as a key resource for enterprise reporting initiatives and collaborates closely with business stakeholders, application teams, and IT leadership to improve reporting capabilities and data quality across the organization.
-
Enterprise Reporting Development
- Design, develop, test, and maintain reports using Oracle reporting tools (e.g., BI Publisher, OTBI, Smart View, or equivalent).
- Build and maintain SQL queries, datasets, and structured data extracts.
- Develop automated and scheduled reporting processes.
- Create standardized templates and reusable reporting components.
- Ensure reporting solutions meet organizational performance, security, and governance standards.
-
Human Resources Reporting Support
- Develop and maintain reports supporting:
- Workforce planning and headcount monitoring
- Position control and vacancy tracking
- Compensation and benefits analytics
- Compliance and regulatory reporting
- Support HR leadership with dashboards and executive-level reporting outputs.
- Assist with internal and external HR audit requests.
-
Oracle EPM & Financial Planning Reporting
- Develop reporting solutions supporting:
- Budget preparation and monitoring
- Forecasting and variance analysis
- Departmental financial performance tracking
- Strategic planning and resource allocation
- Collaborate with Finance teams to ensure reporting aligns with chart of accounts structures and planning cycles.
- Assist with validation and reconciliation of data between Oracle systems.
-
Data Integrity & Integration Support
- Validate data accuracy across HR, Financial, and EPM platforms.
- Troubleshoot discrepancies and resolve reporting issues.
- Support integration and data feed validation for reporting environments.
- Maintain documentation of data sources, report logic, and definitions.
-
Stakeholder Collaboration & Governance
- Work with HR, Finance, IT, and operational leaders to gather reporting requirements.
- Translate business needs into technical reporting solutions.
- Maintain a catalog of enterprise reports and associated documentation.
- Support organizational data governance, security, and audit requirements.
- Participate in enterprise reporting strategy initiatives and continuous improvement efforts.
-
Knowledge, Skills, and Abilities
- Knowledge of relational databases, data modeling, and reporting structures.
- Ability to manage multiple reporting priorities and deadlines.
- Strong attention to detail and commitment to data accuracy.
- Ability to communicate technical information clearly to non-technical stakeholders.
- Ability to work independently while collaborating effectively across departments.
- Understanding of enterprise security and data privacy practices.
Qualifications
-
Education:
- Bachelor’s degree in Information Systems, Computer Science, Business, Finance, Human Resources, or related field.
-
Experience:
- Minimum five (5) years of experience developing reports in Oracle environments.
- Strong experience with:
- Oracle SQL / PL-SQL
- Oracle reporting tools (BI Publisher, OTBI, or equivalent)
- HR or Financial system reporting
- Demonstrated ability to translate business requirements into technical reporting solutions.
- Strong analytical, organizational, and communication skills.
-
Preferred Qualifications
- Experience with Oracle EPM / Hyperion reporting environments.
- Experience in healthcare, public sector, or large enterprise organizations.
- Familiarity with workforce analytics, financial planning, and budgeting processes.
- Experience with enterprise dashboard tools (Power BI, Tableau, or equivalent).
- Knowledge of data governance frameworks and reporting standards.
-
Certification:
-
Licensure:
-
Registrations:
-
Training: