GM Financial

Receive alerts when this company posts new jobs.

ABS Reporting Systems Analyst III - Treasury

at GM Financial

Posted: 7/31/2018
Job Reference #: 32224

Job Description

  • Job LocationsUS-TX-Fort Worth
    Requisition ID
    2018-32224
    Employee Type
    Full Time-Regular
    Category
    Accounting / Finance / Treasury
  • Overview

    ABS Reporting Systems Analyst III is a critical technical role within the GMF North America Securitization and Conduit Reporting team. This position will design process improvements, create SQL reports, write functional specifications, develop and test system plans, document processes and programs, advise users on program use, and resolve production problems. This position involves a high level of coordination with other departments and third-party software vendors.

    Responsibilities

    JOB DUTIES:

    • Analyze Data to troubleshoot process problems and drive process improvement
    • Define functional requirements including requests for new reports or system enhancements
    • Translate complex requirements into business requirements/functional specifications documents in coordination with the data warehouse teams
    • Understand data warehouse design and data modeling
    • Develop SQL, Informatica , Access, Cognos, or Discoverer queries to manipulate analyze and report on large data sets
    • Data extraction, creation, manipulation of multiple files and or databases
    • Find and correct operational errors, determine how to design system enhancements and test programs and systems
    • Keep up to date on current technology through training and outside materials
    • Other duties may be required as necessary

    REPORTING RELATIONSHIP:

    Reports to: AVP ABS Reporting Systems - Treasury

    Direct Reports: None

    Qualifications

    Knowledge

    • Strong understanding of data warehousing methodology, data modeling, ETL, databases, and Business Intelligence and their processes
    • Strong knowledge of SQL
    • Proven history of understanding and utilizing Business Intelligence and Data Warehouse Applications such as Cognos and SAS

    Skills

    • Ability to interpret and or write system documentation and technical specifications
    • Strong ability to write advanced SQL coding to help analyze data
    • Proven history of successful problem solving with strong sense of ownership and urgency
    • Ability to lead a project team from project definition through deployment
    • Ability to make sound decisions and exercise good judgment
    • Interpersonal skills necessary to manage business and technology relationships with internal and external clients

    Experience

    • BA or BS in Information Systems, Computer Science, Finance, Business or other related field preferred
    • Minimum of 7 years’ experience in data analysis/reporting and or business system analysis, design, implementation and support
    • Experience in Asset Backed Securitization reporting a plus
    • Embarcadero Rapid SQL, Informatica Power center Visual Basic, Excel, Word, Access, and Cognos Reports
    • Must pass a SQL query test

    WORK CONDITION:

    Normal office environment

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

    Application Instructions

    Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!