• Sr.Oracle EBS - Technical Business Systems Analyst

    Job Locations US-TX-Arlington
    Requisition ID
    2018-32645
    Employee Type
    Full Time-Regular
    Category
    Information Technology
  • Overview

    The Sr. Oracle Application Technical Specialist – Cognos position, under limited supervision, provides advanced support for Oracle E-business Suite acting as an internal Functional/Technical analyst resource. This includes, but is not limited to, gathering business report requirements, assisting business partners with user acceptance testing, communication, documentation, training, report testing and end-user production supportThe Sr. Oracle Application Functional/Technical Specialist resource will work with Cognos developers to support all aspects of business analytics and reporting. Technical skills required include a solid understanding of the Oracle ERP table structures using basic to advanced SQL select statements, provide adequate data issue resolution with detailed documentation and anticipate business partner's questions and provide solutions to answer analytics and reporting questions. This employee has heavy contact with other business departments, as well as, outside vendors in support of international IT operations.                         

    Responsibilities

    Plan, organize and coordinate the business requirements gathering and/or development of analytics and reporting in accordance with strategic business plans and industry standards on multiple large projects

    Responsible for analyzing and providing functional/technical knowledge of supported applications and user needs. Document the requirements, help coordinate reporting solutions following the GMF Software Development Lifecycle methodology

    Investigate and resolve data issues and analyze all business requirements and perform interview with all stakeholders

    Coordinate with all customers and analyze test queries and analyze client issues and assist all application analysts to translate all workflow requirements to efficient data points

    Assist with the creation, documentation and execution of report test scripts for supported systems.  Research, implement and document solutions to issues identified during testing

    Develop and perform tests on various enterprises and provide dashboard solutions with help of Cognos software and assist all end users

    Collaborate with Project Management Office, development teams, data integration teams (ETL, Data Architect) for providing new data sources for analytics and reporting

    Interface with vendors and suppliers in support of business applications

    Provide direction to and mentor other teammates

    Communicate with management and business partners on production and project statuses in a timely manner

    Work closely with internal business units to facilitate project completion.


    Performs other duties as assigned

    Conforms with all corporate policies and procedures


    Qualifications

    Knowledge

    Knowledge of relational database structures, start schema structures, models, and diagrams

    Understanding of enterprise data integration and data architecture

    Advanced knowledge of business processes for supported business groups.

    Advanced knowledge of information technology systems, infrastructure and operations.

    Advanced working knowledge of information systems and operations systems for supported business groups.

    Knowledge of business processes for supported business groups.

    Knowledge of GM Financials core business functions, policies and procedures.

    Knowledge of information technology systems, infrastructure and operations.

    Knowledge of security methodologies, policies, standards and best practices.

    Knowledgeable of best practices in information technology governance and regulatory landscape for financial institutions.

    Significant experience in a large and complex business environment.

    Working knowledge of information systems and operations systems for supported business groups.

     

    Working knowledge of the Corporate Business solution environment.


    Skills

    Ability to analyze data using Excel for reporting and data mining purposes.

    Ability to effectively lead, organize, and supervise.

    Ability to interact with staff at all levels.

    Ability to meet expected delivery dates and the tasks necessary to achieve objectives.

    Ability to work directly with senior level management.

     

    Advanced computer skills and conversance in information technology issues.

    Advanced experience with data visualization concepts and tools.

    Deadline oriented.

    Excellent writing and speaking skills.

    Must be a self-starter and able to manage the investigations function with minimal supervision.

    Strong ability to analyze data using Excel for reporting and data mining purposes.

    Strong in the use of Microsoft Office software.

    Strong people skills.


    Additional Knowledge Skills and Abilities

    Experience with Cognos version 9.X, 10.X or Cognos Analytics

    Oracle R Financial eBusiness Suite modules (GL, AP, AME, SLA, FA, PAY, WF, CE, PO, iProc, iExp and AR Lite)

    Excellent Proactive Planning and Initiative in success of all project and support efforts

    SQL Select and Advanced SQL

    Experience with Human Resource and or Financials applications such as; Oracle ERP modules and databases, SuccessFactors, iCIMS, Treasury Management Systems, or Imaging Systems would be a plus. 

     



    Education

    Education Level

    Education Details

    Req

    Pref

    N/A

     

    Bachelor’s Degree

    ​Finance, Information Systems or Accounting

     

    X

     

     


    Work Experience

    Experience

    Experience Details

    Req

    Pref

    N/A

     

    Greater than 10 years

    of implementation and support on ERP system as a functional resource

     

    X

     

     


     

    Essential Functions:

    The following are Essential Job Functions, such as physical, sensory and cognitive demands representative of those that must be met by an employee to successfully perform the essential functions of this job. 

    Essential Functions

    IT Positions


    Essential Type

    Ability to convey information.

    Concentrate and focus with frequent interruptions.

    Lifting or raising object(s) less than  pounds.

    Must be able to operate a motor vehicle (company, personal or rental) for travelling from one work location to another work site.

    Perceive normal speaking levels with or without correction.

    Repetitive motion: use fingers to click and scroll mouse and type on computer keyboard.

    Walking and moving from one work location to another.

    Repetitive motion: use hand and wrist to move around computer mouse.

    Reaching or extending hands and arms in any direction.

    Lifting or raising object(s) more than  pounds.

    Converse verbally with clients, colleagues and vendors.

    Ability to receive information through oral communication.


    Working Conditions

    Occasional overtime or split shifts may be required.

    Subject to loud noise.

    Subject to stressful situations.

     

     

    some travel required.

    normal office environment.

    Fast-paced office environment.

    Strong focus on providing quality service to internal and external customers.

    Work a flexible schedule including extended business hours, weekends and holidays.

    Work additional hours based on production demands requiring mandatory overtime.

    Flexible schedule with possibility of working long hours.

    Limited travel may be required to support business needs.

    Must be able to deal with stressful office conditions while troubleshooting problems.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.