Trade Data Analyst

Job Title: Trade Data Analyst

Job Duties: Optimize the accuracy and consistency of trade-related data flows to support compliance and operational efficiency, working under general supervision (25%). Create functional dashboards and metrics in Tableau, Sigma, and SAP Analytics Cloud (25%). Manage and validate data integration within SQL Server, and the SAP Transportation Management and Global Trade systems to ensure seamless customs and logistics processes (20%). Perform detailed analysis of trade and transportation datasets from multiple sources to identify trends, discrepancies, and opportunities for process improvement (20%). Maintain and update trade databases, applying necessary data transformations to ensure alignment with regulatory requirements and business objectives (10%).

Job Requirements: Master’s degree in Computer Science, Information Technology, or a related field, or foreign degree equivalent and 3 years of data engineering experience. Alternatively, employer will accept a Bachelor’s degree in Computer Science, Information Technology, or a related field, or foreign degree equivalent and 5 years of progressive, post-baccalaureate data engineering experience. Experience must include at least 3 years of experience in each of the following:

1. Developing complex SQL Server stored procedures, views, and functions supporting ETL workflows and analytical reporting;
2. Applying query optimization techniques including indexing, joins, and execution plan tuning to ensure efficient aggregation and transformation of large datasets;
3. Building interactive business intelligence dashboards and analytical reports using Tableau, Sigma, and Worksite for executive and leadership stakeholders;
4. Engineering and analyzing supply chain, trade, customs, and tariff datasets supporting global logistics and compliance operations;
5. Building data pipelines using Alteryx and analytical models integrating data across systems including Azure Synapse, SAP HANA, AWS, SQL, and Snowflake to enable tariff mitigation analysis, customs reporting, and supplier performance monitoring;
6. Designing and automating logistics and compliance processes using MS Access Database, SQL, and Snowflake; and
7. Automating recurring logistics and tariff reports to eliminate manual reporting, improve audit readiness, and ensure consistent and timely insights for trade and logistics leadership. Experience may be gained concurrently.

Salary: $96,118-141,800/year. This position is also eligible for a holiday gift. Additionally, as a U.S. PACCAR employee, you will have a full range of benefit options including 401K with match, pension, 10 vacation days, 12 holidays, sick time, medical, dental, and vision plans, FSA, HSA, disability programs, and life and accidental death insurance.

Location: Position full-time, 40 hours per week, with PACCAR, Inc located in Bellevue, WA.

To apply, email Tiffany.Yango@paccar.com and you must reference job number job#BEL93026.