Oracle Fusion ERP Data Architect & Analytics Leader

Commergence; San Francisco (CA); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Commergence is seeking a Technical Data Architect to lead Oracle Fusion ERP/EPM reporting architecture in the Bay Area. The contractor will design data models, integrate ERP data with SQL Server reporting, and deliver scalable analytics for Finance and Leadership.

The role requires deep Oracle Fusion and EPM expertise, SSAS Tabular modeling, and strong data governance. Occasional travel and remote PST-hours are supported in a long-term contract.

Qualifications

• 10 years of data architecture, BI, and enterprise reporting experience.
• 7 years with Oracle ERP financials and 5 years with Oracle Fusion Cloud ERP.
• 5 years designing SSAS Tabular Models and MS SQL Server data warehouses.
• Strong knowledge of Oracle Fusion data structures and security models.

Responsibilities

• Design and maintain enterprise reporting and analytics architecture across Oracle Fusion ERP, Oracle EPM, and SQL Server.
• Develop data models, ETL/ELT pipelines, and semantic layers for finance and executive reporting.
• Implement data governance, reconciliation processes, and reporting controls.
• Lead SSAS Tabular model development, DAX calculations, and Power BI reporting.
• Collaborate with Accounting, FP&A, Treasury, and leadership on reporting requirements.

Skills

Oracle Fusion ERP

Oracle EPM

BICC

OTBI

BI Publisher

SQL Server

SSAS Tabular Models

DAX

Power BI

Financial Data Warehouse Architecture

Data Integration

Financial Reporting

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, or related field

Tools

SSIS

SSAS Tabular

BI Publisher

Job description

Commergence is seeking a Technical Data Architect to lead Oracle Fusion ERP/EPM reporting architecture in the Bay Area. The contractor will design data models, integrate ERP data with SQL Server reporting, and deliver scalable analytics for Finance and Leadership.

The role requires deep Oracle Fusion and EPM expertise, SSAS Tabular modeling, and strong data governance. Occasional travel and remote PST-hours are supported in a long-term contract.