Note: The job is a remote job and is open to candidates in USA. Marcus & Millichap is seeking a senior-level Technical Data Architect and Reporting Analyst to support enterprise financial reporting and analytics. The role will design Oracle Fusion ERP and EPM data architectures, build data pipelines and SQL Server reporting databases, develop SSAS Tabular semantic models, and deliver scalable reporting solutions for Accounting, Finance, FP&A, and executive leadership.
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: + 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
- 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
- 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 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
- 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
- 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
Skills
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Finance, Accounting, or related field
- 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
- Deep understanding of Oracle Fusion database structures and business processes for:
- General Ledger
- Accounts Receivable
- Accounts Payable
- Cash Management
- Fixed Assets
- Project Portfolio Management (PPM)
- Budgeting & Planning
- Financial Consolidation
- Oracle Fusion subject areas
- Transactional and reporting tables
- Oracle Financial reporting framework
- Security and role-based access model
- 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
- Exceptional analytical and problem-solving skills
- Strong communication and stakeholder management capabilities
- Ability to translate complex technical concepts into business-friendly language
- Strong financial systems acumen
- Self-starter capable of operating independently
- Detail-oriented with a focus on accuracy and data integrity
- Ability to work effectively with Finance, Accounting, FP&A, and IT leadership teams
- Strong documentation and technical design skills
- 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
Benefits
- Remote work arrangement
- Contract position
Company Overview
Company H1B Sponsorship