Skip to main content

Summer 2019 Information Management Student Volunteer

Summer 2019 Information Management Student Volunteer

Environment and Natural Resources Division (ENRD)
Washington, D.C.
Information Management Student Volunteer
601 D St NW
Washington, DC 20004
United States
Summer 2019

About the Office:

As a federal leader recognized by our employees, who consistently rank the Division as a top federal Agency Subcomponent in the “Best Place to Work in the Federal Government” survey, the Environment and Natural Resources Division (ENRD) is a great place to work. Our office is conveniently located near the Navy Memorial/Archives Metro. A wide variety of shopping venues, the Verizon Center, museums, the National Mall, restaurants, and coffee shops are all within walking distance.

To learn more about ENRD, visit us at https://www.justice.gov/enrd/about-division.

Job Description:

This undergraduate (Junior and Senior) and/or graduate student volunteer opportunity is located in the Office of Information Management (OIM), Executive Office (EO), Environment and Natural Resources Division (ENRD), U.S. Department of Justice (DOJ). OIM provides support to ENRD management, attorneys, and support staff by developing and maintaining complex management information applications and websites critical to the mission of the Division. OIM also produces a variety of statistical information used in the management of the Division and responding to requests from Congress, the public, and other stakeholders.

The primary role of the OIM Intern is to support OIM’s IT Specialist/Data Analyst in the production of reports from ENRD’s Case Management System (CMS). ENRD attorneys defend numerous Federal agencies in cases which have been filed against the Government, and prosecuting affirmative and criminal lawsuits on behalf other government agencies. These cases fall into many diverse areas of litigation such as condemnation, bankruptcy, water rights and administrative law.  ENRD uses the CMS information to measure performance, assess resource needs and expenditures, and track hours for individual cases. Case Management Liaisons enter key information describing each case into CMS and Attorneys and other staff, enter their case hours into CMS’ Time Reporting Module (TRM).  

The OIM Intern’s role in this process would be to consult with the IT Specialist/Data Analyst to determine what type of report is needed and which tables or views contained the desired data. OIM’s intern would create the necessary script using Microsoft SQL Server Management Studio, and provide the finished script to the IT Specialist/Data Analyst who would create the report. It may be necessary to analyze existing legacy reports to determine the source of the data or the required database joins and groupings.

A secondary role of the OIM Intern would be to assist with ENRD’s Time Data Integrity review process. To ensure that the time data in ENRD's CMS is accurate, time reporters and managers must periodically review that data. The OIM Intern would assist in verifying this data and updating the data via the CMS’ TRM web application, or directly in the Microsoft SQL Server database using Microsoft SQL Server Management Studio. Additionally, the candidate may assist in a project to automate select reports, which entails the conversion of legacy reports into reports generated in Microsoft’s SQL Server Reporting Services (SSRS), and creating automated scripts within Microsoft SQL Server.

The ideal candidate would have a strong background in Microsoft’s SQL Server; be able to write queries using SQL JOINS, Group By and Where clauses; understand Unions and Cursors, be able to create stored procedures and views; and be familiar with Microsoft SQL Server Profiler for troubleshooting and analysis of existing reports. Additionally, knowledge in the following areas would be considered a plus but not mandatory: Microsoft SSRS reporting, database fine tuning, database backup procedures, Microsoft SQL Server update procedures, PowerShell scripting, MySQL, C#, JavaScript, jQuery, PHP and Network Traffic Analysis.

Qualifications:

ENRD prefers undergraduate/graduate students with strong academic qualifications, research and writing skills, ability to communicate clearly, high attention to details, and those who have an interest in the information management field.

Applicants must be U.S. citizens and successfully complete a security clearance prior to appointment. Applicants must have been residents of the United States for 3 of the previous 5 years prior to applying, with exceptions made for active duty military and Foreign Service employees.

Salary: Volunteer (without compensation).

Travel: None

Application Process:

You may apply for a volunteer information management internship in Washington, DC by submitting via email to enrd-oim@usdoj.gov the following materials:

  • ;
  • Cover letter stating hours/days available to work;
  • Resume (which includes your country of citizenship);
  • Link to online portfolio (optional);
  • Copy of your most recent transcript (official or unofficial); and
  • One reference with contact information, including telephone and email (a letter of recommendation is encouraged).

Positions will be filled on a rolling basis.

Application Deadline: Sunday, March 31, 2019

Relocation Expenses: None.

Number of Positions: Up to 2

* * *

 

Department Policies

Equal Employment Opportunity: The U.S. Department of Justice is an Equal Opportunity/Reasonable Accommodation Employer. Except where otherwise provided by law, there will be no discrimination because of color, race, religion, national origin, political affiliation, marital status, disability (physical or mental), age, sex, gender identity, sexual orientation, genetic information, status as a parent, membership or non-membership in an employee organization, on the basis of personal favoritism, or any other non-merit factor. The Department of Justice welcomes and encourages applications from persons with physical and mental disabilities. The Department is firmly committed to satisfying its affirmative obligations under the Rehabilitation Act of 1973, to ensure that persons with disabilities have every opportunity to be hired and advanced on the basis of merit within the Department of Justice.

Reasonable Accommodations: This agency provides reasonable accommodation to applicants with disabilities where appropriate. If you need a reasonable accommodation for any part of the application and hiring process, please notify the agency. Determinations on requests for reasonable accommodation will be made on a case-by-case basis.

Outreach and Recruitment for Qualified Applicants with Disabilities: The Department encourages qualified applicants with disabilities, including individuals with targeted/severe disabilities to apply in response to posted vacancy announcements. Qualified applicants with targeted/severe disabilities may be eligible for direct hire, non-competitive appointment under Schedule A (5 C.F.R. § 213.3102(u)) hiring authority. Individuals with targeted/severe disabilities are encouraged to register for the Office of Personnel Management (OPM) Shared List of People with Disabilities (the Bender Disability Employment Registry) by submitting their resume to resume@benderconsult.com

Email links icon

and referencing "Federal Career Opportunities" in the subject line. Additional information about the Bender Registry is available at www.benderconsult.com [external link]. Individuals with disabilities may also contact one of the Department’s Disability Points of Contact (DPOC). See list of DPOCs.

 

Suitability and Citizenship: It is the policy of the Department to achieve a drug-free workplace and persons selected for employment will be required to pass a drug test which screens for illegal drug use prior to final appointment. Employment is also contingent upon the completion and satisfactory adjudication of a background investigation. Only U.S. citizens are eligible for employment with the Executive Office for Immigration Review and the United States Attorneys' Offices. Unless otherwise indicated in a particular job advertisement, non-U.S. Citizens may apply for employment with other organizations, but should be advised that appointments of non-U.S. Citizens are extremely rare; such appointments would be possible only if necessary to accomplish the Department's mission and would be subject to strict security requirements. Applicants who hold dual citizenship in the U.S. and another country will be considered on a case-by-case basis.

Veterans: There is no formal rating system for applying veterans' preference to attorney appointments in the excepted service; however, the Department of Justice considers veterans' preference eligibility as a positive factor in attorney hiring. Applicants eligible for veterans' preference must include that information in their cover letter or resume and attach supporting documentation (e.g., the DD 214, Certificate of Release or Discharge from Active Duty and other supporting documentation) to their submissions. Although the "point" system is not used, per se, applicants eligible to claim 10-point preference must submit Standard Form (SF) 15, Application for 10-Point Veteran Preference, and submit the supporting documentation required for the specific type of preference claimed (visit the OPM website, www.opm.gov/forms/pdf_fill/SF15.pdf for a copy of SF 15, which lists the types of 10-point preferences and the required supporting document(s). Applicants should note that SF 15 requires supporting documentation associated with service- connected disabilities or receipt of non-service connected disability pensions to be dated 1991 or later except in the case of service members submitting official statements or retirement orders from a branch of the Armed Forces showing that his or her retirement was due to a permanent service-connected disability or that he/she was transferred to the permanent disability retired list (the statement or retirement orders must indicate that the disability is 10% or more).

 

* * *

 

 

This and other vacancy announcements can be found under Attorney Vacancies and Volunteer Legal Internships. The Department of Justice cannot control further dissemination and/or posting of information contained in this vacancy announcement. Such posting and/or dissemination is not an endorsement by the Department of the organization or group disseminating and/or posting the information.

Updated February 7, 2022