ERP Reporting Analyst

Summary

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

Qualifications

Must Haves

• 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

Nice to Haves

• 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