Oracle Report Developer - Consultant

In Oracle HCM, the difference between a well-built OTBI analysis and a poorly built one is not just formatting — it is whether the report respects the user's security context, whether it handles flattened hierarchy joins without returning duplicate rows, and whether it actually answers the HR question the business asked. If you build to that standard, this is your role.

ABOUT ROLLING ARRAYS

Rolling Arrays is a private equity-backed, award-winning HR Tech consulting firm — Asia Pacific's premium partner for enterprise HR digital transformation. Headquartered in Singapore and with offices across India, Malaysia, Australia, and Hong Kong, we have delivered more than 200 HR Transformation projects since our founding in 2009, and were recognised as one of Singapore's Top 100 fastest-growing companies in 2025. We specialise in SAP SuccessFactors, Oracle HCM, and Workday across the full delivery spectrum: HR process design and consulting (ALIGN), technology implementation (AUTOMATE), change management and adoption (ADOPT), and managed support services (AMS).

POSITION SUMMARY

RAC is hiring a Report Developer to build Oracle HCM reports and analytics using OTBI and BI Publisher. You will work with functional consultants and client HR stakeholders to translate business reporting requirements into delivered, validated reports that meet operational HR and management reporting needs — and that remain maintainable after go-live.

WHAT YOU WILL DO

• Select the correct OTBI subject area for each reporting requirement — knowing which HR data lives in which subject area, when subject areas can be combined safely, and when the requirement needs a BI Publisher SQL data model instead
• Build OTBI analyses across all HCM functional domains — Workforce Management, Compensation, Absence, Payroll, Talent, Performance, Recruiting, Learning, and Security — applying filters, calculated measures, dashboard prompts, conditional formatting, and drill-down links
• Build BI Publisher reports for all formatted output types — statutory documents such as payslips, IR8A, and CPF reports; transactional outputs such as offer letters and employment verification letters; and operational HR reports requiring pixel-perfect layout
• Test all reports against the intended user's security profile — not the admin account — validating that data scoping by Person Security Profile and Organisation Security Profile behaves correctly before UAT
• Build the report catalogue for client handover — report name, subject area, filter logic, security role required, refresh behaviour, and known limitations — at a standard that allows the client's HR team to maintain and extend reports without calling the SI
• Support post-go-live report training for client HR super-users

WHY ROLLING ARRAYS

Reporting is where Oracle HCM clients see the most immediate business value — and where poorly designed reports create the most post-go-live support noise. At RAC, report development is treated as a skill, not a task, and you will work alongside functional consultants and HR analytics leaders with a clear pathway to BI and Analytics Practice Lead roles.

OUR CULTURE CODE

Six values define how we operate every day at Rolling Arrays:

• Thinking Smart — spot patterns, chase smarter solutions, and illuminate the path to greater productivity
• Never Stop Learning — refine and elevate skills constantly; explore the world with a curiosity lens
• Being Nice to Everyone — treat everyone with genuine warmth and respect, regardless of seniority
• Be Super Patient with Customers — exercise patience and proactivity in every client interaction
• Help Your Teammates — share the load, lighten the stress, nurture a truly collaborative team
• Acknowledge Your Mistakes — embrace mistakes as steppingstones; grow from each one

WHAT WE'RE LOOKING FOR

• 2–3 years of Oracle HCM reporting experience with hands-on OTBI Answers and BI Publisher development on at least one live implementation
• Demonstrated subject area selection judgement — can explain why a given HR requirement belongs in a specific subject area and what the risk is of using the wrong one
• BI Publisher RTF template development — has built at least one formatted output report (offer letter, payslip summary, employment verification letter) on a live project
• Understanding of OTBI security behaviour — knows that reports must be tested against user security profiles, not admin accounts, and has done so on a delivered report
• Report catalogue documentation discipline — has produced handover documentation at a standard that allows client HR administrators to maintain reports post-go-live

PREFERRED QUALIFICATIONS

• Oracle Fusion Cloud Applications HCM Process Essentials certified — the foundational HCM credential; the expected starting certification at Consultant level; report developers who understand the HCM process model build more relevant reports
• Oracle Global Human Resources Cloud Implementation Professional — working toward this demonstrates that report development is grounded in Oracle HCM module depth rather than just tool proficiency
• Oracle Analytics Cloud certification or hands-on OAC experience — for programmes where OTBI is insufficient and advanced workforce analytics are in scope
• SQL proficiency for BI Publisher SQL-based data models and for diagnosing OTBI data lineage issues against Oracle HCM base tables

BUSINESS & CONSULTING SKILLS

• HR analytics communication — translates OTBI subject area constraints and data availability into language that HR Directors can use to scope reporting requirements realistically
• Security-aware delivery — tests every report against the intended user's security profile before UAT; admin-account testing is not testing
• Report catalogue discipline — produces handover documentation at a standard that allows the client's HR team to maintain and extend reports without calling the SI
• Structured requirements translation — converts an HR stakeholder's reporting request into the correct subject area, filter logic, and data model design
• Cross-functional collaboration — works alongside functional consultants to understand the data model before building, not after encountering missing fields
• Learning agility — adapts to new HCM modules and reporting subject areas across engagements without requiring extended ramp-up

CAREER PROGRESSION

Consultant → Senior Consultant → Lead Consultant → Solution Architect → Practice Lead