Senior Consultant_Oracle Fast Formula Developer

Description

A Fast Formula error does not produce a support ticket — it produces a wrong payroll run affecting hundreds of employees, an incorrect accrual balance, or a benefits eligibility failure. If you write formulas to a standard where that scenario does not happen, and you have the project scars that come from knowing exactly what produces that scenario, we want to hear from you.

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 Fast Formula Developer to write, test, and maintain Oracle HCM Fast Formulas across Payroll, Absence Management, Benefits, and Time & Labor modules. You will implement business rules that cannot be met through standard Oracle configuration, translating HR and Payroll policy into validated, precisely documented Fast Formula code.

WHAT YOU WILL DO

• Assess each business rule requirement and select the correct Fast Formula type before writing — aligning formula types to the right functional context across Payroll, Absence Management, Benefits, Compensation, Time and Labor, HCM Extracts, and Core HR validation use cases
• Write and own Oracle Payroll Fast Formulas — earnings calculations, element skip rules, mid-period proration, and retrospective processing formulas, from first draft through payroll run validation
• Write Absence Management Fast Formulas — accrual calculations, carryover rules, entitlement logic, duration calculations, and plan eligibility formulas across all absence plan types in scope
• Write Benefits Fast Formulas — plan eligibility rules, coverage amount calculations, rate formulas, post-election edits, and service calculation formulas
• Write Compensation Fast Formulas — worksheet eligibility, person selection, matrix lookup, and total compensation statement item formulas
• Write Time and Labor Fast Formulas — time entry validation rules, time calculation rules, and data transformation formulas for third-party time system integrations
• Write HCM Extracts Fast Formulas — data element transformation and row selection formulas that control extract output for outbound integrations and statutory reporting
• Debug formula compilation and runtime failures — diagnosing null database item errors, context mismatches, and conditional logic failures, and resolving them across all formula types in scope
• Document every delivered formula to handover standard — business rule, variable declarations, database items referenced, version history, and known edge cases

WHY ROLLING ARRAYS

Fast Formula development is among the most specialised and highest-value technical skills in Oracle HCM. RAC's APAC programmes include real legislative payroll complexity — Singapore CPF, Malaysia EPF, Australia Superannuation — giving you implementation experience that is genuinely rare and a pathway to Oracle HCM Payroll Practice 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

Requirements

WHAT WE'RE LOOKING FOR

• 2–3 years of Oracle HCM Fast Formula development on live implementation or AMS projects — has written and deployed formulas in production, not just training environments
• Demonstrated ability to write, compile, and debug Oracle Payroll and Absence formulas independently
• Understanding of Fast Formula type selection, database item scope, and the DEFAULT block requirement
• Systematic testing approach — tests zero-value edge cases, mid-period joins, multiple concurrent assignments, and retro scenarios before declaring a formula production-ready
• Ability to translate a business rule description into a correct formula implementation without requiring a technical intermediary

PREFERRED QUALIFICATIONS

• Oracle Payroll Cloud Implementation Professional — the primary target certification for a Fast Formula Developer; the exam specifically covers payroll element architecture, balance definitions, and formula processing which are the exact domains this role works in daily
• Oracle Absence Management Cloud Implementation Professional — absence formulas are the second most common formula type after payroll; this certification demonstrates the absence module depth the role requires
• Oracle Fusion Cloud Applications HCM Process Essentials certified — the foundational HCM credential; the expected entry-level certification at Consultant level
• Singapore CPF, Malaysia EPF, or Australia Superannuation payroll formula implementation experience — APAC legislative formula expertise is the highest-demand specialism in our market

BUSINESS & CONSULTING SKILLS

• Formula documentation precision — documents every delivered formula to a standard that the support team can maintain and the client can audit without calling the SI
• Business rule translation — converts an HR or Payroll policy description into a correct formula implementation without a technical intermediary
• Payroll impact awareness — understands that a formula error affects hundreds of employees on a live payroll run; treats testing as a responsibility, not a formality
• Structured testing mindset — tests zero-value edge cases, mid-period joins, concurrent assignments, and retro scenarios before declaring production-ready
• Cross-team collaboration — works alongside Payroll Functional Consultants and Core HR team without creating specification gaps
• Learning agility — adapts to new legislative payroll requirements across APAC markets without requiring extended ramp-up on each engagement

CAREER PROGRESSION

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