Note: The job is a remote job and is open to candidates in USA. Harris Williams is a global investment bank specializing in M&A and private capital advisory services. They are seeking an Oracle ERP / Fusion Data Intelligence Reporting Analyst to support financial, operational, and management reporting across Oracle ERP Cloud and related technologies, developing reports, dashboards, and analytics solutions for finance leaders.
Responsibilities
- Develop and maintain reports, dashboards, and analytics across Oracle ERP, Oracle Fusion Data Intelligence (FDI), and Oracle EPM
- Build BI Publisher reports and data extracts from Oracle ERP, and develop interactive dashboards using OTBI (Oracle Transactional Business Intelligence) and Oracle Analytics
- Partner with Finance and Accounting teams to gather reporting requirements and translate them into clear, reliable reporting solutions
- Work hands-on with Oracle ERP tables, attributes, and financial data structures to source and model the right data
- Support reporting across Oracle Financial modules, including General Ledger, Accounts Payable, Accounts Receivable, Projects, Procurement, Cash Management, Fixed Assets, and Tax
- Support data extraction and reporting datasets using BICC, and support reporting and analytics for Oracle Fusion Data Intelligence
- Assist with EPM and financial reporting processes, and ensure data accuracy and consistency across ERP, EPM, and analytics platforms
- Document report definitions, dashboard specifications, and reporting processes so solutions are repeatable and well-governed
- Support system upgrades, testing, and implementation activities related to the firm's reporting and analytics platforms
Skills
- 5–7 years of experience working with Oracle ERP reporting tools (strong Oracle E-Business Suite (EBS) experience may also be considered alongside complementary skills)
- Hands-on experience with BI Publisher, OTBI (Oracle Transactional Business Intelligence), and Oracle Analytics / Oracle Analytics Cloud
- Strong working knowledge of Oracle ERP tables, attributes, and data structures
- Experience reporting across core Oracle Financial modules: General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Projects (PA), Procurement (PO), Cash Management (CM), Fixed Assets (FA), and Tax
- A track record of developing financial reports and management dashboards
- Strong SQL and data analysis skills
- Experience partnering directly with Finance and Accounting teams to deliver reporting solutions
- Oracle Enterprise Performance Management (EPM) reporting
- Business Intelligence Cloud Connector (BICC) and Oracle Fusion Data Intelligence (FDI)
- Experience with financial reporting, forecasting, and management reporting systems
- Experience working in a financial services, investment banking, or professional services environment
- Experience with data warehousing, reporting datasets, and data modeling
- CBAP (Certified Business Analysis Professional) certification preferred
Benefits
- Medical/prescription drug coverage (with a Health Savings Account feature)
- Dental and vision options
- Employee and spouse/child life insurance
- Short and long-term disability protection
- 401(k) with PNC match
- Pension and stock purchase plans
- Dependent care reimbursement account
- Back-up child/elder care
- Adoption, surrogacy, and doula reimbursement
- Educational assistance, including select programs fully paid
- A robust wellness program with financial incentives
- Maternity and/or parental leave
- Up to 11 paid holidays each year
- 9 occasional absence days each year, unless otherwise required by law
- Between 15 to 25 vacation days each year, depending on career level
- Years of service
Company Overview