Senior Project Lead - Query-Litigation

ESSENTIAL DUTIES AND RESPONSIBILITIES 

Essential duties and responsibilities include the following.   

Leads a project focused on identifying, locating and securing available data / records necessary to conduct and support historical accounting efforts. 

Runs queries and 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. 

Travel may be required. 

Other duties may be assigned. 

Responsible for aiding in own self-development by being available and receptive to all training made available by the company. 

Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output.   

Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and coworkers.  Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources.  Will immediately correct any unsafe conditions to the best of own ability. 

CNI CORE COMPETENCIES 

Responsible for the integration of CNI Core Competencies into daily functions, including commitment to integrity, knowledge/quality of work, supporting financial goals of the company, initiative/motivation, cooperation/relationships, problem analysis/discretion, accomplishing goals through organization, positive oral/written communication skills, leadership abilities, commitment to Affirmative Action, reliability/dependability, flexibility and ownership/accountability of actions taken. 

COMPLIANCE 
Promotes and encourages a culture of compliance with all applicable rules (federal, state, local, Federal Acquisition Regulations, Code of Federal Regulations, Prime Contract requirements, etc.) for themselves and the company as a whole. Fosters an environment in which they will report any violations or reasonably suspected violation of CNI policy, FAR, and/or CFR and are comfortable discussing the myriad compliance, conflict, FAR, CFR, etc. issues that arise during the performance of a government contract. 

 EDUCATION/EXPERIENCE 

Bachelor’s degree and a minimum of one (1) year Team Lead Experience and two (2) years’ Supervisory experience, technical experience related to document search and systems that would have produced these documents; or equivalent combination of education / experience.  Experience in Indian Trust Accounting or document search. Experience in database creation, management, and database queries in Microsoft Access and SQL Server. 

CERTIFICATES/LICENSES/REGISTRATION 

Must be able to obtain a customer clearance for access to facilities, equipment and property (Public trust clearance). 

JOB SPECIFIC KNOWLEDGE/SKILLS/ABILITIES 

Knowledgeable in preservation and recall of historical account data records. 

Proficient knowledge of GAAP, GAAS, federal regulations and guidelines. 

Working knowledge in application of government accounting standards, including cash and accrual accounting.  

Ability to meet project deadlines, have flexibility in changing project direction, and ability to maintain different projects at the same time. 

Adept in data analysis and data reporting skills with solid systems and process orientation skills.  

Excellent Microsoft Office skills with proficiency in SQL, Microsoft Access, VBA and Microsoft Excel, as well as ability to quickly grasp specialized automated systems. 

Excellent verbal and written communications skills with ability to produce professional accounting and financial reports. 

Highly organized with ability to manage multiple projects and priorities. 

Excellent customer service skills with ability to be self-motivated.  

Extremely detail-oriented with ability to quickly grasp business needs and issues.  

Working knowledge of accounting records management and filing processes. 

Ability to work both independently and in a team environment toward the successful achievement of goals. 

LANGUAGE SKILLS 

Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.  Ability to write reports and business correspondence.  Ability to effectively present information and respond to questions from groups of managers, customers and coworkers.   

MATHEMATICAL SKILLS 

Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference and volume. Ability to apply concepts of basic algebra and geometry. 

REASONING ABILITY 

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. 

PHYSICAL DEMANDS 

The physical demands described here are representative of those that must be met by an employee to perform successfully the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this job. Work is primarily performed in an office environment. Regularly required to sit. Regularly required use hands to finger, handle, or feel, reach with hands and arms to handle objects and operate tools, computer, and/or controls. Required to speak and hear. Occasionally required to stand, walk and stoop, kneel, crouch, or crawl. Must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, depth perception, and ability to adjust focus. Exposed to general office noise with computers printers and light traffic. 

EQUAL EMPLOYMENT OPPORTUNITY STATEMENT 

All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, age, marital status, pregnancy, genetic information, or other legally protected status.