Match score not available

Oracle Data Analyst - Remote

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

Offer summary

Qualifications:

5+ years of experience in Oracle ERP environments, preferentially Oracle Fusion Cloud, with proficiency in reporting technologies like BI Publisher and OTBI, Experience with PL-SQL reporting and data analysis using Excel for tie-outs.

Key responsabilities:

  • Analyze data requirements, research, test, and validate data extracts for accuracy and completeness
  • Create data design documentation for dimensional modeling and schema definition
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-VH1

LI-REMOTE
LI-VH1

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
  • Collaboration
  • Microsoft Excel

Data Analyst Related jobs