Senior Energy Systems Analyst

Gasoc; Tucker (GA); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Medical

Dental

Vision

401(k) Match

Parental Leave

Educational Assistance

Annual Performance Bonus

Paid Time Off

Volunteer Time Off

Job summary

Georgia System Operations Corporation (GSOC) seeks a Senior Energy Systems Analyst to own applications, data processes, and controls for accurate member billing and settlements. You will lead development using Excel/VBA, SQL, Microsoft Power Platform, and related tech while partnering across Energy Settlements and Data Systems.

The role blends business analysis with technical leadership to drive improvements, ensure audit readiness, and deliver reliable, scalable solutions.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 4+ years of experience in energy billing, settlements, or data-processing applications.
• Advanced Excel with VBA
• Translate contracts or policies into data/requirements.
• Proficiency with SQL and relational data concepts.
• Experience with design, testing, implementation, and QA.

Responsibilities

• Own and design applications for energy billing, settlements, and reporting.
• Develop and support solutions using Excel/VBA, SQL, and Power Platform.
• Collaborate with Data Systems on database design and data integration.
• Engage users to validate requirements and data quality.
• Support recurring billing and settlement activities for multiple systems.
• Maintain data, calculation logic, and business rules; resolve discrepancies.
• Coordinate issue resolution and ensure timely billing data.
• Translate contracts and policies into functional and technical specs.
• Analyze data trends and suggest automation and controls improvements.
• Forecast and apply statistical analyses to guide decisions.
• Represent the department in cross-company policy and system changes.
• Gather data to support contractual bills and audit requests.
• Provide training and documentation for applications and processes.
• Mentor junior analysts and contribute to leadership feedback.

Skills

Business analysis

Data analysis

Stakeholder communication

Excel VBA

SQL

Education

Bachelor's degree in CS/IS/Engineering/Analytics

Tools

Excel/VBA

SQL

Microsoft Power Platform

Power BI

Dataverse

Azure services

Python

R

Job description

Design, Support, and Improve Critical Energy Billing and Settlement Systems

Georgia System Operations Corporation (GSOC) is seeking a Senior Energy Systems Analyst to provide functional and technical ownership of the applications, data processes, controls, and business rules that support accurate and timely Member billing, energy settlements, contract calculations, and related reporting across the Family of Companies.

This role combines business systems analysis, application development, data analytics, and technical leadership to ensure critical energy billing and settlement solutions remain accurate , reliable, scalable, and audit-ready .

The Senior Energy Systems Analyst designs, develops, supports, and improves solutions using Excel/VBA, SQL, Microsoft Power Platform, and other appropriate technologies while partnering with Energy Settlements, Data Systems, System Operations, and other stakeholders.

This opportunity is ideal for an experienced systems analyst who enjoys solving complex business problems, translating contracts and policies into dependable automated solutions, and driving continuous improvement across mission-critical utility processes.

What You'll Do

As a Senior Energy Systems Analyst, you will provide functional and technical ownership of solutions that support Member billing , energy settlements , contract calculations , reporting , and related business processes.

You will:

• Design, develop, test, implement, and maintain applications and automated solutions for energy billing, settlements, contract calculations, and reporting.
• Develop and support solutions using Excel/VBA, SQL, Microsoft Power Platform, and other appropriate technologies.
• Partner with Data Systems on database design, data integration, transfer processing, security, and web-based reporting.
• Engage users to validate requirements, usability, business controls, data quality, and solution performance.
• Support recurring billing and settlement activities for OPC, GTC, and Member Systems.
• Maintain supporting data, applications, calculation logic, and business rules while investigating exceptions and discrepancies.
• Coordinate issue resolution and deliver accurate billing data according to established schedules.
• Apply disciplined validation and control processes to reduce the risk of billing errors and protect data integrity.
• Translate contracts, policies, operational changes, and stakeholder needs into clear functional and technical requirements.
• Analyze complex data, identify trends and exceptions, and recommend improvements to automation, controls, reporting, and workflow.
• Apply forecasting, statistical analysis, and other advanced analytical methods, as appropriate, to support operational and strategic decisions.
• Represent the department in cross-company discussions regarding policy, contract, system, and process changes.
• Calculate and gather data supporting Control Area Compact bills and other critical contracts, resolve audit-related questions, and respond to Member and management data requests.
• Provide technical support, training, knowledge transfer, and work review for department applications and processes.
• Develop and maintain system documentation, business rules, process libraries, validation procedures, and reference guides.
• Mentor less-experienced analysts and provide feedback to department leadership without exercising direct supervisory authority.

What You Bring

• Bachelor's degree in Computer Science , Information Systems, Engineering, Business Administration, Data Analytics, or a related field from an accredited college or university. A combination of relevant education, training, and directly related experience may be considered.
• Ideally, 4+ years of progressively responsible experience developing, supporting, or using complex energy billing, settlement, business-system, or comparable data-processing applications.
• Advanced Excel skills, including development, maintenance, and troubleshooting of VBA-based applications and automated processes.
• Experience translating business rules or contracts into data, calculation, reporting, and system requirements.
• Proficiency with SQL and relational data concepts.
• Experience with application design, integration, testing, implementation, support, change control, quality assurance, and business-process improvement.
• Ability to interpret complex contracts, policies, tariffs, procedures, and business rules and translate them into accurate technical requirements and acceptance criteria.
• Knowledge of data governance, access controls, program security, validation, reconciliation, audit support, and documentation practices.
• Ability to communicate technical and business information clearly to Members, management, technical teams, and non-technical stakeholders.

Preferred Qualifications

Utility Systems & Settlements Experience

• Moderate electric utility, generation and transmission, cooperative, energy-market, complex contract-billing, or energy-settlement experience.
• Experience supporting system and processes that manage high-volume billing, settlement, reconciliation, or contract-calculation processes in a controlled environment.
• Experience providing functional ownership, technical guidance, work review, or knowledge transfer for business-critical applications.

Development, Data & Automation

• Experience with Microsoft Power BI, Power Automate, Power Apps, Dataverse, Azure services, or comparable analytics and automation platforms.
• Experience with Python, R, or another object-oriented or scripting language.
• Experience modernizing legacy spreadsheets, automating manual workflows, strengthening controls, and improving user experience.

Certifications

• Relevant certifications in data analytics, Microsoft Power Platform, database technologies, project management, or business analysis are preferred but not required.

Advantages of Working at GSOC

Working at GSOC means more than just a job-- it's an opportunity to contribute to work that truly matters.

Mission-Driven Impact

Your work supports the accuracy and reliability of Member billing, energy settlements, contract calculations, and reporting used across the Family of Companies.

Energy Systems & Process Modernization

Design and improve applications, data processes, controls, reporting, and automation that support critical utility business processes and operational decisions.

Strong Values and Professional Standards

Work in an environment grounded in accountability, collaboration, and integrity, where data accuracy, disciplined controls, audit-ready documentation, and continuous improvement are the norm.

GSOC offers a professional, collaborative work environment with competitive compensation, comprehensive benefits, and a commitment to creating a respectful and inclusive workplace.

Benefits include, but are not limited to: Medical, Dental, Vision, 401(k) Match, Parental Leave, Educational Assistance, Annual Performance Bonus, Paid Time Off, and Volunteer Time Off.

Why Join GSOC

At GSOC, your work directly supports the systems, data, controls, and automated solutions used for Member billing, energy settlements, contract calculations, reporting, and business decision-making across the Family of Companies.

You'll collaborate with systems, data, operations, and business stakeholders in a mission-driven environment focused on accuracy, reliability, strong controls, stakeholder service, and continuous improvement.

Georgia System Operations Corporation is an Equal Employment Opportunity Employer, including veterans and disabled. We are a drug-free workplace. All applicants are subject to substance abuse testing.