Healthcare Data Support Analyst Microsoft Excel (Remote)

S2Tech-posted 3 days ago
Full-time • Entry Level
Remote • Chesterfield, MO
101-250 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

S2Tech is seeking a detail-oriented Healthcare Data Support Analyst to support Medicare Part D reporting functions for a large healthcare services client. This role provides hands-on operational support in the end-to-end processing, validation, submission, and reconciliation of Prescription Drug Event (PDE) files to the Centers for Medicare & Medicaid Services (CMS). The analyst will work directly within the PDE production workflow, including processing client data extracts, performing required Excel manipulations, executing secure file transfers (SFTP), submitting files to CMS vendors, and retrieving and organizing CMS response files for internal teams and client consumption. This position also supports narrative preparation and reporting related to PDE submission cycles. This role requires exceptional attention to detail, intermediate Excel skills, basic technical aptitude with SFTP systems, and strong reliability for processing tasks that support regulatory compliance.

  • Support the full lifecycle of PDE file submission, including: Initiate PDE Cycle
  • Perform required Excel file manipulation and data preparation as part of submission initiation
  • Compile and validate data extracted from operational databases against CMS file layout requirements
  • Complete PDE Cycle
  • Execute Excel transformations and reconciliation activities to support PDE acceptance validation
  • Track submission statuses and ensure necessary updates are documented for internal teams
  • Assist with preparation of PDE cycle narratives, including:
  • Summarization of processing activities and results
  • Formatting documentation
  • Preparing statistical highlights and validation points
  • Perform required Excel file manipulation and data preparation as part of submission initiation
  • Compile and validate data extracted from operational databases against CMS file layout requirements
  • Execute Excel transformations and reconciliation activities to support PDE acceptance validation
  • Track submission statuses and ensure necessary updates are documented for internal teams
  • Assist with preparation of PDE cycle narratives, including:
  • Summarization of processing activities and results
  • Formatting documentation
  • Preparing statistical highlights and validation points
  • Summarization of processing activities and results
  • Formatting documentation
  • Preparing statistical highlights and validation points
  • Facilitate secure submission of PDE files to CMS vendors via SFTP
  • Retrieve, download, and organize CMS response files for review and downstream consumption
  • Deliver P2P (Peer-to-Peer) client reports via SFTP according to established schedules and protocols
  • Manage CSSC password resets and client SFTP credentials through established security workflows
  • Maintain accurate operational records and audit documentation related to submissions and file handling
  • Coordinate with internal processing staff to ensure timely resolution of submission or validation issues
  • Intermediate proficiency in Microsoft Excel, including: Data formatting and manipulation Filtering and basic analysis Template updates and data validation checks
  • Familiarity with SFTP file transfers, including upload/download workflows
  • Working knowledge of Microsoft Outlook for communication, scheduling, and task coordination
  • Ability to navigate operational databases and standardized reporting templates
  • Data formatting and manipulation
  • Filtering and basic analysis
  • Template updates and data validation checks
  • Effectively utilizes required software, tools, and systems
  • Demonstrates capability to learn specialized healthcare reporting platforms quickly
  • Maintains accuracy while working across multiple technical workflows
  • Demonstrated strong attendance and punctuality
  • Consistently follows through on assigned responsibilities with minimal supervision
  • Meets deadlines for recurring regulatory processing cycles
  • Maintains accountability for assigned deliverables
  • Effectively utilizes required software, tools, and systems
  • Demonstrates capability to learn specialized healthcare reporting platforms quickly
  • Maintains accuracy while working across multiple technical workflows
  • Demonstrated strong attendance and punctuality
  • Consistently follows through on assigned responsibilities with minimal supervision
  • Meets deadlines for recurring regulatory processing cycles
  • Maintains accountability for assigned deliverables
  • Experience in healthcare operations, Medicare/Medicaid reporting, or claims/PBM data processing
  • Prior exposure to Medicare Part D, PDE data, or regulatory reporting is a plus but not required
  • Ability to work with sensitive health data in compliance with HIPAA and data security standards
  • Strong written communication and documentation skills
  • Medical / Dental / Vision Insurance - insurance premium assistance provided
  • Additional Insurance (Life, Disability, etc.)
  • Paid Time Off
  • 401(k) Retirement Savings Plan & Health Savings Account
  • Various training courses to promote continuous learning
  • Corporate Wellness Program
  • Medical / Dental / Vision Insurance - insurance premium assistance provided
  • Additional Insurance (Life, Disability, etc.)
  • Paid Time Off
  • 401(k) Retirement Savings Plan & Health Savings Account
  • Various training courses to promote continuous learning
  • Corporate Wellness Program
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Data Analyst Intern Resume Examples
•
Data Analyst Intern Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service