Operations Business Analyst

 

Job description for: Operations Business Analyst

Department: EMEA Deal Management SSC

Reports to: EMEA Deal Management Ops Support Senior Manager

 

Role Overview:

 

This role is part of the Operations team within EMEA Deal Management SSC. The role requires supporting the management team with specific projects and reports.

 

A significant part of the job is to perform reporting and analytics for the management team within the center. It requires timely delivery of reports, analysis and projects requested by the management, helping drive effective decision-making in either special projects or day-to-day analytics.

 

In order to support the reporting activity, the role also requires the use of programming technologies (Oracle SQL, PL/SQL, Oracle Application Express, etc.) to develop and/or enhance internal applications used by the Deal Management department for reporting and/or automation of internal processes.

 

Required Technical Skills:

• Microsoft Office Excel and the Microsoft Office Suite, VBA – mandatory1+ years’ experience with SQL and PL/SQL mandatory
• 2+ years’ experience with SQL and PL/SQL mandatory
• HTML, CSS, JavaScript, Oracle APEX is a strong plus

 

Responsibilities:

Covers the entire reporting process, from raw-data extraction to complex processed, customized and user-friendly reports providing meaningful and actionable insights for business decisions on different levels of the organization:

• Reporting on a daily, weekly, monthly and quarterly basis and delivery of information towards the management team for ulterior decision. This involves gathering the data inputs, running queries, reviewing/reconciling results and delivering the final product to requestors
• Works closely with the requestor in order to identify reporting needs (builds reports definition and format), as well as to ensure an accurate and uniform reporting frame;
• Analyze and reconcile data with multiple parties to ensure report/analysis accuracy;
• Undertake special tasks and projects as required;
• Regularly review process and outputs to identify areas for process improvement and increased efficiencies;

 

Designs and implements tools that automate and optimize the adoption of a data savvy organizational culture and insight driven decision making within Deal Management department

• Maintains and improves existing APEX applications, provides maintenance and regular updates for existing applications and is POC for any related technical subject
• Delivers workshop sessions covering both hardskills (Excel workshops, APEX workshops, etc.) and business as usual analytics topics

 

Education:

• Bachelor Degree Diploma

 

Competencies:

• Excellent command of spoken and written English;
• Excellent analytical, communication and organizational skills, and demonstrated collaborative skills;
• Proficiency in Microsoft Office Excel (Lookups, formulas, etc.) and the Microsoft Office Suite;
• Ability to handle large files and databases and to maintain appropriate records and documentation;
• Attention to detail;
• Clear and concise presentation of analysis and findings;
• Practical knowledge in importing data for use in reporting software, spreadsheets and graphs;
• Possess the skill to creatively solve problems and propose solutions with minimal direction in a fast paced environment that implies project or task concomitant prioritization and change, often meeting tight deadlines 

Processes and invoices customer orders in accordance with agreed contracts. Monitors contract and business terms to mitigate Oracle's risk.

As a member of Contract Management you will assist customers, both internal and external, with license contract interpretation, negotiations and administration of licensing agreements including extensions, new business, invoicing, credit holds, receivable issues and consolidations. Draft and negotiate standard and non-standard contracts. Act as a liaison between consultants, Credit, License, Tax, Business Practices, Revenue accounting, and customers to resolve contractual and consulting business issues. Validate all aspects of contract packages for accuracy and compliance with Oracle's Business Practices and Consulting Business Approvals/Process while maintaining customer satisfaction and responsiveness. Submit contract order packages to Revenue accounting for order processing and project funding. Anticipate problems and initiate actions to ensure customer orders are processed efficiently. Prepare contract status reports.

Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. Excellent written, verbal, interpersonal, and analytical communication skills. Organized and detail oriented. Experience drafting standard contractual documents. Ability to work effectively under time critical deadlines. Proficient in Email, MS Word and Excel. Knowledge of Oracle policies and procedures desired. 2 year experience in contracts, purchasing, or equivalent. BA/BS degree, Paralegal Certification or equivalent years of experience.

As part of Oracle's employment process candidates will be required to successfully complete a pre-employment screening process. This will involve identity and employment verification, professional references, education verification and professional qualifications and memberships (if applicable).