PHS Billing Analyst II

Overview

This role manages premium billing processes and supports automated billing solutions through advanced Excel and VBA programming. Responsibilities include processing financial transactions, improving reporting and workflow efficiency, and resolving billing discrepancies in collaboration with internal and external stakeholders.

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; use 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 to strengthen controls, accuracy, overall billing performance, and stakeholder understanding through clear documentation and communication.

Requirements

• 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, including the ability to draft professional email correspondence and 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.

Preferred Qualifications

• None listed in the original posting.

Compensation & Benefits

• Salary Range: $49,250.00 - $72,250.00
• Medical, dental, vision, and a 401(k) plan with matching company contributions.
• Annual incentive bonus plan.
• Paid time off including 11 holidays, 2 wellness days, and 8 volunteer hours annually (PTO increases with tenure).
• Paid parental leave and adoption/surrogacy assistance.
• Employee giving program that double matches donations to eligible nonprofits and schools.
• Paid parental leave and adoption/surrogacy assistance.

Notes:

• Eligibility to participate in an incentive program is subject to the rules governing the program and plan. Any award depends on a variety of factors including individual and organizational performance.
• The actual compensation for this role will be based on a combination of education and experience, knowledge and skills, position budget, internal equity, and market data.

Location

• Not specified in the original posting.

Additional Information

• Positions will be posted for at least 5 days from original posting date.
• This employer is an Affirmative Action/Equal Opportunity employer.
• Consideration is without regard to race, religion, color, sex, national origin, gender identity, sexual orientation, age, disability or veteran status or any other condition protected by federal, state or local law.
• Except where precluded by state or federal law, qualified applicants with arrest and conviction records will be considered pursuant to the San Francisco Fair Chance Ordinance.
• Drug- and alcohol-free work environment.
• Requires a criminal background investigation and employment, education and licensing verification as a condition of employment.
• All employees must be bondable.