Role Description
The PHS Billing Analyst II manages premium billing processes and supports automated billing solutions through advanced Excel and VBA programming. This role is responsible for processing financial transactions, improving reporting and workflow efficiency, and resolving billing discrepancies through collaboration with internal and external stakeholders. The position requires strong analytical, technical, written, and verbal communication skills, with frequent email and phone interactions, as well as intermediate proficiency in Microsoft Word, OneNote, and PowerPoint.
Key Responsibilities
-
Manage and process premium billing transactions, including adjustments, invoices, deductions, reversals, delinquency activities, and monthly billing cycles, ensuring accuracy, compliance, and clear communication with stakeholders through email and phone interactions.
-
Develop, maintain, and enhance Excel-based tools, reports, and VBA macros to automate billing processes, improve efficiency, and support operational goals while utilizing Microsoft Word, OneNote, and PowerPoint to document, communicate, and present business information.
-
Analyze, research, and resolve complex billing discrepancies by collaborating with internal departments, external stakeholders, and system support teams through professional written correspondence and verbal communication.
-
Design, monitor, and troubleshoot data integrations and automated data transfer processes between Excel and external systems to ensure data integrity, reporting accuracy, and effective communication of findings and resolutions.
-
Conduct audits, reconcile billing data, prepare reporting and analysis, and recommend process improvements that strengthen controls, accuracy, overall billing performance, and stakeholder understanding through clear documentation and communication.
Qualifications
-
High School Diploma or Equivalent
-
2 years of accounting or complex financial experience
-
3 years of customer service experience
-
Intermediate-level proficiency in Microsoft Word, OneNote, and PowerPoint
-
Strong written and verbal communication skills, with the ability to draft professional email correspondence and effectively manage frequent phone interactions with internal and external stakeholders
-
Advanced Microsoft Excel expertise, including development and maintenance of complex macros using VBA (Visual Basic for Applications)
-
Experience integrating Excel with external applications, including COM Automation, process automation, and data exchange between systems
Key Behaviors of a Successful Candidate
-
Driving Success: Acts with urgency, pursues ambitious goals and shows resilience in the face of obstacles and setbacks.
-
Adaptability: Sees possibilities in changing circumstances, accepts and understands change and alters behavior as necessary.
-
Improvement Mindset: Continually seeks new ways to create business/customer value by identifying and implementing opportunities for improved efficiency, effectiveness, and innovation.
Benefits
-
A rich benefits package including medical, dental, vision and a 401(k) plan with matching company contributions
-
An annual incentive bonus plan
-
Generous paid time off including 11 holidays, 2 wellness days, and 8 volunteer hours annually β PTO increases with tenure
-
A supportive, responsive management approach and opportunities for career growth and advancement
-
Paid parental leave and adoption/surrogacy assistance
-
An employee giving program that double matches your donations to eligible nonprofits and schools
Salary Range
$49,250.00 - $72,250.00