PHS Billing Analyst II

Standard Insurance; Portland (OR); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with company matching

Annual incentive bonus

Paid time off and holidays

Parental leave and baby-friendly leave

Volunteer hours program

Job summary

The Standard in Portland, OR is seeking a PHS Billing Analyst II to manage premium billing transactions, automate processes with Excel and VBA, and improve reporting and workflows. You will collaborate with internal teams and external stakeholders to resolve discrepancies and ensure accurate financial processing.

The role requires strong analytical and communication skills, with proficiency in Word, OneNote, and PowerPoint, and 2+ years in accounting or finance complemented by 3 years of

Qualifications

• High School Diploma or Equivalent required.
• 2 years accounting or complex financial experience.
• 3 years of customer service experience.
• Advanced Excel with VBA macros experience.

Responsibilities

• Manage and process premium billing transactions and cycles with accuracy.
• Develop and maintain Excel-based tools, reports, and VBA macros to automate billing processes.
• Investigate and resolve billing discrepancies through collaboration with internal/external stakeholders.
• Design and monitor data integrations between Excel and external systems.
• Conduct audits, reconcile data, prepare reports, and suggest process improvements.

Skills

Excel VBA

Advanced Excel

Data analysis

Billing processes

Communication skills

Attention to detail

Education

High School Diploma or Equivalent

Tools

Excel

Word

OneNote

PowerPoint

VBA

Job description

The next part of your journey is right around the corner - with The Standard.

A genuine desire to make a difference in the lives of others is the foundation for everything we do. With a customer-first mindset and an intentional focus on building strong teams, we've been able to uphold our legacy of financial stability while investing in new, innovative technologies that support the needs of our customers. Our high-performance culture focused on operational excellence thrives thanks to remarkable people united by compassion and a customer-first commitment. Are you ready to make a difference?

Job Summary

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.

Skills and Background You'll Need

• Education: High School Diploma or Equivalent
• Experience: 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.
• Ability to communicate effectively with internal and external stakeholders.
• Strong organizational skills and attention to detail.
• 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.

Why Join The Standard?

We have built an enduring legacy of stability, financial strength and exceptional customer service through the contributions of the service-oriented people who choose to work at The Standard. To ensure we can attract and retain the best talent, when you join The Standard you can expect:

• 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

In addition to the competitive salary range below, our employee-focused benefits support work-life balance.

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 f