Oracle ERP-Consultant

Job Title:

Oracle ERP Report Developer

Job Code:

Reports to:

Department:

IT-Infrastructure

Revision Date:

0

BASIC PURPOSE:

We are seeking a Senior Oracle ERP Report Developer to design develop and maintain reporting solutions within Oracle Cloud ERP. This role requires deep technical expertise in Oracle reporting tools (BI Publisher OTBI BICC) along with a solid understanding of finance and HCM business functions. The ideal candidate will partner with business and IT teams to deliver accurate scalable and insightful reporting solutions and provide end-user support and training

ESSENTIAL FUNCTIONS:

• Develop reports using Oracle ERP Cloud tools including BI Publisher OTBI and BICC.
• Translate business requirements into scalable maintainable technical solutions.
• Create and manage technical documentation including design specs and data mappings.
• Analyze business needs and translate them into data-driven insights.
• Validate and ensure data accuracy completeness and integrity in reports.
• Develop ad-hoc reports and schedule data extracts for multiple business units.
• Engage with Finance HCM PPM and IT stakeholders to gather and clarify reporting needs.
• Collaborate with technical and functional teams to implement the best practices.
• Troubleshoot and resolve issues related to report performance and data discrepancies.
• Provide knowledge transfer and guidance to junior developers and power users.
• Conduct training sessions on report usage and best practices.

REPORTING RELATIONSHIPS:

Will report to Team Lead IT-BI

QUALIFICATIONS:

• Bachelor’s degree in computer science Cybersecurity Information Technology or a related field.
• 3–5 years of hands-on experience with Oracle ERP Cloud and reporting tools (BI Publisher OTBI BICC).
• Strong SQL and PL/SQL scripting skills.
• Experience with Oracle Cloud data models and subject areas.
• Ability to optimize report performance and manage large datasets.
• Familiarity with Oracle Financials (GL AR AP) HCM and PPM modules.
• Understanding of ERP business processes and data structures.
• Strong problem-solving and analytical abilities.
• Effective verbal and written communication.
• Ability to work independently and manage multiple tasks.

Collaboration:

Works cross-functionally with Finance HCM IT and Application teams to gather requirements and deliver scalable reporting solutions. Aligns reporting outputs with stakeholder needs.

Communication:

Translates reporting logic and data models into business-friendly language. Communicates technical limitations and solutions clearly to non-technical stakeholders.

Accountability:

Takes ownership of the full report development lifecycle — from requirement analysis to deployment and post-release support. Ensures data integrity and on-time delivery.

Analytical Thinking:

Breaks down complex data requirements into structured optimized report logic. Diagnoses data issues mismatches and performance bottlenecks effectively.

Receptiveness to Feedback:

Incorporates user and stakeholder feedback into report improvements. Participates in peer reviews and adheres to coding/reporting standards.

Continuous Learning:

Keeps up with Oracle Cloud ERP updates and new features in BI Publisher OTBI and BICC. Evaluates new reporting capabilities and contributes to knowledge sharing within the team.

WORK CONDITIONS:

.

Employees must possess comfort in learning training and engaging with others virtually through Microsoft Teams and TeamViewer.

.

Employee must show readiness and be available to work from office.