CrawlJobs Logo

Financial Data Analyst - Tariffs

United States, Lincolnshire Employment contract · Job Posted May 15, 2026
Apply Position
Job Link Share

Job Description

We are looking for a financially minded data analyst to support tariff-related reporting and recovery efforts for a manufacturing organization in Lincolnshire, Illinois. This role focuses on organizing complex information from multiple sources, identifying what has been collected and what may be recoverable, and translating findings into clear business insight. The analyst will work closely with operations and commercial stakeholders to evaluate customer-level activity, reconcile payments, and build practical reporting tools that improve decision-making.

Job Responsibility

  • Analyze tariff-related financial data across multiple source systems to determine amounts collected, refunded, and potentially recoverable
  • Partner with operations and other cross-functional teams to gather business context, validate data accuracy, and support day-to-day analysis needs
  • Consolidate and connect several datasets into structured reporting that highlights customer-level activity, partial payments, and tariff application outcomes
  • Develop and maintain Excel-based analysis using advanced formulas such as VLOOKUP and HLOOKUP to reconcile large volumes of transactional information
  • Prepare Power BI reporting and data models to transform raw information into useful dashboards and actionable summaries
  • Review parts and whole-goods or generator transactions to identify differences in tariff treatment and ensure financial impact is properly tracked
  • Investigate historical customer payments to determine what has already been reimbursed and what additional amounts may still be owed
  • Perform hands-on ad hoc analysis to resolve complex questions, support business decisions, and provide timely updates to stakeholders

Requirements

  • Demonstrated experience in financial analysis, data analysis, or a similar analytical role within a business environment
  • Strong working knowledge of tariff-related analysis, including exposure to harmonized tariff concepts or comparable trade classifications
  • Advanced Microsoft Excel skills, including complex formulas, lookups, and the ability to manage large datasets efficiently
  • Experience combining data from multiple systems and creating clear, accurate reporting for business users
  • Familiarity with Power BI for data manipulation, reporting, and visualization
  • SAP experience is preferred but not required
  • Ability to investigate incomplete or inconsistent information and independently drive analysis forward with minimal oversight
  • Strong communication skills and a collaborative approach to working with operations and cross-functional teams
  • Availability to engage with the team in Lincolnshire, Illinois as needed during the 4-6 month assignment

Nice to have

SAP experience

What we offer

  • medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan
  • free online training

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Financial Data Analyst - Tariffs

8 matching positions

Financial Analyst

We are looking for a Financial Analyst to support crude oil settlement activitie...
Location
Location
United States , Houston
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Finance, Accounting, Economics, Energy Management, or a related discipline
  • At least 5 years of experience in crude oil settlements, trading operations, energy accounting, or a closely related area
  • Working knowledge of physical crude oil markets, logistics flows, and common industry pricing benchmarks
  • Experience interpreting transportation terms, terminal charges, tariffs, and measurement-related documentation
  • Advanced Microsoft Excel skills, including data analysis, pivot tables, and complex spreadsheet functions
  • Strong analytical and reconciliation abilities with a high level of accuracy and attention to detail
  • Ability to prioritize multiple deadlines and work effectively in a fast-paced, cross-functional environment
  • Clear communication skills and a proactive approach to problem-solving and process improvement
Job Responsibility
Job Responsibility
  • Oversee the full settlement cycle for physical crude oil transactions across transportation and storage channels, ensuring timely and accurate processing
  • Examine contract terms and commercial agreements to determine the correct application of pricing structures, fees, quality adjustments, and transportation charges
  • Verify transaction details by analyzing volumes, market pricing inputs, tariff schedules, and related financial calculations
  • Investigate and resolve variances by reconciling internal records with counterparty documentation and external statements
  • Prepare billing and settlement documentation, track outstanding balances, and coordinate follow-up on payment issues or disputed items
  • Partner with trading, scheduling, risk, and accounting teams to confirm complete transaction capture and reliable financial reporting
  • Contribute to month-end activities by supporting accrual preparation, account analysis, and settlement-related reporting requirements
  • Strengthen operational controls by documenting procedures, improving workflows, and assisting with process automation or system enhancement efforts
  • Provide day-to-day guidance to less experienced team members and promote consistent settlement practices across the group
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan
Read More
Arrow Right

Senior Financial Analyst

Jana Chapman with Robert Half is looking for an experienced Senior Financial Ana...
Location
Location
United States , North Plains
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • A minimum of 5 years of experience in financial planning and analysis (FP&A)
  • Proven ability to work collaboratively with executives and act as a proactive business partner
  • Exceptional communication and presentation skills, with the ability to convey complex ideas clearly
  • Experience in a distribution or similar industry that deals with physical products
  • Proficiency in financial modeling, variance analysis, and ad hoc financial analysis
  • Advanced skills in Microsoft Power BI and Microsoft Excel for data analysis
  • Strong background in logistics and distribution systems
  • Ability to analyze large datasets using data mining techniques to uncover actionable insights
Job Responsibility
Job Responsibility
  • Conduct in-depth financial analyses to support business decisions and improve profitability
  • Collaborate with executives to develop accurate budgets and forecasts that align with organizational goals
  • Evaluate customer profitability and pricing strategies to optimize revenue
  • Analyze the impact of tariff policies on product pricing and provide actionable recommendations
  • Prepare and deliver detailed financial reports and presentations to stakeholders
  • Perform ad hoc analyses to address emerging business needs and support strategic planning
  • Utilize advanced tools such as Microsoft Power BI and Excel for data modeling and visualization
  • Partner with distribution teams to assess financial performance within logistics and global distribution systems
  • Identify trends and opportunities by applying data mining techniques to financial datasets
  • Ensure compliance with financial regulations and company policies in all analyses
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • company 401(k) plan
Read More
Arrow Right
New

Inventory Accounting Analyst

The Inventory Accounting Analyst supports the integrity of the company’s invento...
Location
Location
United States , Secaucus
Salary
Salary:
63375.00 - 88000.00 USD / Year
sanmina.com Logo
Sanmina
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Accounting from an Accredited University
  • 2+ years experience
  • experience with Standard Cost Accounting
  • proficiency in: SAP and other systems
  • good communication skills
  • capable of working on their own
  • great attention to detail
Job Responsibility
Job Responsibility
  • Support the accounting, reporting, and analysis related to inventories, gross margins, and standard costs
  • Prepare monthly journal entries for inventory movements, accruals for inventory in transit, and the capitalization of freight and tariffs
  • Assist with the monthly financial close by performing preliminary inventory valuations and identifying potential reserves for slow-moving or obsolete stock under US GAAP
  • Review gross margin data and help investigate variances between budgeted and actual margins for management review
  • Prepare monthly reconciliations for inventory-related accounts across global operating territories to ensure balance sheet accuracy
  • Track and report on cost drivers that cause variances between standard and actual costs
  • Coordinate with Product and Sales teams to provide data necessary for maintaining accurate standard product costs
  • Generate and distribute reports that provide visibility into cost components like product, duty, and freight
  • Help document the Company's current end-to-end inventory processes and workflows
  • Support physical inventory counts and monthly cycle count programs by reviewing results and flagging variances for further investigation
What we offer
What we offer
  • bonus
  • paid time off
  • generous 401k match
  • tuition reimbursement
  • wellbeing resources
  • Performance-based annual bonus eligibility
  • 401(k) retirement savings plan
  • Comprehensive medical, dental, and vision coverage
  • Mental health resources and employee wellness support programs
  • Company-paid life and disability insurance
  • Fulltime
Read More
Arrow Right

Associate Analyst, Rates And Regulatory, Transmission

Under direct supervision, Associate Analyst, Transmission Rates and Regulatory i...
Location
Location
United States , East Berlin
Salary
Salary:
67730.00 - 75260.00 USD / Year
eversource.com Logo
EVERSOURCE
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Basic accounting theory, functional practices and procedures and financial reporting
  • Good problem-solving skills and ability to analyze data
  • Strong written and verbal communication skills
  • Strong Customer service orientation
  • Demonstrated skills with MS Office
  • Ability to be flexible and adapt to new situations
  • Possesses a high degree of personal ownership and accountability
  • Bachelor's degree in Accounting, Finance, Economics or closely related discipline required
  • Working towards a CPA, MBA preferred
  • Zero to three years of experience
Job Responsibility
Job Responsibility
  • Assists with the preparation of transmission revenue requirement calculations in support of transmission tariff filings
  • Prepares reports detailing transmission transactions and rates to various regulatory agencies such as FERC and PUC
  • Coordinates data request responses for the annual formula rate protocols
  • Contributes to departmental industry research, including formula rate protocols, in support of annual protocol process
  • Calculates transmission service revenues for the annual budget and five-year financial forecast
  • Executes activities and/or objectives in an accurate, timely manner and ensures a positive impact on colleagues and customers
  • Contributes to a positive, professional, cooperative and efficient work atmosphere and openly communicates work information to others in a timely manner
  • Delivers superior customer service
  • Keeps manager informed of issues, impediments, and progress
  • Participates in the resolution of customer crisis/urgent problems as situations arise
What we offer
What we offer
  • competitive total rewards program
  • potential incentive
  • Fulltime
Read More
Arrow Right

Cost and Pricing Analyst

We are looking for an experienced Cost and Pricing Analyst to join our team in G...
Location
Location
United States , Gardena
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proven experience in financial analysis, including cost modeling and pricing strategy development
  • Proficiency in financial modeling techniques and tools
  • Ability to perform variance analysis and ad hoc financial evaluations
  • Skilled in using data mining techniques to extract and analyze relevant information
  • Strong understanding of tariffs, import regulations, and their impact on costs
  • Excellent communication and collaboration skills to work effectively with sales and leadership teams
  • Detail-oriented with strong organizational skills to maintain accurate pricing databases
  • Bachelor’s degree in Finance, Economics, or a related field preferred
Job Responsibility
Job Responsibility
  • Analyze and calculate landed costs by incorporating freight, duties, minimum order quantities, and packaging expenses
  • Compare factory pricing across multiple suppliers to identify cost-effective options and evaluate production shifts based on tariffs and logistics
  • Develop pricing structures for both domestic and international distributors, ensuring margin consistency and distributor profitability
  • Create pricing models for direct-to-hotel programs, including bulk dispenser initiatives, liquid amenities, and custom projects
  • Monitor and assess tariff changes, advising leadership on sourcing adjustments due to geopolitical developments
  • Establish pricing strategies for miscellaneous and special projects such as custom packaging, airline kits, and promotional items
  • Collaborate with sales teams to structure competitive pricing strategies for large-volume deals and promotional campaigns
  • Maintain and update pricing databases to ensure accuracy and alignment with organizational goals
  • Support private label pricing structures and custom pricing calculations for unique client needs
  • Design promotional pricing campaigns, including volume-based discounts and distributor incentives
What we offer
What we offer
  • medical, vision, dental, and life and disability insurance
  • eligible to enroll in our company 401(k) plan
Read More
Arrow Right

Sr. Analyst, ERM Scenario Design & Stress Testing

The Scenario Design and Stress Testing (“SDST”) Function within Enterprise Risk ...
Location
Location
United States , St Petersburg, Florida
Salary
Salary:
Not provided
raymondjames.com Logo
Raymond James
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s Degree
  • Three (3) or more years of experience in a related field or an equivalent combination of education, certification, or training
  • Bachelor’s Degree (B.A.) in Finance, Accounting, Mathematics, or Engineering
  • Knowledge of MS office Suite - Fluency with MS Office Suite is required, including some experience with VBA
  • Mathematical concepts including Statistics - Working knowledge of statistics, including basics of concepts such as Data Distribution, Regression Analysis, and other techniques
  • Financial Markets – Interest in markets (for example, stocks, interest rates, bonds) and keeping up to date with the economic trends
  • Programming – Interest in and familiarity with programming in any language (for example, Excel/VBA). The job will not require heavy programming, but knowledge can help
  • Skill in Financial data analysis and statistical modeling
  • Databases and querying tools
  • Programming as a tool to automate
Job Responsibility
Job Responsibility
  • Collaborate extensively across multiple business and risk areas to develop stress scenario narratives and variable shocks with a focus on material risks within each area
  • Help develop both, firmwide as well as business/risk level stress scenarios
  • Conducts continuous monitoring of key metrics and financial indicators to provide meaningful insights and opinions on risk. Helps to identify emerging trends and create potential topical scenario narratives for events like COVID, Elections, Tariffs etc.
  • Facilitate and ensure a cohesive approach to SDST, including consistency, rigor, and timeliness
  • Support the development and maintenance of SDST Standards and Tools/Technology
  • Build and maintain effective working relationships with stakeholders and internal assurance groups, demonstrating a culture of engagement and assistance
  • Use excellent communication skills to influence a wide range of internal audiences including respective product, function, and business partners
  • Support the preparation of materials ahead of meetings with regulators, auditors, and senior leaders
  • Represent the SDST Function in stakeholder meetings, as needed
  • Perform other duties and responsibilities, as assigned
  • Fulltime
Read More
Arrow Right

Energy Analyst

Meta designs, builds and operates the most innovative and efficient data centers...
Location
Location
United States , Reston, VA +3 locations
Salary
Salary:
132000.00 - 188000.00 USD / Year
meta.com Logo
Meta
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in a relevant technical field, finance or business discipline, or equivalent practical experience
  • 5+ years of relevant work experience in the energy industry, with a focus on analyzing rates and tariffs, market information, and load profiles to drive business decisions. This experience should preferably be with electric utilities, large energy consumers, energy service providers, or consultancies
  • Experience of applying quantitative methodologies to analyze the energy market risks and opportunities
  • Experience analyzing and interpreting energy usage data, electric tariffs, wholesale energy market data, and renewable energy data
  • Experience collaborating with data engineers and data scientists and building productive cross-functional relationships
  • Experience working with Finance and Accounting teams
  • Experience to manage multiple work streams concurrently and prioritize workflows
  • Proven communication and presentation skills, with the ability to explain complex energy terms and concepts to a variety of audiences
Job Responsibility
Job Responsibility
  • Work with Commercial Energy Managers to analyze possible rate structures for new data center locations
  • Serve as an expert on energy rates and usage for Meta’s growing portfolio of data centers
  • Create and maintain models to forecast energy usage and analyze electric rate impacts for future data center sites
  • Conduct comprehensive cost and load analytics to support site selection efforts and new energy agreements
  • Work with Clean and Renewable Energy Managers to understand financial impact of projects
  • Build scalable analytical tools to streamline and simplify analytical tasks
  • Partner with Finance to support deal evaluations and approvals
  • Engage with Infrastructure stakeholders to track data center design and capacity engineering trends to improve load forecasting methodologies
What we offer
What we offer
  • bonus
  • equity
  • benefits
Read More
Arrow Right

Inventory Management Analyst

The Inventory Management Analyst role is responsible for conducting financial an...
Location
Location
United States , Secaucus
Salary
Salary:
66375.00 - 97350.00 USD / Year
sanmina.com Logo
Sanmina
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in mathematics, Statistics, Data Science, Finance or related fields and 0+ years of experience in financial analysis and data visualization
  • Experience in Manufacturing industry preferred
  • Advanced PC skills and proficient in Microsoft Office, particularly Excel
  • Proficiency in data analysis tools and languages such as SQL, Python and Tableau
  • Independent problem solver with ability to decode large quantity of complex data into easy-to-understand findings, observations, and actional items
  • Detail oriented and committed to deadlines
  • Excellent communication, written, and presentation skills
  • Ability to identify opportunities for performance& procedure improvement across the organization
  • Highly analytical with the ability to handle complex problems and build models
  • Hands-on experience with SAP and Jira preferred
Job Responsibility
Job Responsibility
  • Collect, organize, and analyse inventory data from various sources to create a weekly/monthly report for powerful and meaningful business and operational analysis
  • Perform weekly/monthly inventory account analysis for financial reporting purposes
  • Support month-end and year-end close processes
  • Analyse financial data, forecasting inventory needs and collaborate with other departments to manage inventory effectively
  • In charge of weekly and monthly inventory projection and share insightful analysis with management team
  • Perform financial and operational modelling for reports to customers, including inventory turnover analysis, freight, and tariff reconciliation
  • Analyse site transfer, RMA and RTV activities
  • Generate monthly RMA RTV reconciliation reports
  • Generate production activity report
  • Support ad-hoc business and financial analysis requests from other departments
What we offer
What we offer
  • Performance-based annual bonus eligibility
  • 401(k) retirement savings plan
  • Tuition reimbursement for eligible education programs
  • Comprehensive medical, dental, and vision coverage with access to leading providers
  • Mental health resources and employee wellness support programs
  • Company-paid life and disability insurance
  • Paid time off (PTO) and company-paid holidays
  • Parental leave and family care support programs
  • Structured training programs and on-the-job learning opportunities
  • Matching gifts and volunteer programs to support causes you care about
  • Fulltime
Read More
Arrow Right