Spreadsheet Design Jobs (NOW HIRING)

Join Saint Paul Public Schools as a Benefits Technician II and play an important role in supporting the employees who make a difference in the lives of our students every day. This position is responsible for administering employee benefits programs, responding to benefit inquiries, processing enrollment and eligibility changes, and ensuring accurate and timely benefits administration. The successful candidate will combine strong technical and administrative skills with a passion for customer service to help deliver an outstanding employee experience across the district.

Minimum Qualifications

One year (45 credit hours) of post-secondary coursework in business or personnel administration, management information systems, computer-based technology or a related field and two years of experience in a benefits, human resources or insurance billing unit performing work that involves explaining benefits programs, benefits eligibility criteria, insurance billing or related topics. (Equivalent combinations or education and/or work experience will be considered.)

Knowledge, Skills and Abilities

• Working knowledge of the principles and practices of benefits administration.
• Working knowledge of database structure, spreadsheet design, benefits administration and insurance billing.
• Working knowledge of data collection and analysis methods and procedures.
• Working knowledge of benefits billing and other human resources information systems.
• Working knowledge of the theory and principles of data management.
• Working knowledge of federal and state laws governing data privacy.
• Considerable skills and ability in the use of: software databases, spreadsheets and processing applications.
• Considerable skill in performing mathematical computations requiring attention to detail.
• Considerable ability to communicate effectively, both orally and in writing.
• Working ability to perform research, prepare reports and maintain records.

Responsibilities:

• Assist with new hire benefits overview during onboarding.
• Administer COBRA insurance for employees resigning or separating from the District.
• Meet with employees and retirees to determine benefit eligibility by applying applicable bargaining unit (BU) contract language, reports and tracks new enrollees to third party administrator notifies insurance carriers of changes in insurance coverage.
• Maintain BU guidelines with current insurance rate tables. Update rate charts as new contracts are settled.
• Prepare monthly insurance billing, audits, balances and adjustments by downloading data from and importing necessary records into sophisticated spreadsheet formats, ensure that bills from insurance carriers reflect appropriate status of members.
• Coordinate, facilitate and provide evening monthly retirement seminars and update retirees for annual open enrollment process.
• Prepare monthly LIS (Low Income Subsidy) report monthly.
• Prepare various government reports, such as Reinsurance Association, Federal Form 5500, Medicare Second Payer and related reports.
• Generate complex customized reports using various software packages, perform uploads and downloads of data.
• Coordinate insurance refunds (both contractual and miscellaneous).
• Establish and file member records and maintain employee and retiree data base for benefits administration.
• Generate correspondence to retirees regarding discontinuance of the District health insurance contribution due to Medicare eligibility or other eligibility factors or relating to the collection of unpaid premiums.
• Work in coordination with the Business Office and TPA on the processing of insurance payments.
• Provide information and assistance to employees and retirees by telephone, mail or in person, to resolve problems or answer questions regarding insurance needs, insurance billing questions and related issues.
• Serve as liaison between covered member and insurance carriers to ensure proper enrollment, and deductions are taken.
• Assist in the annual insurance open enrollment periods.
• Maintain employee benefits records relating to insurance coverage and leave of absences.
• Contribute to the District's Strong Schools, Strong Communities efforts by partnering with other staff to contribute to student achievement and the alignment and sustainability of resources.
• Perform other duties as assigned.

Pay range for this position is: $27.15 - $33.61

Maximum hiring step = step five (5)

The full salary schedule is listed in the CCEA contract. Salary information for this job posting can be found at this link (https://www.spps.org/about/departments/human-resources/labor-agreements) and by selecting the " CCEA (Classified Confidential Employees Association)" Labor agreement.

Benefit information for this position can be found at this link (https://www.spps.org/about/departments/human-resources/benefits/benefit-summaries-by-bargaining-unit) and by selecting the "CCEA - Full Time" link.

Equal Employment Opportunity

Saint Paul Public Schools is an equal opportunity employer and supports an inclusive workplace environment.

Equity Statement

SPPS is committed to an equitable workforce where all employees represent this commitment through equitable practices in their job position.