Billing Transactions Analyst

SGS Consulting; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

SGS Consulting in Austin, TX is seeking an experienced billing analytics professional to ensure accurate and timely volumetric billing and reporting for energy products. You will manage customer usage, reconcile data issues, and analyze pricing and market data to support pricing structures.

The role requires collaboration across departments and with external partners, maintaining data integrity, tracking key metrics, and preparing analytical reports and presentations on energy usage and

Qualifications

• 5+ years’ experience in corporate environment (retail utility industry would be a plus).
• Experience with advanced Excel VLOOKUP, pivot table and Excel. Retail energy background preferred.
• Experienced with CRM systems (Salesforce experience would be a plus).
• Technical background with SQL

Responsibilities

• Ensure accurate and timely volumetric billing and reporting for energy products by managing customer usage and reconciling data issues.
• Support pricing structures by performing complex analyses of pricing and market data to identify cost impacts for stakeholders.
• Maintain data integrity, track key metrics, and collaborate with various departments and external partners.
• Prepare analytical reports and presentations on energy usage and forecasting for stakeholders.

Skills

Years of experience

Excel: VLOOKUP & Pivot

CRM systems (Salesforce)

SQL

Education

Bachelor's degree in business or related field

Job description

Job Responsibilities:

Responsible for ensuring accurate and timely volumetric billing and reporting for energy products by managing customer usage, reconciling data issues, ensuring compliance with market rules and tariffs, and performing complex analyses of pricing and market data to support pricing structures and identifying cost impacts for stakeholders. Key responsibilities include maintaining data integrity, tracking key metrics, collaborating with various departments and external partners, and preparing analytical reports and presentations on energy usage and forecasting.

Skills:

• 5+ years’ experience in corporate environment (retail utility industry would be a plus)
• Experience with advanced excel VLOOKUP, pivot table and ExcelRetail energy background experience is preferred
• Experienced with CRM systems (Salesforce experience would be a plus)
• Someone with technical background specialty in SQL

Education/Experience:

Bachelor’s degree in business or related field