Skillset/Qualifications:<br>3+ years of Business Analyst experience<br>Experience with requirements gathering and backlog management<br>Familiarity with Jira or similar tools<br>Strong communication and stakeholder management skills<br>Experience working in Agile or hybrid delivery environments<br><br>Preferred:<br><br>Background in financial services<br>Experience with AML (Anti-Money Laundering) or financial crime initiatives<br>Exposure to transaction monitoring systems<br>Experience with financial crime or compliance-related platforms (nice to have)
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.<br><br>Responsibilities:<br>• Analyze tariff-related financial data across multiple source systems to determine amounts collected, refunded, and potentially recoverable.<br>• Partner with operations and other cross-functional teams to gather business context, validate data accuracy, and support day-to-day analysis needs.<br>• Consolidate and connect several datasets into structured reporting that highlights customer-level activity, partial payments, and tariff application outcomes.<br>• Develop and maintain Excel-based analysis using advanced formulas such as VLOOKUP and HLOOKUP to reconcile large volumes of transactional information.<br>• Prepare Power BI reporting and data models to transform raw information into useful dashboards and actionable summaries.<br>• Review parts and whole-goods or generator transactions to identify differences in tariff treatment and ensure financial impact is properly tracked.<br>• Investigate historical customer payments to determine what has already been reimbursed and what additional amounts may still be owed.<br>• Perform hands-on ad hoc analysis to resolve complex questions, support business decisions, and provide timely updates to stakeholders.