"Junior Database Analyst"

Details

Posted: 16-Jul-25

Location: New London, Connecticut

Categories: Staff/Administrative

Internal Number: 1197

Data & System Management

1. Administer and maintain HRIS data integrity for positions, jobs, benefits, payroll, and leave.
2. Import/export data between HRIS and related systems to ensure data accuracy.
3. Assist in system setup for benefits and payroll deductions.
4. Monitor and audit HRIS feeds, reports, and census data for accuracy.
5. Document and update all HRIS procedures and departmental workflows.
6. Maintain HR process documentation on the shared drive.
7. Maintain all information presented in the College’s on-line directory, Camel Web, and Camel benefits to ensure data is correct, and make changes as needed or requested on a timely basis.
8. Audit and reconcile benefits vendor census to College enrollments on a regular basis.
9. Import and export data between the benefit administration system, the various systems utilized in Human Resources, and the HRIS and ensure the integrity in those data feeds.

Reporting & Compliance

1. Create, run, and distribute HR reports using Banner, WebFocus, and other tools.
2. Support institutional reporting including IPEDS, CUPA, ERISA, ACA, and ad hoc surveys.
3. Provide employee statistics and analysis for internal and external reporting needs.

Training & Collaboration

1. Support HRIS upgrades through documentation review, testing, and training.
2. Coordinate data collection and reporting with the Dean of the Faculty’s Office, Finance, and Financial Aid.
3. Collaborate with Information Services (IS) to troubleshoot system issues.

Benefits & Compensation Support

1. Reconcile benefits vendor data with College enrollments regularly.
2. Provide backup support for benefits administration and leave management.
3. Assist in compensation and total rewards analysis and reporting.
4. Manage the Salary Planner tool and apply approved increases in Banner.
5. Create and distribute salary letters to staff.

Administrative & Project Support

1. Provide general administrative and office support to HR and related committees.
2. Process benefit invoices and maintain budget-related documentation.
3. Create surveys and mass communications as directed.
4. Answer phones, assist with mailings, and perform data entry as needed.
5. Support ongoing and ad hoc projects as assigned.

About Connecticut College: Connecticut College is a private liberal arts college in New London, Connecticut with a total undergraduate enrollment of over 1,700 students.