Senior Oracle ERP & EPM Data Architect

Fanisko; San Francisco (CA); On-site; USD 103,000 - 193,000; Full time

Job summary

Fanisko seeks an experienced Technical Data Architect & Reporting Analyst Contractor to lead enterprise reporting architecture for Oracle Fusion ERP, Oracle EPM, and SQL Server environments. You will design data models, pipelines, and semantic layers to support Accounting, Finance, FP&A, and executive leadership.

Responsibilities include building SSAS Tabular models, DAX calculations, data governance, and near-real-time reporting strategies while ensuring data accuracy and SOX-compliant controls.

Qualifications

• 10+ years of data architecture, BI, 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, Smart View.
• 8+ years of Microsoft SQL Server experience.
• 5+ years designing and implementing SSAS Tabular Models.

Responsibilities

• 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 GL, AP, AR, CM, FA, PPM, Budgeting & Planning, FCCS.
• Define enterprise data models supporting operational, financial, statutory, management, and executive reporting.
• Establish data governance standards, reconciliation processes, and reporting controls.
• Design and implement data extraction solutions from Oracle Fusion ERP and Oracle EPM.
• Develop and support integrations utilizing BICC, 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.
• 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.
• Design, develop, and optimize 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.
• Partner with Accounting, FP&A, Treasury, Project Accounting, and Executive Leadership teams to define reporting requirements.
• Develop reporting datasets and semantic layers supporting Board Reporting, Budget vs. Actual Analysis, Cash Forecasting, AR/AP Operational Metrics, Consolidation Reporting.
• Support audit and SOX compliance requirements.
• Develop controls for validating accuracy and completeness of financial data.

Education

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

Tools

Oracle Fusion ERP

Oracle EPM

BICC

OTBI

BI Publisher

REST APIs

SOAP APIs

SQL Server

SSAS Tabular Models

SSIS

DAX

Power BI

Data Warehousing

Dimensional Modeling

Data Governance

Master Data Management

Job description

Fanisko seeks an experienced Technical Data Architect & Reporting Analyst Contractor to lead enterprise reporting architecture for Oracle Fusion ERP, Oracle EPM, and SQL Server environments. You will design data models, pipelines, and semantic layers to support Accounting, Finance, FP&A, and executive leadership.

Responsibilities include building SSAS Tabular models, DAX calculations, data governance, and near-real-time reporting strategies while ensuring data accuracy and SOX-compliant controls.