Job
Description
Role & responsibilities Will develop and support MS Access databases as assigned. These may comprise of programs developed by the department, or from outside sources. Translating data to other file formats to be imported into Microsoft Access. OBDC links to third party software, data validation and exception report development are typical of the tasks assigned. A developer will work with the end user of the program and create a button driven interface for beginner level Access users. Essential Responsibilities Process data using an Access database used for extracting third party system data files and audit purposes, reporting, or other processes for the company as requested. Supports the Shared Services Pay/Bill Solutions team and other corporate entities upon request. Assist with special projects as needed. Track project resource allocation and provide project timeline estimates. Ensure excellent customer service within a business environment that values accuracy, timeliness, efficiency, continuous success and growth for Volts employees, stakeholders, and customers, by engineering and supporting complex customized processes. Follow established policies and procedures to ensure all processing deadlines are met, inform the supervisor in a timely manner if any deadlines are at risk. Provide Customer Service both internally and externally, in an efficient and effective manner. Problem solve and resolve issues/concerns as they arise on a proactive basis with branch staff, corporate staff, customers, and in-house staff as needed. Notify the supervisor if issues cannot be resolved in a timely manner. Provide Shared Services (SS) management with feedback on ways to improve the work environment, procedures, and work performed. Perform all other duties as assigned and as required for the quality performance of the Shared Services team. Ability to maintain, update, and create documentation. May lead special projects and support implementation initiatives. Process third party data files from multiple customer systems in varying formats. Prepare weekly audit reports, work on process improvements and writing documentation. Prepare and distribute weekly/monthly Accounts Receivables reporting. Qualifications & Required Skills Any combination of education and experience providing the required skill and knowledge for successful performance would be qualifying. Typical qualifications would be equivalent to: 4 6 years of related experience Bachelor’s degree or higher preferred Spreadsheet software (Excel) and database software (Access, Advanced). Accounting background is desired. This may consist of Payroll, Billing, AR, and AP. CRM exposure is a plus. Hands on experience in MS Access – creating, maintaining, documenting & updating. Visual Basic (VB) coding experience is strongly preferred. Data management knowledge, skills, and an understanding of data normalization is desired. Ability to write and understand SQL preferred. Ability to maintain confidentiality of sensitive information. Ability to manage time effectively, demonstrate strong organizational skills, and manage multiple concurrent priorities. Effectively communicate in-person with internal staff, external customers, and field employees. Both verbally and written. Develop in a database, work independently with little supervision while coordinating the task with the end user. Self-starter and takes initiative. Deductive reasoning, problem solving, & research for data processing errors is required. Strong attention to detail. This position does require audit work. Understanding basic US labor law requirements, calculating overtime hours and rates, preferred. Microsoft Azure experience is a plus. Physical Demands and Environmental Factors Ability to work in an office environment. Flexibility and ability to work non-standard business hours and travel occasionally. The ability to sit, stand, bend, lift, and move intermittently during working hours. The preceding has been provided as examples of the types of work performed by employees assigned to this job classification. Management reserves the right to add, modify, change, or rescind the work assignments of different positions and to provide reasonable accommodation, if required, so that qualified employees can perform the foregoing essential functions of the job. I understand that my signature below indicates that I have read and understand this job description and have received a copy for my records.
