Strategic Billing Analyst I, II, or Sr
About The Position
JOB SUMMARY: The Strategic Billing Analyst is a detail-oriented individual with a critical role responsible for ensuring the accuracy and integrity of our financial billing data, providing key analysis, and developing reporting tools that directly support strategic decision-making and resource management. The ideal candidate possesses a strong command of financial data, excellent analytical skills, and proficiency with data visualization tools. Key Responsibilities The Billing Analyst will perform a variety of essential tasks, including but not limited to: Financial Data Validation & Integrity: Execute financial data validation processes, ensuring the accuracy and consistency of all billing inputs, outputs, and systems. Review and ensure the correct implementation of tax rules and regulations within the billing system. Validate and manage specialized Government Account Data, ensuring compliance with specific federal and state billing regulations and reporting requirements. Perform IL Commerce Commission (Intercompany/Intracompany) data validation to ensure accurate cross-departmental or entity billing and reconciliation. Identify, investigate, and resolve data discrepancies or anomalies proactively. Accounting & Reconciliation: Prepare and process journal entries related to billing, adjustments, and revenue recognition to maintain accurate financial records. Perform in-depth analysis of aging reports to monitor outstanding balances, assess collection risks, and inform departmental strategies. Compliance & Audit Support: Provide comprehensive support for internal and external audits by preparing required documentation, gathering data evidence, and addressing auditor inquiries related to billing records and processes. Ensure all billing procedures and data handling adhere to relevant regulatory and financial compliance standards. Reporting & Business Intelligence: Develop, create, and maintain standard and ad-hoc financial and operational reports. Design, implement, and manage data reporting tools and dashboards, with a focus on Power BI, to provide clear, actionable insights into billing performance and trends. Streamline reporting processes for efficiency and accessibility across the department. Strategic Support: Validate and analyze billing data to help the Billing Department effectively manage resources and make sound decisions based on data. Present complex analytical findings clearly and concisely to stakeholders. Project Support & Implementation: Actively support departmental and cross-functional projects related to billing system enhancements, migrations, new product launches, and process improvement initiatives. Participate in user acceptance testing (UAT) and data mapping to ensure project deliverables meet billing requirements. The Strategic Billing Analyst will be successful by delivering accurate, timely, and insightful data and reports that enable the Strategic Billing Department to operate efficiently, manage risk, and optimize financial performance.
Requirements
- BA/BS degree in Accounting or Finance and/or Data Analytics or MIS
- 1-3 years Gas Utility experience
- Advanced proficiency with Microsoft Excel (e.g., Pivot Tables, VLOOKUPs, complex formulas)
- Proven experience with data visualization and business intelligence tools, with demonstrated expertise in Power BI
- Experience with financial reporting, journal entries, and the concepts of revenue recognition
- Proficient Communication Skills (oral and written)
- Strong analytical skills
Responsibilities
- Execute financial data validation processes, ensuring the accuracy and consistency of all billing inputs, outputs, and systems.
- Review and ensure the correct implementation of tax rules and regulations within the billing system.
- Validate and manage specialized Government Account Data, ensuring compliance with specific federal and state billing regulations and reporting requirements.
- Perform IL Commerce Commission (Intercompany/Intracompany) data validation to ensure accurate cross-departmental or entity billing and reconciliation.
- Identify, investigate, and resolve data discrepancies or anomalies proactively.
- Prepare and process journal entries related to billing, adjustments, and revenue recognition to maintain accurate financial records.
- Perform in-depth analysis of aging reports to monitor outstanding balances, assess collection risks, and inform departmental strategies.
- Provide comprehensive support for internal and external audits by preparing required documentation, gathering data evidence, and addressing auditor inquiries related to billing records and processes.
- Ensure all billing procedures and data handling adhere to relevant regulatory and financial compliance standards.
- Develop, create, and maintain standard and ad-hoc financial and operational reports.
- Design, implement, and manage data reporting tools and dashboards, with a focus on Power BI, to provide clear, actionable insights into billing performance and trends.
- Streamline reporting processes for efficiency and accessibility across the department.
- Validate and analyze billing data to help the Billing Department effectively manage resources and make sound decisions based on data.
- Present complex analytical findings clearly and concisely to stakeholders.
- Actively support departmental and cross-functional projects related to billing system enhancements, migrations, new product launches, and process improvement initiatives.
- Participate in user acceptance testing (UAT) and data mapping to ensure project deliverables meet billing requirements.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
5,001-10,000 employees
