Billing Analyst with Advanced Excel

Central Point Partners; Columbus (OH); On-site; USD 60,000 - 75,000; Full time

Job summary

A financial services company in Columbus, OH is seeking a Billing Analyst to manage billing operations, ensuring accurate and timely invoicing for large accounts. The role requires a Bachelor’s degree, advanced Excel skills, and at least three years of relevant experience, preferably in energy billing. Key responsibilities include verifying billing data, resolving discrepancies, and maintaining customer relationships. This is a contract position with daytime hours from Monday to Friday.

Qualifications

• Minimum 3 years of billing, finance, or relevant business experience.
• Experience in energy billing or industry background is preferred.
• Ability to communicate concisely to sales, customers, and employees.

Responsibilities

• Verify accuracy of billing data and review individual accounts.
• Serve as the primary contact for large account billing management.
• Identify billing discrepancies and resolve issues.
• Create manual invoices ensuring data integrity.
• Communicate and maintain relationships with utilities.

Skills

Advanced Excel

Microsoft Access

Problem-solving

Customer service

Attention to detail

Education

Bachelor's Degree in Accounting, Finance or Business Management

Job description

Billing Analyst with Advanced Excel

Location: Columbus, OH – ONSITE Monday‑Friday. 12‑month contract.

Summary

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

Responsibilities

• Verify accuracy of billing data and review 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.
• Identify billing discrepancies, determine root causes, and independently take 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.
• Collaborate with IT to improve system‑driven automation.
• Accurately update and generate reports, analyze findings, and draw appropriate conclusions.
• Comprehend and interpret Electronic Data Interchange (EDI) transactions.
• Ensure SOX Compliance and participate in the monthly close process.
• Work closely with the Pricing team to fully understand pricing components and keep billing processes aligned with market or utility changes.
• Maintain high customer service standards for both internal and external customers.
• Document and regularly maintain processes and training materials.

Qualifications

• Basic Qualifications: Bachelor’s Degree or equivalent required. Accounting, Finance or Business Management preferred. Minimum 3 years of billing, finance or relevant business experience.
• Knowledge & Skill Requirements: Advanced Excel and/or Microsoft Access skills for data analysis. Technical understanding of information systems. Ability to read and interpret general business and technical documents and communicate concisely to sales, customers and other employees.
• Experience in energy billing or industry background is ideal.
• Prior ability to prioritize, plan proactively, manage conflicting priorities and multi‑task effectively.
• Superior attention to detail, conscientiousness, and ability to work independently with minimal supervision.
• Strong problem‑solving skills with initiative, proactive approach, and clarity in communication.
• Resilience under stress, adaptability to change, and comfort with uncertainty.

Seniority Level

• Associate

Employment Type

• Contract

Job Function

• Accounting/Auditing
• Utilities and Accounting