[Hiring] Oracle Fusion ERP Consultant @Rootshell Enterprise Technologies, Inc.

Role Description

We are seeking an experienced Technical Data Architect & Reporting Analyst Contractor to support a large-scale Oracle Fusion ERP and Oracle EPM implementation. This role will lead the design and implementation of enterprise reporting architecture supporting Oracle ERP, EPM, and internal reporting platforms.

• Architect data pipelines
• Develop enterprise semantic models
• Design reporting databases
• Deliver scalable reporting solutions supporting Accounting, Finance, FP&A, and Executive Leadership

Key Responsibilities

• Oracle ERP & EPM Data Architecture
  • Design and maintain enterprise reporting and analytics architecture spanning Oracle Fusion ERP, Oracle EPM, and SQL Server
  • Develop a comprehensive understanding of Oracle Fusion Financials data structures and relationships across:
    • General Ledger (GL)
    • Accounts Payable (AP)
    • Accounts Receivable (AR)
    • Cash Management (CM)
    • Fixed Assets (FA)
    • Project Accounting (PPM)
    • Budgeting & Planning
    • Financial Consolidation and Close (FCCS)
  • Define enterprise data models supporting operational, financial, statutory, management, and executive reporting
  • Establish data governance standards, reconciliation processes, and reporting controls
• Data Extraction & Integration
  • Design and implement data extraction solutions from Oracle Fusion ERP and Oracle EPM
  • Develop and support integrations utilizing:
    • BICC (Business Intelligence Cloud Connector)
    • OTBI
    • BI Publisher
    • REST APIs
    • SOAP APIs
    • FBDI extracts
    • Smart View data integrations
  • Build automated data pipelines moving ERP and EPM data into SQL Server reporting environments
  • Design incremental load strategies and near-real-time reporting architectures where appropriate
  • Ensure completeness and accuracy of data transferred between Oracle applications and downstream reporting solutions
• SQL Server Data Warehouse Development
  • Architect and maintain enterprise reporting databases within Microsoft SQL Server
  • Design star schemas, fact tables, and dimensional models optimized for analytics
  • Develop complex T-SQL procedures, functions, views, and ETL processes
  • Implement data quality validation, reconciliation, and audit controls
  • Optimize database performance and scalability for large financial datasets
• SSAS Tabular Model Development
  • Design, develop, and optimize SQL Server Analysis Services (SSAS) Tabular Models
  • Create enterprise semantic models supporting self-service and executive reporting
  • Develop advanced DAX calculations, KPIs, measures, hierarchies, and business logic
  • Implement row-level security and financial data access controls
  • Optimize model performance and query response times
• Reporting & Analytics
  • Partner with Accounting, FP&A, Treasury, Project Accounting, and Executive Leadership teams to define reporting requirements
  • Develop reporting datasets and semantic layers supporting:
    • Financial Statements
    • Board Reporting
    • Budget vs. Actual Analysis
    • Cash Forecasting
    • Project Financial Analysis
    • AR/AP Operational Metrics
    • Consolidation Reporting
    • Executive Dashboards
  • Support reporting tools including Power BI and other enterprise analytics platforms
• Data Reconciliation & Controls
  • Create reconciliation frameworks between:
    • Oracle ERP subledgers and GL
    • Oracle EPM and ERP actuals
    • SQL Server Reporting Database and source systems
  • Support audit and SOX compliance requirements
  • Develop controls for validating accuracy and completeness of financial data

Qualifications

• 10+ years of data architecture, business intelligence, and enterprise reporting experience
• 7+ years working with Oracle ERP financial systems
• 5+ years specifically supporting Oracle Fusion Cloud ERP
• 5+ years working with Oracle EPM, including:
  • Planning
  • FCCS
  • Financial Reporting
  • Smart View
• 8+ years of Microsoft SQL Server experience
• 5+ years designing and implementing SSAS Tabular Models

Technical Skills

• Required expertise in:
  • Oracle Fusion ERP
  • Oracle EPM (Planning and FCCS)
  • BICC
  • OTBI
  • BI Publisher
  • REST APIs
  • SOAP APIs
  • SQL Server
  • T-SQL
  • SSIS
  • SSAS Tabular Models
  • DAX
  • Power BI
  • Data Warehousing
  • Dimensional Modeling
  • Data Governance
  • Master Data Management

Preferred Qualifications

• Experience supporting large Oracle ERP transformation programs
• Experience migrating reporting solutions from SAP, legacy ERP systems, or custom reporting environments into Oracle Cloud
• Experience designing enterprise reporting databases supporting Finance and Executive Reporting
• Familiarity with Azure Data Services and cloud analytics platforms
• Oracle Cloud certifications
• Microsoft Power BI certification
• Microsoft SQL Server certification