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