ERP Reporting Analyst

PNC Financial Services Group, Inc.; Richmond (VA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Harris Williams is seeking an Oracle ERP / Fusion Data Intelligence Reporting Analyst to support financial, operational, and management reporting across Oracle ERP Cloud, Oracle Fusion Data Intelligence (FDI), and Oracle Enterprise Performance Management (EPM).

You will develop reports, dashboards and analytics that finance leaders rely on, partnering with Finance, Accounting and IT to deliver reliable reporting solutions and data-driven insights.

Qualifications

• 5–7 years of experience with Oracle ERP reporting tools, strong Oracle EBS experience acceptable.
• Hands-on experience with BI Publisher, OTBI and Oracle Analytics/Oracle Analytics Cloud.
• Strong SQL and data analysis skills; ability to partner with Finance and Accounting teams.

Responsibilities

• Develop and maintain reports and dashboards across Oracle ERP, Oracle FDI and Oracle EPM.
• Create BI Publisher reports and data extracts from Oracle ERP.
• Build interactive dashboards using OTBI and Oracle Analytics.
• Collaborate with Finance and Accounting to gather requirements and translate into solutions.
• Source and model data from Oracle ERP tables and financial structures.
• Support reporting across GL, AP, AR, Projects, Procurement, Cash Management, FA and Tax.

Skills

Oracle ERP reporting tools

BI Publisher

OTBI

Oracle Analytics

SQL

Finance collaboration

Education

Bachelor's degree

Tools

Oracle EBS

BICC

FDI

Job description

Position Overview

Harris Williams is seeking an Oracle ERP / Fusion Data Intelligence Reporting Analyst to support financial, operational, and management reporting across Oracle ERP Cloud, Oracle Fusion Data Intelligence (FDI), and Oracle Enterprise Performance Management (EPM).

Role

In this role you will develop reports, dashboards and analytics solutions that finance leaders rely on. Working with Finance, Accounting and IT, you will build financial reports, management dashboards using BI Publisher, OTBI, Oracle Analytics and other Oracle reporting tools.

Core Responsibilities

• Develop and maintain reports, dashboards and analytics across Oracle ERP, Oracle FDI and Oracle EPM.
• Create BI Publisher reports and data extracts from Oracle ERP.
• Build interactive dashboards using OTBI and Oracle Analytics.
• Partner with Finance and Accounting teams to gather requirements and translate into reliable reporting solutions.
• Work hands‑on with Oracle ERP tables, attributes and financial data structures to source and model data.
• Support reporting across Oracle financial modules: General Ledger, Accounts Payable, Accounts Receivable, Projects, Procurement, Cash Management, Fixed Assets and Tax.
• Support data extraction and reporting datasets using BICC.
• Assist with EPM and financial reporting processes and ensure data accuracy and consistency.
• Document report definitions, dashboard specifications, and reporting processes for repeatability and governance.
• Support system upgrades, testing and implementation activities for reporting and analytics platforms.

Required Qualifications

• 5–7 years of experience with Oracle ERP reporting tools; strong experience with Oracle E-Business Suite (EBS) is acceptable.
• Hands‑on experience with BI Publisher, OTBI (Oracle Transactional Business Intelligence) and Oracle Analytics / Oracle Analytics Cloud.
• Strong knowledge of Oracle ERP tables, attributes and data structures.
• Experience reporting across core Oracle Financial modules: GL, AP, AR, Projects, Procurement, Cash Management, Fixed Assets and Tax.
• Track record of developing financial reports and management dashboards.
• Strong SQL and data analysis skills.
• Proven ability to partner directly with Finance and Accounting teams.

Preferred Qualifications

• Experience with Oracle Enterprise Performance Management (EPM) reporting.
• Knowledge of Business Intelligence Cloud Connector (BICC) and Oracle Fusion Data Intelligence (FDI).
• Experience in financial services, investment banking or professional services environments.
• Experience with data warehousing, reporting datasets and data modeling.
• Strong reporting and data visualization skills, attention to detail, communication and documentation skills.

Competencies & Skills

• Reporting and data visualization
• Detail orientation and data accuracy
• Effective collaboration with Finance, Accounting and IT
• Strong communication and documentation

Education & Experience

A bachelor’s degree or comparable combination of education, certifications and experience. Minimum 3+ years relevant industry experience.

Work Arrangement

Hybrid schedule for candidates in or near Richmond, VA, or fully remote for other locations.

Salary

Base salary: $120,000 – $150,000. Salary varies by location, market data and candidate profile.

Equal Employment Opportunity

Harris Williams provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status or any other protected category. We are committed to providing a fair and inclusive workplace.