Oracle Data Analyst

From our global experience working across thousands of projects and initiatives over the past 55 years, weve learned that relationships, business, work, innovation, strategy, and transformation are all about people. And, to put it simply, GP Strategies is about our people - an extensive global network of learning experts. Additional information can be found at www.gpstrategies.com.

Summary

GP Strategies has a strategic IT objective to transform into a “data-driven” organization where use of and facility with Business Intelligence (BI) tools is as common as it is effective. A key service BI team in GP Strategies is to make data in our core system of record (Oracle Cloud Fusion) available through our Enterprise Data Warehouse. Discovering which data sets to extract requires careful research, analysis and validation to ensure data quality for the developers building decision support tools on this key data set.

Duties/Responsibilities

• Analyzes and documents data requirements for BI data extraction.
• Researches appropriate BI views to extract and meet reporting needs.
• Tests and validates extracts for accuracy, completeness and correct granularity.
• Creates the data design documentation for downstream dimensional modeling and date set schema definition.
• Monitors and manages extraction jobs.
• Performs tie-outs for data quality testing of Enterprise Data Warehouse

Design

• Familiarity with dimensional modeling for OLAP reporting designs.
• Understanding of relational database schemas
• Data analysis skills and experience

Familiarity With Most Modules In The Following Areas

Oracle ERP functionality

• • Finance & Accounting
  • Procure to Pay
  • Accounts Receivable
  • Accounts Payable
  • Project Management
  Oracle HCM
• • OTL
  • Benefits
  • Absence management
  • PL-SQL
  • Oracle BI Publisher
  • Oracle OTBI
  Related Experience

Technical

• 5+ years working within Oracle ERP environments (preferably, Oracle Fusion Cloud)
• 2+ using Oracle reporting technologies (BI Publisher, OTBI etc.)
• 2+ years working with various Oracle ERP modules
• 2+ years working with PL-SQL reporting
• 2+ years working with Excel (or equivalent) for data analysis performing tie-outs

• Excellent English oral and written communication skills
• Business analysis and requirements gathering techniques and practices
• Facility in managing stakeholder/SME relationships and building business partnerships
• Ability to collaborate effectively with technical and non-technical people, including those at the highest levels of the organization
• Uses Agile software methodologies for work execution and team collaboration

GP Strategies is committed and proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, veteran status, or marital status.

#Remote

Primary Location

IN-TN-Chennai

Job

Technical and Professional

Organization

IND 204 GPS India

Schedule

Regular

Job Type

Full-time

Job Posting

Sep 5, 2023, 1:01:21 AM