Staff Accountant II

This position within the Revenue Accounting department is responsible for preparing, analyzing, and reconciling billed and unbilled revenue transactions to ensure the accuracy and completeness of financial and regulatory reporting. The role supports the month-end close process, account reconciliations, internal controls, and regulatory compliance activities. The Staff Accountant II will collaborate with Billing, Credit, IT, Regulatory, and other business partners to investigate variances, resolve issues, improve processes, and support automation initiatives. Additional responsibilities may include customer refunds, unclaimed property (escheatment), tax reporting, audit support, and data analysis.

JOB REQUIREMENTS:

- Bachelor’s degree in Accounting required
- 2 - 4 years of accounting experience
- Experience with month-end close required
- Experience preparing journal entries and accounting reconciliations required
- Experience with customer billing is a plus
- Experience with escheatment and unclaimed property a plus
- Experience analyzing large volumes of data using Excel or other reporting tools.
- Strong analytical and problem-solving skills.
- Experience in identifying and implementing process improvements.
- Ability to work independently and manage competing priorities in a deadline-driven environment.
- Utility industry experience preferred but not required.
- Experience working with ERP systems such as Oracle
- Experience with reporting and query tools preferred.

MAJOR JOB RESPONSIBILITIES:

- Analyze daily transactions from the billing system to ensure data integrity.
- Review customer refund transactions for reasonableness.
- Prepare journal entries as required for month end close.
- Perform controls as assigned to ensure revenue recognized is complete.
- Must be able to recognize discrepancies and investigate and/or escalate as appropriate.
- Process unclaimed property transactions, including loading records into the database and coordinating reissuance of payments, as required for each escheatment cycle .
- Prepare tax payment requests and required returns monthly.
- Work with Billing, Credit, and IT to research issues.
- Provide information to internal and external auditors as required.
- Prepare standard reports as needed for financial and regulatory reporting.
- Create queries as needed for ad hoc and new recurring data requests.
- Perform account reconciliations monthly on assigned accounts and resolve any issues promptly.
- Process Improvement
- Identify opportunities to automate manual accounting processes and improve reporting efficiency.
- Participate in system enhancements, testing activities, and process improvement initiatives.
- Reporting & Data Analytics
- Analyze large datasets to identify trends, anomalies, and potential reporting issues.
- Develop and maintain recurring reports, queries, and dashboards to support business needs.
- Cross-Functional Collaboration
- Partner with internal departments to resolve billing, refund, revenue, and customer account issues.
- Support regulatory filings and information requests as needed.
- Documentation
- Maintain process documentation and desktop procedures for assigned responsibilities.
- Assist with knowledge transfer and cross-training efforts within the department.

SKILLS:

Technical Skills:

- Strong understanding of Generally Accepted Accounting Principles (GAAP)
- Advanced Excel skills including Pivot Tables, VLOOKUP, and data analysis
- Experience using automation and AI tools, including Microsoft Copilot, Power Automate, or similar technologies
- Ability to create and maintain queries, reports, and data extracts

Core Competencies:

- Strong analytical and critical-thinking skills
- Excellent attention to detail and accuracy
- Effective written and verbal communication skills
- Ability to prioritize multiple deadlines in a fast-paced environment
- Ability to identify root causes and recommend solutions
- Strong collaboration and customer service mindset