Title: Senior Analyst II, Transaction Tax Information Systems and Technology
Location: Illinois-Chicago
Responsible for assistance with the development, management, maintenance and testing of the sales and use tax reporting functionality of U.S. Cellular, its subsidiaries and partnerships. This position will be required to understand, document, test, and validate all systems and technology applications in use by the Tax Department.
This position must develop expertise in the CARES billing system functionality, SAP platform and must establish deep technical knowledge Vertex CommTax functionality.
1. Document and understand U.S. Cellular sales tax systems and functionality of each with respect to their integration with the revenue and purchase reporting process for transaction tax purposes.
2. Establish and maintain an inventory of all system interfaces that the Tax Department uses including specialty programs, queries and macros. This includes diagrams and documentation.
3. Establish and monitor user access to each system and/or query.
4. Test and validate on a sample basis SAP general ledger report, query data, and other data gathered for use in the compliance processes to check for completeness.
5. Review and test SAP variants in use including assistance with SOX queries.
6. Work within CARES Billing System environment to:
Test and validate CARES product feature code mapping to Vertex CommTax decisions including mapping of feature codes to the general ledger revenue accounts.
Team with Revenue Assurance to identify, discuss, document and resolve CARES billing matters with respect to sales tax
Perform quarterly testing of product feature codes to validate tax outcome is as expected including documentation of sampling methodology and test results.
Perform real time testing of new product feature codes prior to production to validate tax outcome is as expected including documentation of sampling methodology and test result.
7. Ability to query, assemble and manage large amounts of data including data for use in audits.
8. Ability to communicate effectively with U.S. Cellular's IT, SAP and CARES Billing teams to explain system issues and achieve timely results.
9. Team with the Tax Compliance Manager to develop, improve, streamline and enhance system reports used to facilitate the compliance process.
10. Collaborate with the Tax Department and other U.S. Cellular Departments to share results, develop efficiencies and standardization.
11. Become a SAP and TOPS Superuser.
12. Maintain Tax Department calendar for SOX reporting and testing, assist users with timely completion of Sarbanes-Oxley (SOX) requests, and participate in SOX testing as required.
13. Maintain integrity of data stored on Tax Department network drives in including organization and archiving of files.
(Note: Many of these key roles and responsibilities are carried out in coordination with Telephone and Data Systems, Inc. ("TDS") corporate personnel. Although USCC is a separately-reporting public company, its accounting policies and practices must be consistent with those of TDS, its parent company.)
The statements herein are intended to describe the general nature and level of work being performed by associates and are not to be construed as an exhaustive list of responsibilities, duties, abilities, and skills required of associates so classified. Additional responsibilities may be assigned as needed.
Necessary Education and Work Experience:
Bachelor's degree in Accounting or Information Systems, CPA a plus.
Experience with tax software systems is a plus, particularly telecommunications billing system taxation, property tax compliance software and Vertex's CommTax.
Required Knowledge and Skills:
Excellent interpersonal and communication skills - ability to establish and maintain professional productive relationships.
Excellent data management skills including data mining capability, proficiency in Microsoft products and SAP.
Ability to work independently to solve problems and the ability to document findings in a logical manner.
Ability to aggregate large amounts of data in an efficient manner.
