ERP Report Lead

About the Opportunity

Driscoll’s is seeking an Oracle Cloud Fusion ERP Reporting Lead with experience to turn data into reports and visually intuitive dashboards that impact key decision making in the organization. ERP report lead will guide reporting developers to efficiently analyze, interpret, and organize enormous amounts of data from the Oracle Cloud Fusion environment.

 Responsibilities

• Lead the rationalizing of new reporting needs and conversion of reporting from legacy system to Oracle Fusion Cloud ERP system and provide a final list of required operational, financial, regulatory, and analytics reports for future state.
• Collaborate with functional leaders, Business Stakeholders, IT and project teams to create and manage Fusion Oracle Cloud based reporting solutions.
• Work with business teams to document detailed report requirements into functional specifications for all reports to be used during the progressive build cycles of the implementation.
• Demonstrate the ability to accurately analyze information and make sound decisions regarding technology-related projects, including scope, system requirements, testing, and implementation.
• Work closely with senior business leaders and users to determine the reporting requirements.
• Effectively translate complex business requirements into technical requirements.
• Manage technical delivery resources supporting report development, testing, deployment activities in onshore/offshore model.
• Support strategy for deploying designing and building reports using Oracle Fusion Cloud ERP’s OTBI, BI Publisher.
• Lead projects and change requests which involves heavy team collaboration between Functional leaders, Business stakeholders, IT and/or other areas as appropriate.
• Work with Security and Compliance team to define and build structure that defines roles/privileges and to control report access.
• Understand inter-departmental reporting requirements, design reporting models, and roll out various reports aligning with the Data security.
• Collaborate with functional leaders, application managers, IT, and project teams to create and manage Oracle Fusion Cloud ERP based reporting solutions with a creative mind and innovative focus.
• Generate reports/queries, including writing, maintaining, and supporting a variety of reports or queries utilizing Oracle Fusion Cloud reporting tools (OTBI & BIP). Assist in development of standard reports, dashboards, compliance reports for ongoing customer needs. Help maintain data integrity in systems by running queries and analyzing data.
• Document report distribution requirements and develop an overall internal/external delivery schedule.
• Design, development, and maintenance of ongoing KPIs, metrics, reports, analyses, dashboards, etc. to drive key business decisions.
• Monitor, respond and resolve tickets and issues submitted by users, ability to perform RCA on critical tickets/incidents.
• Train and mentor team members and management to understand BI Publisher and assist with development of BI Publisher data models, templates & reports
• Understand inter-departmental reporting requirements, design reporting models, and roll out various reports aligning with the Data security.

Candidate Profile

CANDIDATE PROFILE

Requirements

• Education, Knowledge and Experience

Academic Degree:

• Bachelor's degree in Information Technology, Business Analytics, or related field

Professional experience on the job:

• 5+ experience in implementing and rolling out Oracle Cloud Fusion Application OTBI and BIP reporting tools.

Professional experience on the functional area:

• 8+ years of experience in rolling out BI reports using various reporting models in oracle cloud fusion
• Minimum of 5 years SQL experience

Areas of experience:

• Experience in Reporting Tools (OTBI, BI Publisher), Performance Tuning, troubleshooting abilities, and advanced SQL Skills - writing SQL scripts – required, PL SQL – preferred
• Experience with Master (customer, supplier, COA, etc.) and multi organization/region transaction (GL, PO, AP, etc.) data in Oracle Fusion Cloud.
• Must be self-directed and able to work effectively in a team environment with little direct supervision.
• Excellent verbal and written communication skills, organizational skills and attention to detail, time management skills with a proven ability to meet deadlines.

• Strong functional knowledge of Oracle Fusion Cloud’s Financial, Supply chain management module and Procurement module. Financial module not limited to General Ledger, Accounts Payable, Project Costing, Fixed Assets, Accounts Receivables, and Accounting Hub. Supply chain management module not limited to Procurement, Order Management and Product Management. Procurement module is not limited to supplier management, sales, and contracts
• Strong knowledge of ERP systems and understanding of data flow between applications
• Strong implementation knowledge on the reporting tools Oracle Fusion OTBI, OBIEE, BIP etc.
• OTBI and BI Publisher reporting knowledge and experience.
• Strong coding knowledge on SQL, PLSQL
• Good functional and technical knowledge of Oracle Cloud Fusion Reporting (SAAS)
• Techno/Functional knowledge of Finance business applications
• Experience with Oracle Business Intelligence, Fusion Extracts, OTBI Reports, and BI Publisher
• Strong familiarity with Oracle's Cloud Fusion ERP Financials out-of-the-box reports
• Functional knowledge of the Oracle ERP Cloud Fusion application (financials & supply chain management)

• A valid passport and the ability to travel internationally without restrictions.

Certifications and Technical skills:

Add level of expertise Basic/Intermediate/Advanced/Expert

• Oracle Business Intelligence Certifications
• OCI Certifications
• Advanced knowledge of Oracle Fusion Reporting

Foreign Language:

• English

Experience Managing People (years):

2-3 Years

Compensation & Benefits:

The following information is provided in good faith as a general description of the salary range and benefits for the position posted. The actual compensation offered to the successful candidate is dependent upon experience, skills, education, work location, internal pay equity, and other objective job-related factors. 

Salary Range estimated for ERP Report Lead: $97,000 to $150,000 USD.

Driscoll’s is committed to a culture of care and offers an attractive benefits package that includes comprehensive medical, dental, and vision coverage, life insurance, and disability coverage for positions working more than 30 hours per week. Other benefits include: 401(k) with employer match, profit-sharing participation, paid sick time, paid vacation, paid personal and family care leave, and a free Employee Assistance Program (EAP). More detailed information regarding the benefits package, will be shared during the application process.