Oracle ERP-Consultant

Job Title:

Oracle ERP Report Developer

Job Code:

Reports to:

Department:

IT-Infrastructure

Revision Date:

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