Healthcare Data Support Analyst - Microsoft Excel (Remote)

Healthcare Data Support Analyst - Microsoft Excel

Location: Remote

About Us:

Known for Delighting the Client through performance, innovation, and an employee-centric culture, S2Tech is a fast-growing IT consulting company serving clients in over a quarter of the United States. We are widely recognized as a leading provider of both technical and business services in support of Health and Human Services-related projects.

Why S2Tech?:

• Stable privately-owned company with a strong reputation for building long-term client relationships through the delivery of consistent value-based service
• 25+ years providing IT and Business services to private customers and government programs throughout the United States
• Expansive client portfolio and active projects employees benefit from innovative project exposure and in-house skill development training/courses
• Corporate culture that emphasizes the importance of family and promotes a healthy work-life balance
• Offer competitive pay and a range of benefits, including:
• 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
• Be part of a company that gives back through its non-profit organization, Fortune Fund, which was launched in 2001. The goal of the Fortune Fund is to close the rural/urban divide by ensuring children in rural communities in India and the United States understand the importance of education & are aware of professional career opportunities, allowing them to link their professional & educational goals

Job Overview:

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.

Responsibilities:

PDE Cycle Processing

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
• Narrative Reporting Support
• Assist with preparation of PDE cycle narratives, including:
• Summarization of processing activities and results
• Formatting documentation
• Preparing statistical highlights and validation points

File Submissions & Reporting

• 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

Client & Operational Support

• 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

Qualifications:

Technical Skills

• 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

Competency Requirements

• Technological Competence
• Effectively utilizes required software, tools, and systems
• Demonstrates capability to learn specialized healthcare reporting platforms quickly
• Maintains accuracy while working across multiple technical workflows
• Reliability
• 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

Preferred:

• 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

S2Tech is committed to hiring and retaining a diverse workforce. We are an equal opportunity employer making decisions without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected class.