What are the responsibilities and job description for the Master Data Specialist position at Total Warranty Services?
The Master Data Specialist (MDS) is responsible for data management within our accounting system of record and contract management system. The primary responsibilities include setting up and maintaining payee profiles, customer profiles, banking information, GLs related thereto, etc. via data entry and imports. The MDS will interpret payee contracts and tax forms and act as a liaison between the Company’s operations and Finance departments. Further, the MDS is responsible for conducting audits of large sets of ERP data in Excel and must be able to use dynamic lookup formulas and pivot tables. The MDS will help maintain a strong control environment by enforcing the Company’s policies and procedures pertaining to data verification and data management.
Essential Duties & Responsibilities
- Liaise with Operations, AP, AR, Accountants, & Analysts to setup and maintain vendor/customer profiles, banking information, GL accounts, etc. in the contract management system and accounting system of record
- Uphold strong control environment within Master Data to mitigate exposure to fraud risk in the payment disbursement process and transfer of PII
- Reconcile data discrepancies between systems, routinely communicate findings, and update respective stakeholders
- Perform callbacks and/or online research to validate clients’ tax and banking information and obtain manager approval where applicable
- Interpret payees’ 1099 eligibility from W-9 tax forms and conduct audits on historical setups
- Perform self-audits to ensure all data entry is accurate
- Research and understand transactions in accounting system of record
- Provide assistance for projects, process improvements, and system upgrades
- Collaborate with other departments to develop or enhance processes, including standardized operating procedures
- Must be willing to aid other departments in times of need
- Display initiative, exercise sound judgment, and consistently follow-through with minimal direct oversight
- Ability to communicate information effectively to applicable stakeholders
- Other duties as assigned
- Bachelor’s Degree in Business, Accounting, Finance or related field
- 2 years of experience in business analysis or finance preferred
- Large ERP system experience
- Working knowledge of business management principles, including 1099 reporting responsibilities
- Excellent organizational skills and attention to detail
- Strong analytical and problem-solving skills
- Excellent verbal and written communication skills
- Must be able to manage multiple projects, tasks, and tight deadlines
- Advanced Microsoft Office (Excel, Word, PowerPoint, Outlook)
