Billing Analyst with Advanced Excel

Utility Company

Columbus OH- Must work ONSITE M-F

Locals only

Needed ASAP

12 month contract

Billing Analyst with Advanced Excel

Job Summary:

The Billing Analyst is responsible for billing operations, analysis and customer service for large accounts. The Analyst will liaise with utilities, customers internal and external to resolve routine and complex billing questions and requests to ensure on time accurate billing.

Essential Job Functions & Tasks: Verify accuracy of billing data, review and analyze individual accounts making independent decisions regarding billing activities. Serve as the primary contact for large account billing management internally and externally through proactive communication with Sales and Customers, and reviewing all large account billings. Identify billing discrepancies and determine root cause of the issue. Recognize problem accounts and independently take the necessary steps to resolve issues and revise errors. Create manual invoices at a detailed customer level ensuring data integrity. Review, analyze and resolve unbilled cycles. Communicate and maintain relationships with utilities to troubleshoot issues and verify data. Work with IT to improve system-driven automation. Responsible for accurately updating and generating reports, analyze and draw appropriate conclusions. Comprehend and interpret EDI. Ensure SOX Compliance and participate in monthly close process. Work closely with the Pricing team to fully understand pricing components, ensure billing processes are aligned and stay abreast of any market driven or Utility changes that affect billing determinants. Ensure high degree of customer service for both internal and external customers. Ensure processes and training materials are documented and regularly maintained.

Basic Qualifications: Bachelor's Degree or equivalent required. Accounting, Finance or Business Management preferred. Minimum 3 years billing, finance or relevant business experience.

Knowledge & Skill Requirements: Advanced Excel and/or Microsoft Access skills to support data analysis. Technical understanding of information systems. Ability to read and interpret general business and technical documents as well as deliver concise communication to the sales team, customers and other AEP Energy employees. Ability to interact with all levels of the organization. Solid analytical and problem-solving skills Energy background / Energy billing experience ideal.

Additional Requirements: Ability to prioritize, plan proactively, manage conflicting priorities and multi-task effectively. Superior attention to detail and conscientious attitude relating to quality of work. Ability to work independently (with little instruction/supervision). Effective problem-solving skills: ability to identify alternatives and develop unique solutions. Takes initiative; proactive approach; asks questions to ensure understanding/clarity. Comfortable with change, uncertainty and in-development conditions. Resilient under stress and dealing with multiple demands. Excellent communication skills written, spoken, listening with ability to explain and interpret issues clearly.