Premium Billing Analyst II - Excel VBA & Data Automation

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 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