Remote Temporary Junior Analyst

Position: Remote Temporary Junior Analyst

Work Location: Remote, available exclusively for Florida residents.

Compensation: $19 per hour plus a comprehensive benefits package.

Employment Type: Temporary, ideal for gaining experience in the analytical field.

About Us:

A well-known medical benefits company headquartered in Manhattan is seeking to expand and plans to open an additional office in Florida soon. The company partners with businesses, municipalities, and organizations across the country, providing customized insurance and cost-management solutions designed to improve efficiency and reduce expenses. With a long-standing reputation for accuracy, integrity, and client satisfaction, the firm maintains a collaborative, team-oriented culture that values attention to detail and a commitment to excellence.

Position Overview:

We are seeking a Remote Temporary Junior Analyst for a long-term temporary, remote role (Florida residents only). This role is ideal for an analytical, detail-oriented professional with advanced Excel skills, including:

• VLOOKUP
• IF formula
• Remove Duplicates
• Text to Columns
• Pivot Tables

You will assist Account Managers and Producers with data analysis, reporting, and implementation processes within the Fixed Cost Division. This is an internal-facing position that requires strong Excel expertise, exceptional organization, and a proactive, team-oriented mindset.

Key Responsibilities:

Group Implementations:

• Collaborate with Producers and Account Managers to review and process implementation data such as eligible hours and census information using advanced Excel techniques, including VLOOKUP, IF formula, Remove Duplicates, Text to Columns, and Pivot Tables.
• Assist with vendor implementation tasks, including file creation, folder setup, and internal reporting per departmental guidelines.
• Conduct post-implementation follow-ups and testing to verify accurate setup of all coverage lines.

Ongoing Client Management:

• Follow internal process checklists and complete recurring tasks within established timeframes.
• Communicate with Account Managers regarding data processing—requesting hours, missing census information, and clarifications as needed.
• Perform data audits using advanced Excel functions (VLOOKUP, IF formula, Remove Duplicates, Text to Columns, Pivot Tables), identifying and reporting any inconsistencies.
• Manage internal data processing, including hours reporting, bill creation, BSRs, invoices, and eligibility files.
• Maintain accurate payment sheets and payment reports.
• Assist Account Managers with client-specific reporting and analytical requests using advanced Excel.

Skills & Qualifications:

• High proficiency in Microsoft Excel, including advanced functions (VLOOKUP, IF formula, Remove Duplicates, Text to Columns, Pivot Tables, formulas, data validation).
• Strong command of Microsoft Outlook and PowerPoint.
• Exceptional attention to detail, accuracy, and organizational skills.
• Strong analytical and problem-solving abilities.
• Excellent time management and multitasking skills.
• Ability to collaborate effectively in a remote, team-oriented environment.
• Comfortable working independently on a computer using standard office software and tools.

Work Environment & Scope:

This is a remote, temporary position that offers benefits and consistent work for a professional who enjoys data management, structured processes, and virtual collaboration. Candidates must reside in Florida and be available to work standard business hours. This role offers opportunities to grow skills, gain experience with a well-known medical benefits company, and be part of an expanding team as the company opens an additional Florida office.

Benefits:

• Health insurance
• Temporary role
• Opportunity to develop skills and gain professional experience in a structured, detail-driven environment

Shift Availability:

Day Shift (Required)

How to Apply:

If you are a detail-oriented, Excel-savvy professional who enjoys working with data in a remote environment and wants to be part of a well-known medical benefits company expanding into Florida, we encourage you to apply today!

Advanced Excel and PowerPoint