Team Lead - Query Litigation
CurrentSUMMARYThe Query-Litigation Team Lead provides professional documentation search assistance to the Office of Historical Trust Accounting (OHTA). The OHTA provides historical accountings of Individual Indian Money (IIM) accounts and litigation support for trust fund related litigation filed by Indian tribes against the United States. Leads a team focused on identifying, locating and securing available data/records necessary to conduct and support historical accounting efforts.ESSENTIAL DUTIES AND RESPONSIBILITIESLeads a team focused on identifying, locating and securing available data / records necessary to conduct and support historical accounting efforts.Analyzes critical information related to historical accountings of Individual Indian Money (IIM) accounts and trust fund related litigation filed by Indian tribes.Works with multiple historical accounting systems in the thorough analysis, reporting and archival of historical accounting information.Produces delivery ready reports for use in information and settlement meetings.Follows established processes for archiving and retaining work products.Analyzes litigation Requests for Production and Interrogatories to determine potentially responsive documents and identify query criteria for documents needed.Creates, saves, modifies and runs Microsoft Access and SQL Server queries, including storing and analyzing query results in Microsoft Access and exporting certain fields of data, sometimes from different tables in Access to Excel spreadsheets.Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output.