Sql analyst Jobs in Pompano Beach, FL

Analyst, Benefits

Under limited supervision, this position supports the administration, analysis, and communication of employee benefits and welfare programs for college employees, eligible retirees, and eligible COBRA participants. Employee benefits and welfare programs include but are not limited to health, dental, vision, life insurance, FMLA, tuition reimbursement, long term disability, saving and spending accounts, retirement, worker's compensation, and sick leave pool. This position performs specialized work involving administrative, technical, and analytical duties in the Human Resources Talent and Culture Employee Benefits Office. Ensures the security, integrity, and confidentiality of all employee records in accordance with policy and the law.

This position allows eligible veterans and their spouses to claim Veterans' Preference pursuant to Florida Statute 295. Certain servicemembers may be eligible to receive waivers for postsecondary educational requirements, in the employment by the state and its political subdivisions and are encouraged to apply for the positions being filled. Applicants claiming preference are responsible for providing required documentation at the time of submitting application. For information on obtaining a DD 214 visit or call 1-866-272-6272.

Minimum Education: Bachelor's degree required preferably in Human Resources or Business concentrations. An equivalent combination of experience and education may be considered.

Minimum Experience: Four or more years of directly related experience. Experience required is within field or closely related field. Experience with Workday and People First a plus.

Essential Functions:

• Daily - 15%: Analyzes all benefits for employees, including medical, dental, long term disability, retirement, life insurance, Section 125 cafeteria plan, vision, and other voluntary benefits in compliance with State Group Insurance Program (SGIP) and Broward College rules, policies, and procedure and State and Federal laws. Provide guidance, where applicable, to employees on eligibility decisions based on legal guidelines, policies and procedures. Approve Broward College employees' benefit elections in Workday for new hires and existing employees' benefit election. Generates and audits benefit eligibility reports for full and part-time employees to ensure accuracy in Workday and People First. Perform research and analysis to detect discrepancies and assist in correcting. Manage rates/premiums as applicable in Workday for BC voluntary and company paid benefits. Conducts analysis and audits of the BC benefits related integration error reports generated from file transmittals to ensure accuracy of data. Lead the Workday bi-annual testing for benefits related processes within the system.
• Daily - 25%: Administers employee related leave of absence including, but not limited to, FMLA, Paid Parental Leave, Long Term Disability (LTD), and Extended Leave according to college rules, policies, procedures, and State and Federal Law. Conducts audits to ensure accuracy and resolve discrepancies. Assists employees with inquiries relating to leave of absences and determining eligibility. Run, analyze and audit the Sick Leave Pool report. Develops and maintains a detailed tracking system for FMLA leave. Manage organization compliance for leave of absences in accordance with benefits policies, processes and federal, state and local laws and regulations and stay current with changes that may impact the administration of leaves of absence. Decides and acts when Long-Term-Disability application process is necessary, determine eligibility and calculate benefits. Manage the process to return the employee to work, including Fitness of Duty review and approval as appropriate. Review and respond to employees who are requesting time off due to COVID.
• Daily 20 %: Administer and process Tuition Reimbursement and Tuition Assistance Program, reviewing eligibility and providing guidance to employees based on College rules, policies and procedures. Manages rate updates in the system of record and assists with fiscal year reporting usage and statistics. Prepares usage reports and advises the Senior, Director, Employee Benefits of budget versus actual spend.
• Daily - 10%: Review deferred compensation plan requests for distribution, including TSA documents and FICA Alternative plan, to assist in the determination on action per IRS rules. Assist with the processing of DROP and regular Retirement applications with FRS and Social Security. Assist in responding to questions and inquiries from employees and agencies regarding retirement and the coordination of benefits with social security. Conducts audits and analyzes retirement reports to ensure accuracy, correct discrepancies and update retirement plans in Workday. Facilitates retirement workshop for employees preparing to retire. Prepare and assist with the monthly payment to the TSA Consulting Group.
• Daily - 15%: Assist with communication and composing responses to benefits related inquiries. Participates in the benefits orientation presentation ensuring that new employees are educated on all the benefits offered by SGIP and the College and understand the enrollment process in People First and Workday. Monitor and respond to inquiries received in the benefits mailbox and phone line. Draft and send communication to employees losing coverage.
• Monthly - 10%: Assists with the planning and preparation of employee benefits and wellness onsite and virtual events including retirement seminars, tax- sheltered annuities vendor fair, health/benefits fair, and flu clinic. Assist with the coordinating and facilitating of the open enrollment sessions for medical, dental, vision, section 125 cafeteria plan, and sick leave pool. Assist with the benefit communication during Open Enrollment and online benefits updates and other related functions as assigned.
• Other - 5%: Performs related duties as assigned.

Knowledge, Skills and Abilities: Fully proficient in professional and functional standards and protocols of position. General understanding of College's structure, policies and practices, and the impact on its own area. Ability to contribute in multiple related areas within the function. Expertise in understanding and following project plans, including the coordination of multiple resources and activities. Understanding of and ability to coordinate interdependencies of work within the area and of resources from outside the area. Ability to exchange and present information with individuals and colleagues within the College. Requires advanced knowledge of computerized systems and operating environments i.e. Microsoft Office Products and specialized computer systems spec. Ability to interact and effectively communicate with a diverse employee, student population.

Our Culture: At Broward College, our leaders embody a culture of competence, care, character, composure, and courage. We prioritize serving each other and our students through high-quality guidance, mutual respect, resilience, and fair, thoughtful decision-making, all while upholding the values of integrity, transparency, and honesty.

Job Status: Full time Regular

Department: Benefits

Location: Cypress Creek Administrative Center

Pay Grade: 714

Salary: $42,320 - $49,726 - Salary commensurate with education and experience.

Work Shift: First Shift

Work Schedule: Monday - Friday

Hours Per Week: 40

Posting End Date: Open Until Filled

Comments: To be considered for this position, a completed online employment application along with a resume is required.

Designated Essential Personnel: No

FLSA Status: Non-Exempt

Position Classification: Professional Technical Staff (PTS)

Special Instructions to Applicant: For positions requiring a degree, the official transcripts are required upon hire. An unofficial copy of the degree/transcript is acceptable during the application process and must be attached to the online application. If unable to attach the documentation, please email document to jobs@broward.edu or fax to 954-201-7612, stating clearly the position name(s) and position number(s) the transcript is to be attached to.

Foreign Transcript: Transcripts issued outside of the United States require a equivalency statement from a certified transcript evaluation service verifying the degree equivalency to that of an accredited institution within the USA. This report must be attached with the application and submitted by the application deadline. All required documentation must be received on or before the job posting end date.

Please note that multiple documents can be uploaded in the "Resume/CV/Transcript/License/Certification" section of the application **

Employment is contingent upon successful completion of the required background screening process.

Broward College uses E-Verify to check employee eligibility to work in the United States. You will be required to complete an I-9 Form and provide