Associate Energy Market Analyst ​(Support - SQL Focused)

Overview

Frontline support role for consultants and customers using the Adapt2 (A2) ISO product, investigating shadow settlements and database-dependent processes in Microsoft SQL Server.

What you'll do

• Provide frontline technical support for A2 customers and consultants, investigating issues and escalating tier 3 cases with clear diagnostic evidence.
• Build and maintain strong client relationships, acting as a trusted advisor to help optimize their use of the A2 enterprise solution.
• Collaborate with Software Development, Implementation/Delivery, and Product Management to reproduce A2 issues, communicate findings, and validate customer solutions.
• Analyze A2 data and job status in Microsoft SQL Server to identify recurring issues, recommend improvements, and contribute to long-term resolutions.
• Troubleshoot and optimize complex T-SQL stored procedures for A2 shadow settlements, allocations and transmission profit and loss; validate results.

What you'll need

• Strong T-SQL skills in joins, CTEs, aggregations, window functions and stored procedures; use SQL Server Management Studio (SSMS) to investigate A2 data discrepancies and query performance.
• Demonstrated experience in or eagerness to develop Python skills for A2 data validation, transformation, support automation and analysis.
• Experience testing RESTful APIs, SOAP APIs and A2 integrations using Postman, Swagger and web services; interpret requests, responses and errors.
• Follow written and oral instructions, document A2 reproduction steps and SQL findings, and explain technical concepts to non-technical audiences.
• Computer Science or Engineering background preferred.

Nice to have

• Microsoft Power BI, Azure Cloud, Azure DevOps, CI/CD pipelines for deploying microservices to Azure Kubernetes Service (AKS).
• Experience or understanding of power market settlements, transaction processing and reconciliation of A2 settlement results.
• Understanding of Azure cloud services, storage and infrastructure supporting A2 integrations, report downloads and application operations.
• Familiarity with ISO and RTO operations, market reports and settlement data, including operating dates, participants and report versions.

Details

• Location: Pune, Maharashtra, India.