Go to our website »

Jobs at Executive Office of the President - US Trade Representative

IT Consultant

Location: Washington, DC

Department: Administration

Type: Full Time

Min. Experience: Mid Level


This position is located in the Executive Office of the President (EOP), Office of the U.S Trade Representative (USTR). The position is temporary in nature and reports to Celestine Pressley, IT Director, and Fred Ames, AUSTR for OA. USTR is responsible for automating the 301 tariff exclusion process, including formulating recommendations to the President to approve or deny exclusions from the tariffs.

Statement of Work

The consultant will assist in designing, developing and implementing an application that captures the process for submittal, review, status, and final recommendations for the 301 tariff exclusions. The consultant sought is a Salesforce expert on Salesforce design and development. 

The following tasks are illustrative of the kinds of tasks the consultant will perform:

  • Creating an online form to capture the data requested by GC for the tariff exclusions process
  • Build the public vs BCI versions of the appropriate fields displayed on the screen for input
  • Confirmation screen
  • Auto-generation of confirmation code (randomized)
  • "Save and add another" functionality 
  • Field validation across all fields on the form
  • HTSUS lookup
  • Email notification on submission
  • Review and approve submissions to public-facing page
  • Allow comment and sub-comment with attachments
  • Display comment and sub-comment, possibly with collapse-and-expand functionality (default collapsed)
  • Email notification to submitter upon comment

Skills Desired

We are looking for a mid-level candidate (5-7 years of experience) with 2 or more of the skills listed below:

  • JavaScript
  • APEX
  • Visual Forest
  • Lightning Flows
  • Process Builder
  • Validation Rules
  • Developing Reports (Salesforce and Excel skills needed)- Must Have


Apply for this Position
* Required fields
First name*
Last name*
Email address*
Phone number*

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file