Sql data analyst Jobs in Miramar, FL

Overview

The Benefits Accounting Analyst will be responsible for the accounting and administration of all benefits plans. This role will be responsible for all accounting, analytical and reporting tasks related to Benefits, COBRA, Life, Disability, Flexible Spending Account (FSA) and Health Savings Account (HSA).

Primary Responsibilities

• Accounting and Administration of all medical, dental, vision, life, disability, FSA, HSA and COBRA
• Ensure all benefit payments made are reconciled to the General Ledger and pending adjustments are kept in a log ensuring they are cleared by the next reporting period
• Ensure weekly interfaces are sent and received by the vendor. Validate all interface error reports. Update vendor website with adjustments needed in the weekly validation process
• Prepare all COBRA Payments for deposit by Cost Center. Create a document of all Divisional Expense Entries for General Ledger by Cost Center for Employer subsidized COBRA. Audit COBRA vendor to ensure all notices generated timely
• Prepare and validate all reports for all Benefit audits (union and non-union). Analyst will lead the audit, and coordinate all meetings with Legal, Controller, External Auditor. Analyst will gather all internal and external data, research discrepancies, analyze and recommend corrective actions to management, accounting and local Controller
• Utilize multiple reporting tools to create a variety of ad hoc and census reports, benefit reports, payroll reports and spreadsheets concerning enrollments, demographic data, payroll deductions and accruals in the General Ledger. Perform YTD analysis on FSA & HSA Plans
• Ensure the data quality and system configuration of all benefit plans in the HRIS systems are compliant with each plan document. This will involve providing system business requirements, testing of interface and payroll files and data in the Quality Assurance Environment to ensure the accurate administration of plans

Additional Primary Responsibilities

• Manage all benefit plan inquiries. Use Plan Documents, Summary Plan Descriptions, Adoption Agreements and other referenced materials to address and resolve all Company, Provider and employee inquiries in a timely and courteous manner
• Partner with the Benefits Manager to update all billing rates in system, participate in SGWS mergers, acquisitions and new union implementations
• Perform other duties as assigned

Minimum Qualifications

• A Bachelor’s Degree in Accounting, Human Resources, Finance or Business Related Field or equivalent working experience
• Critical nature of this job may require extended hours
• Minimum 3 years of comprehensive Accounting, analytical and reporting experience when it comes to Benefits Administration (union and non-union)
• Experience in reviewing Contracts, Plan Documents, SPD’s, Union Collective Bargaining Agreements, reconciliation of union invoices and interface analytics
• Ability to analyze large amounts of data. Identify and troubleshoot trends. Present trends to Management and Legal
• Proven aptitude for analysis of data and creation of queries
• Knowledge of finance and accounting practices, financial analysis and reporting
• Knowledge of Benefits’ Administration and billing reconciliation processes
• Knowledge of HRIS systems
• Must be proficient in Microsoft Office. Working intermediate knowledge in Excel, v lookups and pivot tables

Physical Demands

• Physical demands with activity or condition for a considerable amount of time include sitting and typing/keyboarding using a computer (e.g., keyboard, mouse, and monitor) or mobile device
• Physical demands with activity or condition may occasionally include walking, bending, reaching, standing, and stooping
• May require occasional lifting/lowering, pushing, carrying, or pulling up to 48lbs