Summary: This full-time position is responsible for providing technical expertise, management of charge table and billing, data manipulation, support data analysis and report development for the Student Accounts unit of the Student Financial Services Department. This position reports to the Senior Director of Student Accounts.
This position is exempt from provisions of the Fair Labor Standards Act (FLSA) and is not eligible to earn overtime pay for hours worked above 40 in a single work week.
Essential Duties and Responsibilities include the following:
Design, develop and validate the data tables used for student account charges and ensure changes are backed up by the documentation required.
Create and maintain reports using Jenzabar data, providing for SFS institutional, state and federal and foundation needs.
Manage the 1098t and 1042S IRS tax documents and ensure uploads and information is done within the IRS guidelines. Produce the government data files, submit files to IRS and reporting partner.
Provide the interface and accurate timely data transfer between college vendors such as Chartwells, Wiley as well as departments within the university (Residence Life, Campus Police, Finance, et al).
Manage upgrades to the Jenzabar system and serve as the subject matter expert on the student account charges and produce timely and accurate statements to students.
Develop protocols and methods for gathering information from all departments involved in student charges and systems.
Update and develop online forms, report templates, group messaging and the addition of group notes as required to student accounts.
Work with IT to create new views and fields as necessary for reporting and optimize proper use of this data.
Chair the SFS Coordination Committee with representatives from all applicable university departments to ensure transparent communication and timelines are understood.
Assist the Senior Director of Student Accounts in the overall management of the student account AR and the servicing of student accounts by the unit.
Secondary Duties and Responsibilities:
Other duties and special projects may be assigned to meet department and university needs.
Experience, Knowledge and Skills Required
3-4 years of experience managing relational databases.
Proven customer service skills and enthusiasm for providing exceptional service to a diverse population of graduate and undergraduate students, their families, staff, faculty and other constituencies.
Excellent computer proficiency required with experience in ERP systems and data base support, strong proficiency in MS Office including Access and SharePoint.
Ability to quickly learn and apply new knowledge and skills.
Proven exceptional attention to detail and ability to consistently produce error free results.
Demonstrated organization and follow-up and follow-through skills to ensure completion of goals and objectives.
Proven success in working on a team and completing tasks independently.
Excellent written and verbal communication skills and track record of proactive communication and knowing when escalating issues.
Proven ability to identify, define, analyze, and resolve complex problems.
Exceptional follow-up and follow-through skills as well as ability to plan, organize and control projects through to completion.
Must be able to work in a fast-paced environment with demonstrated ability to effectively prioritize multiple competing tasks and demands.
Familiarity with Jenzabar a plus.
Ability to use absolute discretion when dealing with sensitive, confidential materials; familiarity with FERPA a plus.
Ability to remain calm and resourceful in stressful situations.
Bachelor’s degree in related field or equivalent combination of education and experience.
Physical Requirements (with or without reasonable accommodation)
Visual Abilities: Read reports, create presentations and use a computer system – 75?100% of the time
Hearing: Hear well enough to communicate with co?workers, vendors and students – 75?100% of the time.
Dexterity, Grasping, Feeling: Write, type and use the telephone, copier, and computer systems – 75?100% of the time.
Mobility: Kneel for physical inspection of storage areas; Open files and operate office machines; move between departments and attend meetings across campus – 75?100% of the time.
Talking: Frequently convey detailed or important instructions and ideas accurately, loudly, or quickly – 75?100% of the time.
Lifting, Pulling, Pushing: Exert up to 30 pounds for force occasionally, and/or up to 20 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects – 50?75% of the time.
Cognitive/Emotional: Ability to critically think and concentrate. Must be able to respond quickly to changes in conditions – 75?100% of the time.
Work in office environment, involving contact with faculty, staff, students, service providers and vendors.
Work has deadlines, multiple interruptions, high volume and may be stressful at times.
The above description is not intended to be an all-inclusive list of the duties and responsibilities of this positions, nor are they intended to be such a listing of the skills and abilities required to do the job. Rather, they are intended to describe the general nature of this position.
Nestled in a historic tree-filled neighborhood just minutes from Uptown Charlotte, Queens has provided students with transformational experiences for more than 160 years.
A private, co-ed, masters-level university, Queens serves undergrad and graduate students in academic programs across the liberal arts and sciences as well as the professional fields of business, communication, nursing, health and education. All degree programs are grounded in a liberal arts core to help students hone their critical thinking, problem solving and communication skills.
With a 10:1 student-faculty ratio, the university is known for its student-centered mentality, welcoming southern hospitality and talented and caring faculty. Queens fosters student success through an intimate learning environment and excellence in teaching.
In keeping with its Presbyterian heritage, responsibility and service to society are critical components of Queens' culture, as expressed in its motto "Not to be served, but to serve."
Queens emphasizes active, collaborative learning with a focus on a 21st century global curriculum that takes students beyond the classroom and into the Charlotte community and the world... at large. With the city of Charlotte as an extended campus, students have the opportunity to launch into abundant internships, community service and academic partnerships. Undergraduate students must complete at least two internships. In addition, the majority of Queens' undergraduates study internationally in hundreds of countries via faculty-led study tours, international internships, language-immersion programs and semester exchange opportunities.
By graduation, students have obtained a comprehensive education grounded in the liberal arts and filled with opportunities to ready them for successful careers and meaningful lives.