Query Support Junior

Chickasaw Nation Industries Shawnee, Kansas
junior indian accounting litigation data microsoft microsoft access queries technical search sql sql server server
January 13, 2023
Chickasaw Nation Industries
Shawnee, Kansas
It's fun to work in a company where people truly BELIEVE in what they're doing!
We're committed to bringing passion and customer focus to the business.
SUMMARY
The Query Support Junior 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. This position leads a project and team focused on identifying, locating and securing available data / records necessary to conduct and support historical accounting efforts.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include the following. Other duties may be assigned.
Assists with managing a team 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.
Applies various analytical methods and tools, such as machine learning, computer modeling, pilot tests, and statistical sampling.
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.
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.
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.
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 four (4) years' technical experience and three (3) 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
Possesses or has the ability to obtain a Public trust clearance
JOB SPECIFIC KNOWLEDGE / SKILLS / ABILITIES
Experience in dealing with Tribal and Individual Indian Trust Funds which shall include knowledge of how the funds were received and processed throughout history by the BIA and the OST.
Familiarity with the kinds of documents created in managing the two types of Indian Trust Funds.
Ability to analyze litigation Requests for Production and Interrogatories to determine potentially responsive documents and identify query criteria for documents needed.
Familiar with how to create, save, modify and run Microsoft Access and SQL Server queries, including familiarity with how to store and analyze query results into Microsoft Access and export certain fields of data, sometimes from different tables in Access to Excel spreadsheets.
Strong planning, organizational and written communication skills.
Ability to meet project deadlines, flexibility in changing project direction, and ability to maintain different projects at the same time.
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 work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations.
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 successfully perform 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.
Please note that CNI is closely monitoring Executive Orders and will be following any final decisions or mandates regarding the COVID-19 Vaccination as a federal contract provider.
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.
#indcni
If you like wild growth and working with happy, enthusiastic over-achievers, you'll enjoy your career with us!Estimated Salary: $20 to $28 per hour based on qualifications.


Report this job

Similar jobs near me