Carrie Rikon & Associates-posted 3 days ago
Entry Level
Remote • Miami, FL

We are seeking a Remote Long Term Temporary Junior Analyst 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.

  • 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 .
  • 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.
  • Health insurance
  • Temporary role
  • Opportunity to develop skills and gain professional experience in a structured, detail-driven environment
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service