Senior Oracle Fusion Developer - Record to Report

Envestnet Inc

CA(remote)

JOB DETAILS
SALARY
$94,600–$118,300 Per Year
SKILLS
API Documentation, Accounting, Accounting Close, Accounting Consolidation, Accounts Payable, Accounts Receivable, Analysis Skills, Application Programming Interface (API), Automation, Bank Management, Billing, Business Intelligence, Business Process Management, Cloud Computing, Computer Programming, Continuous Improvement, Data Import/Export, Data Management, Data Modeling, Data Quality, Embedded Programming Languages, Finance, Financial Analysis, Financial Operations, Financial Planning, Financial Reporting, Financial Systems, General Ledger Accounting, Groovy Programming Language, Identify Issues, Literacy, Oracle, Oracle Applications, Oracle Database, Oracle Enterprise Performance Management (EPM), Oracle Financials, Oracle Fusion Middleware, Oracle General Ledger, Oracle PL-SQL, Problem Solving Skills, Process Improvement, REST (Representational State Transfer), RTF, Reconciliation, Reporting Dashboards, Reporting Skills, Rich Internet Application (RIA), SOAP (Simple Object Access Protocol), SQL (Structured Query Language), Scripting (Scripting Languages), Service Level Agreement (SLA), Systems Administration/Management, Testing, Transaction Processing/Management, Validation Testing, Wealth Management, Web Services, Wheel/Front-End Loader, XML (EXtensible Markup Language)
LOCATION
CA
POSTED
27 days ago

Senior Oracle Fusion Developer - Record to Report

Location: ALL USA, United States

Date Posted: Jun 26, 2026

Share:

Apply Now

Save Job Saved

Description

The application window will close July 31, 2026.

Job Location

The primary work location for this role is the East Coast with a remote work model.

About Envestnet

Envestnet is an adaptive WealthTech company that is redefining the future of wealth management by helping advisors meet the moment with its comprehensive technology, actionable insights, and industry leading support. Backed by over 25 years of experience and approximately $7.0 trillion in platform assets, Envestnet is trusted by over one third of financial advisors across leading banks, wealth managers, brokerages, and RIAs.

For a deeper look at how Envestnet is shaping the future of financial advice, visit www.envestnet.com.

The Team You'll Join

The Financial Systems team at Envestnet plays a critical role in powering the technology behind the company's finance operations, building and enhancing the systems that support reporting, reconciliation, and the close process. Partnering closely with Finance stakeholders, the team develops integrations, dashboards, and automation within Oracle Fusion to ensure accurate, scalable, and efficient financial data flow across the organization. By combining deep technical expertise with business insight, they drive continuous improvement in how financial processes are executed-making it an exciting space for those who enjoy solving complex problems at the intersection of finance and technology.

How You'll Contribute

This is a hands-on Oracle Fusion developer role embedded in the Financial Systems team. You write code, build integrations, and configure Oracle R2R modules at a technical level - not as a systems administrator, but as a developer who understands how the platform works under the hood. You support the Director, R2R in delivering the GL, close, reconciliation, consolidation, and financial reporting capabilities that Finance stakeholders depend on.

You are expected to be independently productive: given a requirement, you can identify the right Oracle module and approach, write the SQL or script needed, build or modify the integration, and validate the output - without step-by-step guidance.

  • Oracle EPM / FCCS - Collaboration

  • Partner with the Oracle Fusion Developer - EPM (FCCS) on GL-to-FCCS data flows: validate GL extracts, support source-system mappings from the Fusion side, and reconcile consolidation outputs back to GL balances

  • Build SQL-based validation checks comparing FCCS data loads against GL_BALANCES source data

  • Oracle Fusion GL & Close

  • Query Oracle GL tables (GL_JE_HEADERS, GL_JE_LINES, GL_BALANCES, GL_CODE_COMBINATIONS, etc.) for data validation, reconciliation, and ad hoc analysis

  • Build journal import integrations using Oracle Fusion GL REST APIs and FBDI templates

  • Develop and maintain BIP reports and OTBI analyses for GL, close, and consolidation reporting

  • Support Close Manager configuration: task library updates, schedule adjustments, and status reporting queries

Write SQL-based data quality checks for period-end GL balances and intercompany out-of-balance detection

  • Oracle ARCS & Reconciliation
  • Support ARCS configuration: reconciliation profile templates, data source connections, and period-end workflows
  • Build data feeds into ARCS using REST APIs or FBDI for automated balance population
  • Write SQL queries to validate ARCS balances against Oracle GL source data
  • Subledger Accounting (SLA) & Intercompany
  • Support Subledger Accounting rule configuration - understand how journal line rules and account derivation rules generate GL entries

Query SLA tables (XLA_AE_HEADERS, XLA_AE_LINES, XLA_EVENTS) to trace subledger-to-GL accounting

  • Support Oracle Fusion Intercompany configuration and troubleshoot intercompany transaction processing errors

Technical Skills Required:

  • Shared Technical Foundation

  • Oracle SQL / PL/SQL: Query Oracle Fusion tables directly (GL, AP, AR, etc.); write SQL for data validation, reconciliation, and reporting; troubleshoot data issues at the table level

  • Oracle REST APIs: Consume and test Oracle Fusion REST services for journal import, supplier/customer management, invoice processing, and period-close operations; read API documentation and design integration payloads

  • Oracle SOAP Web Services: Work with older Oracle Fusion SOAP endpoints where REST is unavailable; construct and validate XML payloads

  • Groovy Scripting: Write and maintain Groovy scripts within Oracle EPM/FCCS for consolidation and calculation rules; extend to BPM workflow customizations and Oracle application scripting where applicable

  • Oracle BIP / OTBI: Build BI Publisher report templates (RTF, Excel); write OTBI analyses and dashboards; create data models over Oracle Fusion subject areas

  • Oracle FBDI: Build and validate File-Based Data Import templates for bulk data loads; troubleshoot import errors using log files and Oracle table queries

  • Oracle Integration Architecture: Understand Oracle Fusion module table structures and data flow well enough to design integrations, validate payloads, and diagnose errors without hand-holding

  • R2R-Specific Technical Skills

  • FCCS Literacy: Able to query EPM data and reconcile GL-to-FCCS flows; Groovy scripting a plus - the EPM (FCCS) Developer owns FCCS scripting and FDMEE workflows

  • GL Table Structures: Solid working knowledge of Oracle GL schema:

  • GL_LEDGERS, GL_CODE_COMBINATIONS, GL_BALANCES, GLJE, XLA_ subledger tables

  • Financial Reporting: Oracle FRS report design or Smart View query development

What You'll Need to Bring

  • 5+ years of hands-on Oracle Fusion technical development experience
  • Oracle SQL proficiency: comfortable querying multi-table GL and SLA schemas to diagnose data issues
  • Experience with Oracle REST APIs or SOAP web services in an Oracle Fusion context
  • Experience building BIP reports or OTBI analyses over Oracle Fusion financial data
  • Ability to read API documentation, construct payloads, and independently troubleshoot integration errors

Nice-to-Haves

  • Groovy scripting in an Oracle FCCS or EPM Cloud context; FDMEE or Oracle Data Management configuration experience
  • Oracle EPM Cloud Automate job design
  • Oracle ARCS configuration or data integration experience
  • SLA rule configuration experience
  • Experience with Workato or another iPaaS platform

Why You'll Enjoy Working at Envestnet

Help shape the future of WealthTech. At Envestnet you'll gain hands-on experience and collaborate with some of the industry's brightest minds to deliver meaningful, innovative solutions that make a real difference.

We value flexibility in how and where work gets done, and we recognize strong performance with meaningful rewards-because your contributions should drive both business success and your own personal growth. If you're looking for a place where your work has impact, your development is supported, and your contributions are truly valued, Envestnet is where you can build your future.

The opportunity is now!

Sponsorship

This position is not open to candidates requiring visa sponsorship

Our Investment in You

This role offers a base salary range of $94,600 to $118,300. The range listed represents a good-faith estimate of base salary compensation for this position and does not include incentive compensation, equity or benefits. Individual pay will be determined based on factors including, but not limited to, relevant experience, skills, education, certifications, and geographic location, in accordance with applicable pay transparency laws.  This role is eligible for an additional incentive component as part of the total rewards package.

We provide a comprehensive suite of benefits - subject to Envestnet's plan eligibility rules - that support your overall well-being including, medical insurance, paid time off (PTO), 401k company match, paid parental leave, education reimbursement, disability coverage and mental health & wellness support. Our investment in you means supporting you professionally, financially, and personally at every stage of your journey with us. Please visit our benefits page on our career site to learn more.

Our Commitment to Inclusion & Belonging

Envestnet is an Equal Opportunity Employer and is committed to creating an inclusive environment for all employees and applicants. We welcome and value individuals of all backgrounds and do not discriminate based on race, color, religion, creed, sex (including pregnancy or related medical conditions), gender identity or expression, sexual orientation, national origin, ancestry, age, disability, genetic information, military or veteran status, citizenship status, or any other status protected by applicable law. We encourage individuals from all backgrounds to apply.

We strive to provide an inclusive application and interview process. If you are a candidate with a disability and require reasonable accommodation, please contact us at  [email protected]. Please include your full name, the title of the role you are applying for, and the accommodation necessary to assist you with the recruiting process.

Recruitment Fraud

At Envestnet, safeguarding the trust and safety of job seekers is a top priority. We are aware that scammers may impersonate Envestnet recruiters or create fake job opportunities to deceive candidates. Review the information on our recruitment fraud awareness page to help you recognize and avoid recruitment fraud.

#LI-REMOTE #LI-AA1

Share:

Apply Now

About the Company

E

Envestnet Inc