• ABS Reporting Systems Analyst III - Treasury

    Job Locations US-TX-Fort Worth
    Requisition ID
    Employee Type
    Full Time-Regular
    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.



    • 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



    Reports to: AVP ABS Reporting Systems - Treasury

    Direct Reports: None



    • 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



    • 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



    • 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



    Normal office environment


    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.