Match score not available

Oracle Data Analyst - Remote

Remote: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

5+ years experience in Oracle ERP environments, preferably Oracle Fusion Cloud, Familiarity with PL-SQL reporting and Oracle reporting technologies like BI Publisher and OTBI.

Key responsabilities:

  • Analyze data requirements for BI extraction, research BI views, test and validate extracts
  • Create data design documentation, monitor extraction jobs, perform tie-outs for data quality testing
GP Strategies Corporation logo
GP Strategies Corporation Professional Training & Coaching Large https://www.gpstrategies.com/
1001 - 5000 Employees
See more GP Strategies Corporation offers

Job description

Description
Oracle Data Analyst

Remote

GP Strategies Corporation is a global workforce transformation provider of organizational and technical performance learning solutions. GP Strategies' solutions improve the effectiveness of organizations by delivering innovative and superior training, consulting, and business improvement services customized to meet the specific needs of its clients. Clients include Fortune 500 companies, automotive, financial services, technology, aerospace & defense industries, and other commercial and government customers. Additional information can be found at 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.

· Research 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

Required Skills
Design

· Familiarity with dimensional modeling for OLAP reporting designs.

· Understanding of relational database schemas

· Data analysis skills and experience

Technology

· Familiarity with both transactional interfaces and associated table structures in the following areas:

o Oracle ERP functionality

§ Finance & Accounting

§ Procure to Pay

§ Accounts Receivable

§ Accounts Payable

§ Project Management

o Oracle HCM

§ OTL

§ Benefits

§ Absence Management

§ Taleo Recruiting

· PL-SQL

· Oracle BI Publisher

· Oracle OTBI

· Preferred

o Oracle BI Connector Console (BICC)

o Oracle UCM

Related Experience
Technical

· 5+ years working within Oracle ERP environments (preferably, Oracle Fusion Cloud)

· 3+ using Oracle reporting technologies (BI Publisher, OTBI etc.)

· 3+ years working with various Oracle ERP modules

· 3+ years working with PL-SQL reporting

· 2+ years working with Excel for data analysis performing tie outs

Other skills and experience

· 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

Diversity comes naturally to us at GP Strategies. With more than 4000 employees in over 30 countries, being diverse is second nature. Yet, it’s more than just about location, our style focuses on performance and revolves around respect, fairness and working collectively to achieve our goals. We support our people, no matter who they are, or where they are from because they have different perspectives and attitudes. That’s how ideas are born and enable us to work smarter.

GP Strategies is committed to creating a diverse environment and is 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.

#LI-LD1

#LI-REMOTE

Required profile

Experience

Level of experience: Senior (5-10 years)
Industry :
Professional Training & Coaching
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Verbal Communication Skills
  • Microsoft Excel
  • Collaboration

Data Analyst Related jobs