eStar-Alchemy Lead Developer and Analyst/Architect

eStar-Alchemy Lead Developer

6 Months

Oakland, CA 94612 (100% REMOTE)

**Open to both Local and Non-Local candidates**

EQUIPMENT: Personal laptop

Top Things:

• Five years of experience working in a Power/Gas utility environment, supporting Energy Procurement Settlements and developing coding scripts to generate Power and Gas Contract Invoices, or Bills, or a system that requires complex calculations using multiple complex inputs.
• Five years of experience as an Analyst/Architect translating complex Power and Gas contract language into technical specifications used to develop scripts for Power and Gas Contract Invoicing, or Bills, or a system that requires complex calculations using multiple complex inputs.
• Five years of experience using CLIENT’s proprietary eStar Alchemy programming language and tools or similar tool of other programming language to develop new scripts for generating Power and Gas Contract Invoices, or Bills, or a system that requires complex calculations using multiple complex inputs.

Position

• eStar-Alchemy Lead Developer-Lead Analyst/Architect to develop and maintain coding scripts used to generate Power and Gas Contract Invoices.
• The work is done using CLIENT’s proprietary eStar Alchemy programming language and platform.

Background

• In support of CLIENT’s Energy Procurement LOB, the work focuses on the development and enhancement of calculation templates capable of generating invoices based on complex business logic and data-driven inputs. The project leverages eStar-Alchemy, a proprietary programming language and framework that accelerates the development of calculation templates by ten-folds as well as a technology stack that includes Java, React JS, Oracle, and Excel.
• The primary objective of the eStar-Alchemy project is to enable the design and implementation of invoice calculation templates that incorporate sophisticated computations, including true-ups derived from meter data, ambient conditions, outage information, gas load metrics, and third-party pricing inputs. These templates are intended to support accurate, consistent, and auditable invoice generation aligned with business requirements.
• This project presents inherent complexity due to the advanced logic required to build and maintain the calculation templates, as well as the dynamic nature of business requirements that may necessitate changes across multiple calculation templates.

Responsibilities:

Project and Enhancement Services:

During the Service Coverage Window, the Consultant shall perform the following project and enhancement activities:

Calculation Logic Development

• Analysis, design, and implementation of complex calculation logic to support invoice generation and true ups.
• Calculations may incorporate multiple data sources, including but not limited to meter data, ambient data, outage information, gas load data, and third party pricing inputs.
• Includes collaboration with Client stakeholders to translate business requirements embedded in Contracts into scalable and configurable calculation templates.

Configuration Engine Enhancements

• Enhancements and updates to the existing configuration engine to address dynamic and evolving business requirements.
• Includes impact analysis, implementation, and validation to ensure solution accuracy, consistency, and maintainability.

Application Monitoring and Support

• Continuous monitoring of the eStar-Alchemy application during the Service Coverage Window.
• Provision of application support services, including incident management, break/fix activities, and operational support.

Operational Support Services

• Production and QA code deployment support for eStar-Alchemy, aligned to the Service Coverage Window.
• Monthly security patch support, including deployment assistance and validation.
• Assistance with root cause analysis (RCA) for eStar-Alchemy related incidents, as reasonably required.
• Filing of Change Requests (CRQs) and preparation of required supporting documentation.
• Management and operational support of eStar-Alchemy application environments.

Technology Expertise:

Services shall be delivered by personnel with expertise in the following technologies, as applicable to the Services:

• CLIENT’s eStar-Alchemy proprietary programming language and tool
• Java
• React JS
• Oracle
• Microsoft Excel

Experience and Skills

Required:

• Five years of experience working in a Power/Gas utility environment, supporting Energy Procurement Settlements and developing coding scripts to generate Power and Gas Contract Invoices.
• Five years of experience as an Analyst/Architect translating complex Power and Gas contract language into technical specifications used to develop scripts for Power and Gas Contract Invoicing.
• Five years of experience using CLIENT’s proprietary eStar Alchemy programming language and tools to develop new scripts for generating Power and Gas Contract Invoices.
• Five years of experience working with energy datasets used to generate Power and Gas Contract Invoices, including meter data, ambient conditions, outage information, gas load metrics, and third party pricing inputs.
• Five years of experience using CLIENT’s proprietary eStar Alchemy programming language and tools to debug, modify, and enhance existing scripts that generate Power and Gas Contract Invoices.
• Five years of experience providing application support for CLIENT’s eStar Alchemy programming language and tools, including incident management, break/fix activities, and operational support.

Ten years of experience working with a technical stack supporting a calculation engine such as CLIENT’s eStar Alchemy platform, including:

• Java
• React JS
• Oracle
• Excel

Desired

• Working knowledge of CAISO Markets
• Working knowledge of Python