Advanced Excel: Pivot Tables, VLOOKUPs, SUMIF
Bachelor's degree in Accounting, Finance, or Business Admin
3+ years of relevant work experience (Sales Tax, Analysis or Income Tax)
Consumer Goods Industry Experience
The Tax Data Analyst will serve as a hybrid and support Sales and Use tax filings and Income Tax.
The candidate will be responsible for working with loose data sets and preparing summaries. They will prepare analysis using Excel for sales, property and payroll percentage by state for accurate tax filings. Macmillan files sales tax in 43 states and outsource the function to a 3rd party. Sales Tax is filed on the 20th of each month.
The candidate will work closely with Tax Director, Jeff Peeler on Income Tax Provision from January to mid-March and Income Tax Compliance from April 1st to October 15th.
Other duties include working on the annual filings. The candidate will work with business licenses, gross receipts, 1099's and 1042's.
Other ad-hoc analysis will be required during the audit. Examples include compiling and preparing a summary of sales tax for the past 48 months or the last 100 invoices.
About Aston Carter:
Aston Carter is a distinguished global provider of recruitment and staffing services to companies requiring highly specialized business professionals. As a Best of Staffing® Client and Talent leader, Aston Carter has an unrivaled commitment to delivering first class service to clients and business professionals across a variety of disciplines, including Accounting and Finance as well as Governance, Risk and Compliance. With more than 60 offices across Europe, Asia Pacific and North America, Aston Carter provides local, regional and global expertise to drive value and meet our customers' unique needs. Aston Carter is a division of Aerotek. Aerotek is an operating company of Allegis Group, a global talent solutions provider.