Vanderbilt University Benefits Data Analyst in Nashville, Tennessee
Benefits Data Analyst (Job Number: 1900763)
Vanderbilt University’s Human Resources Department is seeking a Benefit Data Analyst to serve as a Systems/Technology subject matter expert regarding employee benefit offerings (group health, dental, vision, short-term and long-term disability, life insurance, flexible spending accounts, 403(b), COBRA, PTO, etc.) Responsible for oversight of benefit files and reports in collaboration with HRIS and IT team members to ensure accuracy of benefit data and delivered benefits.
Our ideal candidate will have a passion for troubleshooting processes with an eye to continuous improvement. They will be familiar with Oracle (or a similar HMS), as well as have knowledge of file requirements in working with outside benefit administrators. A solid working knowledge of benefit plans and compliance and security requirements is necessary to success.
Duties and Responsibilities
Creates new or modifiesexisting files and reports and coordinates with HRIS and IT to confirm theaccuracy of additions and changes to benefit files and reporting
Oversees maintenance ofbenefits systems, by designing, testing, and auditing new plans in system
Maintains and updates systemconfiguration, troubleshoots benefits administration processes, and testscorrective action to ensure proper configuration
Develop test plans forinterface file changes and coordinates with outside vendors regarding anychanges and issues
Partners with HRIS and Payrollto provide data and system support within the HRIS system to validate theaccuracy and consistency of benefit information
Manages and enhances existingclaims data warehouse using SQL Server, which includes monitoring data feedupdates from vendors and internal systems
Reviews, analyzes, implements,and troubleshoots layout changes, new data files and tables, and new databasesetups and modifications
Develops and implements auditprocesses for analysis of data input. Audits include enrollment, eligibility,and plan reconciliations to ensure compliance with all benefit plans. Performsfull data audits to identify discrepancies and communicates clear direction onhow to resolve them for decision makers
Audits all benefit vendorinvoices, resolves discrepancies and submits to vendor for review
Analytics, Metrics & Reporting:
Assists in development,maintenance, and revision of a variety of reports using appropriate reporting.Provide claims, enrollment, deductions, plan participation data, and otheranalytics to Leadership on an ad hoc basis.
Conducts scheduled reportingon benefit plans including, but not limited to, cost, demographics, andutilization, to facilitate planning and decision-making in regards to benefit programs,plan design, and ensure compliance with state and federal regulations.
Collaborates in filing variouscompliance reports including, but not limited to Department of Labor 5500reporting, Summary Annual Reports (SAR), Affordable Care Act 1095 reporting,non-discrimination testing, etc.
Coordinates with vendors fordata collection and analysis related to plan audits and compliance filings
Develops and oversees ACA IRSreports and tools for monitoring the administration of health plan enrollmentsto ensure compliance
Participates in the review andupdate of Summary of Benefits and Coverage (SBC), Summary Plan Descriptions(SPD), as well as internal benefits communications materials
Researches and resolves HRISbenefit problems, recommends solutions to meet requirements
Participates in openenrollment planning and execution
Develops and maintainsprocedures, processes and workflow diagrams and identifies potential areas forimprovement
Participates in surveys byproviding data relative to benefits costs and design
Identify, recommend, andimplement, as directed, improvements to existing processes and procedures
Profile of an Ideal Candidate
A Bachelor’s degree from anaccredited institution of higher education is necessary.
At least three years ofexperience is necessary.
Experience working withdatabase programs (i.e. employee benefit tracking programs, payroll and/or HRISprograms), system coding, troubleshooting, and resolving system issues isnecessary.
Strong analytical andtechnical skills, including the ability to review and interpret data, makerecommendations and present fact-based information for decision-making isnecessary.
Advanced level proficiencywith MS Office Excel, Access and PowerPoint to include the ability to createpivot tables, write conditional formulae and create charts / graphs tosummarize data findings is necessary.
Strong attention to detail andthe ability to work with large amounts of data and identify even the smallestof discrepancies is necessary.
Experience in the use of HCMsystems, and specifically Oracle Cloud HCM system is preferred.
Aptitude to work infast-paced, multi-tasking environment and manage sensitive, confidential issuesis preferred.
A team player with ability tobuild strong relationships with the Benefits team, benefits vendors, other HRstaff and other business partners on and off campus is preferred.
Strong verbal and writtencommunication skills are preferred.
About Vanderbilt Benefits
In addition to offering a lively community that encourages learning and celebrates diversity, Vanderbilt University offers a competitive, flexible benefits package including health, dental, vision, life, accidental death & dismemberment, disability insurance, paid time off, and a 403(b) retirement plan with employer match. Vanderbilt offers tuition assistance to employees, spouses and dependent children. Also, after five years of service, Vanderbilt will pay up to 55% of the tuition for up to three dependent children to earn a bachelor's degree. Learn more about Vanderbilt's benefits at VU Benefits Overview at https://hr.vanderbilt.edu/benefits/6.1.17BenefitsOverview-Candidate-.pdf .
About Vanderbilt University
Vanderbilt is a renowned private institution founded in 1873 and located in the heart of Nashville, Tennessee. The university’s students and faculty frequently cite Nashville and the surrounding area as one of the many perks of being a part of the Vanderbilt community. Vanderbilt University is a place where your expertise will be valued, your knowledge expanded, and your abilities challenged. It is a place where your diversity is sought and celebrated. It is a place where employees know they are part of something bigger than themselves, take exceptional pride in their work and never settle for what was good enough yesterday. Vanderbilt was recently ranked #2 for “best quality of life” and “great financial aid,” #5 for “best run colleges” and “beautiful campus,” and #6 for both being in a “college city that students love” and having “great campus/city relations.”
Commitment to Equity, Diversity and Inclusion
Vanderbilt University is committed to achieving the goal of a diverse and inclusive academic community of faculty, staff, and students. We seek individuals who are committed to this goal and our campus values.
Vanderbilt University is an equal opportunity, affirmative action employer. Women, minorities, people with disabilities and protected veterans are encouraged to apply.
Primary Location: United States-Tennessee-Nashville
Organization: 38200 - Benefits
Job: Information Technology Professionals
Vanderbilt University is committed to principles of equal opportunity and affirmative action