International Trade Data Analyst (Federal Agency)

Aalis Management Consulting, LLC; Washington (District of Columbia); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Aalis Management Consulting is seeking an International Trade Data Analyst to support a federal agency's international trade and economic policy initiatives. The candidate will collect, clean, organize, and analyze trade data and use Excel to identify trends and develop reports for government stakeholders.

The role requires a detail-oriented professional who can translate statistics into actionable findings for research, policy analysis, and decision-making.

Qualifications

• Bachelor's degree in Economics, International Trade, International Affairs, International Relations, Business, or a related field.
• Early- to mid-career professional experience in trade research, economic analysis, or international affairs.
• Hands-on experience with international trade data collection, cleaning, organizing, and analysis.
• Strong Microsoft Excel proficiency, including formulas, sorting, filtering, pivot tables, and data analysis.
• Understanding of international trade concepts, import/export activity, and economic trends.
• Ability to interpret quantitative information and communicate findings clearly.
• Strong research, analytical, technical writing, and organizational skills.
• Ability to complete a practical trade-data and Excel skills assessment.

Responsibilities

• Collect, organize, validate, and analyze international trade data from government and other reliable sources.
• Use Microsoft Excel to manipulate datasets, identify trends, perform calculations, and develop reports.
• Research international trade issues, economic developments, market conditions, and trade policy.
• Analyze import/export statistics, trade flows, industry trends, and country-specific trade developments.
• Prepare concise analytical summaries, spreadsheets, briefing materials, and reports for government stakeholders.
• Support trade-related research involving international markets, economic relationships, and global supply chains.
• Identify data discrepancies, verify source information, and ensure accuracy of analytical findings.
• Collaborate with government analysts and subject matter experts on ongoing trade and economic policy initiatives.

Education

Bachelor's degree in Economics, International Trade, International Affairs, International Relations, Business, or a related field

Tools

Microsoft Excel

Job description

Aalis Management Consulting is an 8(a) certified Service-Disabled Veteran-Owned Small Business (SDVOSB) and Economically Disadvantaged Woman-Owned Small Business (EDWOSB) driven by the same principles that guide our armed forces. Founded by a US Army veteran, we take pride in our core values: excellence in reputation, commitment, candor, teamwork, and dependability. Our team delivers stakeholder-focused support in the areas of Acquisition & Procurement Support, (IT) Financial Management, Program Management, and Logistics & Supply Chain Support. Visit us at www.aalismc.com

Title: International Trade Data Analyst

Client: Federal Agency

Ability to Work: Washington, D.C. (Onsite 3 days a week)

Clearance: Public Trust

Security Clearance Statement: This position requires a government security clearance; the applicant must be a U.S. citizen to be considered.

Number of Position(s): 1

Work Schedule: 8 am – 5 pm

Work Day: Monday – Friday

Position Summary

Aalis Management Consulting is seeking an International Trade Data Analyst to support a federal agency's international trade and economic policy initiatives. The ideal candidate will have experience in international trade, economics, or international affairs, with strong Excel skills and hands-on experience collecting, organizing, analyzing, and interpreting trade data.

This position requires a detail-oriented professional who can translate trade statistics into clear, actionable findings to support research, policy analysis, and federal decision-making.

Key Responsibilities

• Collect, organize, validate, and analyze international trade data from government and other reliable sources.
• Use Microsoft Excel to manipulate datasets, identify trends, perform calculations, and develop reports.
• Research international trade issues, economic developments, market conditions, and trade policy.
• Analyze import/export statistics, trade flows, industry trends, and country-specific trade developments.
• Prepare concise analytical summaries, spreadsheets, briefing materials, and reports for government stakeholders.
• Support trade-related research involving international markets, economic relationships, and global supply chains.
• Identify data discrepancies, verify source information, and ensure accuracy of analytical findings.
• Collaborate with government analysts and subject matter experts on ongoing trade and economic policy initiatives.

Required Qualifications

• Bachelor's degree in Economics, International Trade, International Affairs, International Relations, Business, or a related field.
• Early- to mid-career professional experience in trade research, economic analysis, international affairs, or a related analytical field.
• Hands-on experience working directly with international trade data, including collecting, cleaning, organizing, and analyzing datasets.
• Strong Microsoft Excel proficiency, including formulas, sorting, filtering, pivot tables, and data analysis.
• Understanding of international trade concepts, import/export activity, and economic trends.
• Ability to interpret quantitative information and communicate findings clearly.
• Strong research, analytical, technical writing, and organizational skills.
• Ability to complete a practical trade-data and Microsoft Excel skills assessment.

Preferred Qualifications

• Experience supporting federal agencies, international trade organizations, or economic policy initiatives.
• Familiarity with trade data sources such as the U.S. Census Bureau, USITC DataWeb, UN Comtrade, or similar resources.
• Experience analyzing trade relationships involving China or other major U.S. trading partners.
• Knowledge of Harmonized System (HS) codes, tariff classifications, and trade statistics.
• Experience preparing trade-related reports, policy briefs, or analytical presentations.

Skills Assessment

Qualified candidates will complete a brief, practical assessment designed to evaluate their ability to work independently with international trade data using Microsoft Excel. The assessment will focus on data manipulation, basic calculations, interpretation of trade statistics, and communicating analytical findings.

Aalis Management Consulting is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.