International Trade Analyst

Thompson Coburn LLP; Washington (District of Columbia); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

Medical Insurance

Vision Insurance

Dental Insurance

Paid Holidays

Paid Vacation Time

Tuition Reimbursement

College Savings Plan Deductions (529)

Job summary

Thompson Coburn LLP, a large full-service law firm, seeks an International Trade Analyst in Washington, DC. You will analyze data, support attorneys in the International Trade practice, and help clients understand trade data, compliance, and reporting.

After in-office training, the role offers a hybrid-remote schedule. The ideal candidate has advanced Excel and Power BI skills, experience with large datasets, and a strong interest in international trade and sanctions/export control compliance.

Qualifications

• Bachelor's degree required in a related field (Business, International Trade, Economics, etc.).
• Two or more years of experience in international trade compliance or financial services due diligence required.
• Expert-level proficiency in Microsoft Excel with advanced formulas, pivot tables, data visualization, and dashboards.
• Experience with Power BI or other BI/reporting tools is highly desirable.

Responsibilities

• Data analysis in Excel and Power BI; prepare reports from large data sets.
• Due diligence support and analysis using compliance databases for sanctions and PEP checks.
• Tariff classification and merchandise classification for import/export.

Skills

Advanced Excel

Power BI

Data analysis

Statistical reasoning

Large datasets

Education

Bachelor's degree

Customs Broker License (plus)

Tools

Microsoft Excel

Power BI

Job description

Thompson Coburn, a large full-service law firm with offices in eight (8) cities across the U.S., is in search of an International Trade Analyst to fill a full-time non-exempt position in its Washington, D.C. office. With over 450 attorneys and experience in 50 areas of law, Thompson Coburn is regularly recognized for providing clients with outstanding value and service. Driven by our core values of integrity, innovation and diversity, we collaborate and work in a welcoming, highly productive, and inclusive environment. If you are a creative professional looking to join a collaborative team, then this might be an exciting opportunity for you!
The International Trade Analyst provides analysis and other support services for attorneys in the International Trade practice group. The ideal candidate will have a strong interest in international trade and a demonstrated desire to work as a team with subject matter experts to help clients manage and understand trade data, navigate trade compliance issues, and solve legal and logistical problems. This is a position for an individual with the curiosity and desire to learn about international trade and the technical details associated with the importation of merchandise and compliance with sanctions and export control regulations. The person selected for this position must have advanced data analysis experience and be capable of working in a high-demand and dynamic environment. After an initial period of in-office training, this position is eligible for a hybrid-remote work schedule.
The key Responsibilities

• Data analysis in Microsoft Excel and Power BI. Intakes, manipulates, analyzes, and visually represents large volumes of data and prepares reports in Microsoft Excel, Power BI, and various other proprietary analytics tools, including the calculation of distinct measures requiring the incorporation of data from different and disparate sources.
• Due diligence support and analysis. Retrieves, analyzes, and summarizes publicly available information and proprietary screening reports from compliance databases to identify politically exposed persons (PEP), sanctioned ownership, and prohibited country connections related to U.S., UK, and EU economic sanctions and export control programs.
• Tariff classification. Identifies merchandise classification for import and export, including a scientific level of detail about the material composition and function of various goods.
• Attorney support. Assists attorneys as part of a collaborative team with various types of compliance audits and reviews, preparation of government filings, reports to clients, and initial preparation of international trade process-flow descriptions and compliance manuals.
• Documentation and recordkeeping support.Maintains and organizes documentation associated with investigations, penalty actions, filings and disclosures.
• Administrative and Judicial Filings. Prepares and submits filings at the Court of International Trade and Administrative agencies, as well as filings to those on the service list for those proceedings.
• Timekeeping and billing support.Accurately records, maintains, and submits billable and non-billable time entries in accordance with firm policies, ensuring time is entered contemporaneously and supporting billing deadlines.
  

Knowledge, Skills And Abilities Required

• Demonstrated ability to analyze, interpret, and present complex data using a statistical and analytical mindset.
• Advanced proficiency in Microsoft Excel, including advanced formulas, pivot tables, data validation, conditional formatting, dashboard creation, and large dataset management is required.
• Ability to think critically and solve complex problems through data analysis, statistical reasoning, pattern recognition, and logical decision-making. Must be comfortable working with large datasets and identifying trends, anomalies, and actionable insights.
• Demonstrated knowledge of, or a willingness to learn, merchandise classification for import and export.
• Exceptional attention to detail with the ability to organize, analyze, and interpret complex information while managing multiple concurrent projects.
• Demonstrated intellectual curiosity and the ability to learn complex technical subject matter quickly. Must be comfortable working with scientific, engineering, regulatory, or other highly technical concepts in support of the firm's International Trade practice.
• Ability to process routine daily functions while being able to resolve sensitive issues and complex assignments utilizing above average critical thinking skills.

Education And Experience Qualifications

• Bachelor's degree required, preferably in Business, International Trade, Mathematics, Statistics, Computer Science, Data Analytics, Economics, or another analytical or science-related discipline.
• Customs Broker License a plus but not required.
• Two or more years of experience in international trade compliance and/or financial services due diligence required.
• Demonstrated experience working with complex datasets, database management, advanced spreadsheet analysis, reporting, or business intelligence tools is strongly preferred.
• Expert-level proficiency in Microsoft Excel is required, including experience with advanced formulas, pivot tables, conditional formatting, data visualization, dashboards, and analyzing large or complex datasets. Experience with Power BI or other business intelligence/reporting tools is highly desirable.

Compensation
For applicants that meet the experience requirements for the role and are physically based in Washington D.C., the expected salary range is $70,000 – $100,000 annually upon commencement of employment. Starting salary will be determined on an individualized basis with consideration to prior experience and additional qualifications. This is in addition to a comprehensive benefit package offered by the Firm.
Thompson Coburn LLP is a large, full service, multi-state firm with offices in Birmingham, Chicago, Dallas, Los Angeles, New York, St. Louis, Southern Illinois, and Washington D.C. At Thompson Coburn, our behavior and the expectations we have of ourselves are guided by the values that we hold in the highest regard: integrity, a passion for excellence, a focus on serving the client, a value of diversity, innovation, creativity, trust, and loyalty. Within the Firm, we value each other as people and colleagues. In addition to the exceptional working environment and a competitive salary, Thompson Coburn provides the following benefit options to qualifying employees:
We value the text that follows as a list of benefits and are keeping them verbatim below:

• Medical Insurance
• Vision Insurance
• Dental Insurance
• Life Insurance & ADD policies
• Short & Long Term Disability Insurance
• Paid Parental Leave
• 401(k) Profit Sharing plans
• Parking/Transportation Stipend
• Section 125 Plan (Pre-tax premiums and medical reimbursement)
• Paid Holidays
• Paid Vacation Time
• Employee Assistance Program (EAP)
• Employee Wellness Program
• Tuition Reimbursement
• College Savings Plan Deductions (529 Plans)
• Long Term Care

Equal Opportunity Employer M/F/D/V