Long-Term Temporary Remote Database Analyst Position- Must Live in Florida

Summary

Carrie Rikon & Associates, LLC is an established Florida employee benefits consulting, insurance, and administration company seeking a Database Analyst to join its Fixed Cost Division. This role involves supporting employee benefits programs, database management, reporting, and systems development, while collaborating closely with various stakeholders to enhance business processes.

Responsibilities

• Participates in the initial implementation meeting and provides feedback regarding implementation timelines for various technical workflow processes
• Reviews the final cost breakdown associated with the group's benefits program and saves it in the appropriate folder
• Codes the new group in the system so the Account Management team can produce Benefit Summary Reports (BSRs), invoices, eligibility files, and other required reports
• Creates the initial billing documentation when automation is unavailable
• Participates in post-implementation meetings with the division
• Prepares and maintains Monthly Totals Reports
• Updates and distributes Sirius Reports to relevant vendors
• Captures benefit structure changes and ensures updates are reflected in backend systems and reports
• Manages the database and incorporates timely updates regarding benefit structure changes, including:
• Network fee updates
• Premium increases
• Benefit removals
• Other plan modifications
• Updates cost breakdowns during the renewal process
• Creates reports requested during client audits
• Conducts division data reviews and accounting data reviews prior to report generation
• Monitors and captures enrollment and benefit adjustments in relevant reports
• Communicates benefit adjustments to Accounting and assists with QuickBooks reconciliations
• Responsible for reviewing the annual Ceded Risk Analysis
• Responsible for aggregating and processing data relevant to annual 1094/1095-C IRS filings
• Coordinates with Account Managers to obtain required data from clients and payroll vendors
• Sends filing data to the designated filing vendor in the required format
• Educates and trains team members on technical tools, systems, and processes

Skills

• Must Be A Database Analyst and live in Florida
• High proficiency in Microsoft Excel, Outlook, and PowerPoint
• Microsoft Access Developer experience
• Experience with Excel spreadsheet development and analysis
• Relational database design experience, including unique identifiers and relational table creation
• VBA knowledge and application
• Advanced reporting experience
• Ability to create complex IF statements and calculated fields
• Ability to create macros
• Knowledge of importing and linking various data sources, including Excel and Access
• SQL knowledge
• Experience writing procedures
• Experience manipulating data within Excel and other file formats to prepare data for Access databases
• Extensive experience with database technologies
• Ability to learn and demonstrate an understanding of employee benefits insurance terminology, products, and services
• Ability to remain seated and work at a computer for extended periods of time
• Work is performed predominantly in an office environment
• Bachelor's Degree in Computer Science or a related field required
• 1 to 3 years of experience in Database Administration, Information Technology, Database Architecture, or a related field preferred

Qualifications

Must Haves

• Must Be A Database Analyst and live in Florida
• High proficiency in Microsoft Excel, Outlook, and PowerPoint
• Microsoft Access Developer experience
• Experience with Excel spreadsheet development and analysis
• Relational database design experience, including unique identifiers and relational table creation
• VBA knowledge and application
• Advanced reporting experience
• Ability to create complex IF statements and calculated fields
• Ability to create macros
• Knowledge of importing and linking various data sources, including Excel and Access
• SQL knowledge
• Experience writing procedures
• Experience manipulating data within Excel and other file formats to prepare data for Access databases
• Extensive experience with database technologies
• Ability to learn and demonstrate an understanding of employee benefits insurance terminology, products, and services
• Ability to remain seated and work at a computer for extended periods of time
• Work is performed predominantly in an office environment
• Bachelor's Degree in Computer Science or a related field required

Nice to Haves

• 1 to 3 years of experience in Database Administration, Information Technology, Database Architecture, or a related field preferred

Benefits

• Health Care Plan (Medical, Pharmacy & Mental Health
• Training & Development