Description

You will architect enterprise reporting and analytics solutions for Oracle Fusion ERP and EPM, delivering scalable data pipelines and semantic models for Finance, FP&A, and Executive Leadership.

This role is remote.

Responsibilities

• Design and maintain enterprise reporting architectures spanning Oracle Fusion ERP, Oracle EPM, and SQL Server, ensuring data governance and reconciliation standards.
• Build automated data extraction and integration pipelines using BICC, OTBI, BI Publisher, REST/SOAP APIs, and FBDI to move data into SQL Server environments.
• Architect and optimize SQL Server data warehouses, implementing star schemas, complex T-SQL ETL processes, and performance tuning for large financial datasets.
• Develop and optimize SSAS Tabular Models with advanced DAX calculations, KPIs, and row-level security to support self-service and executive reporting.
• Partner with Accounting and FP&A teams to define reporting requirements, create Power BI datasets, and establish controls for SOX compliance and audit readiness.

Required Skills

• 10+ years of data architecture, business intelligence, and enterprise reporting experience.
• 5+ years of specific experience supporting Oracle Fusion Cloud ERP.
• 5+ years of experience with Oracle EPM, including Planning, FCCS, Financial Reporting, and Smart View.
• 8+ years of Microsoft SQL Server experience.
• 5+ years designing and implementing SSAS Tabular Models.
• Deep understanding of Oracle Fusion Financials data structures (GL, AP, AR, CM, FA, PPM, Budgeting).
• Expertise in data integration tools: BICC, OTBI, BI Publisher, and Smart View.
• Proficiency in DAX, Power BI, and T-SQL.

Preferred Skills

• Experience with SOAP/REST APIs and FBDI extracts for Oracle Cloud integrations.
• Strong knowledge of SOX compliance frameworks and financial data reconciliation controls.

Key Skills

Education

Any Graduate