• Reporting Systems Analyst II

    Job Locations US-TX-Fort Worth
    Requisition ID
    2018-31578
    Employee Type
    Contingent Worker
    Category
    Accounting / Finance / Treasury
  • Overview

    The ABS Reporting Systems Analyst II - Treasury 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, 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

    Qualifications

    Knowledge

    • Strong understanding of data warehousing methodology, data modeling, ETL, databases, and Business Intelligence and their processes
    • Strong knowledge of SQL, Informatica, Oracle Database
    • Proven history of understanding and utilizing Business Intelligence and Data Warehouse Applications such as Cognos or 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

    Education

    • Bachelor’s Degree in Information Systems, Computer Science, Finance, Business or other related field required

    Experience

    • 0-2 years experience in Asset Backed Securitization reporting preferred
    • Experience in SQL required; Visual Basic, Access, Informatica and Cognos Reports preferred
    • 5-7 years experience in data analysis/reporting and or business system analysis, design, implementation and support required
    • Must pass a SQL query test required

    Work Condition

    • Normal office environment

    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.