Production Support Analyst( Energy Market Analyst-Support)

About the Position

This role provides frontline support for consultants and customers using the Adapt2 ISO product, managing tier 3 triage for shadow settlements and database-dependent processes. Responsibilities include troubleshooting complex stored procedures and SQL processes, analyzing system functionality, and resolving intricate energy market challenges. As a trusted advisor, this role fosters client relationships while collaborating with internal teams to deliver optimal solutions. Strong communication skills are essential to articulate technical concepts to diverse audiences, ensuring seamless service delivery and customer success.

• Provide software product's frontline technical support to customers and consultants using the Adapt2 ISO product, resolving tier 3 issues.
• Build and maintain strong client relationships, acting as a trusted advisor to help optimize their use of the enterprise solution.
• Collaborate with internal teams, including Software Development, Implementation/Delivery, and Product Management, to address customer needs and provide the best solutions.
• Analyze data and system performance in Azure SQL to identify recurring issues, recommend improvements, and contribute to long-term resolutions.
• Troubleshoot and optimize complex SQL stored procedures for different processes such as shadow settlements, allocations and transmission profit and loss.

Candidate Requirements & Qualifications

• Microsoft SQL Professionals: Advanced Knowledge of SQL - 4+ years of expertise in Transact-SOL (T-SQL) and PL/SQL for efficient database management, complex query writing, debugging, and data analysis for technical customer support
• Technical Adaptability: Demonstrated experience in Python for data transformation, automation and analysis
• API & Testing: Experience in unit testing and testing RESTful APls, SOAP APls, integration using POSTMAN, Microsoft Flow, Swagger and other web services
• Good to have: MS Power Bl, Azure Cloud, Azure DevOps, Cl/CD pipeline for deploying microservices to Azure Kubernetes Service (AKS)
• Communication skills: Ability to follow written and oral instructions, create standardized documents, and communicate technical concepts to non-technical audiences
• Computer Science or Engineering background preferred

Desired but not required

• Power Settlements Knowledge: Experience or understanding of power market settlements, transaction processing, and related financial systems
• Experience with C# for code debugging, data transformation, automation and analysis
• Microsoft Azure Ecosystem knowledge: Understanding of Azure cloud services, infrastructure, and how they integrate into enterprise software solutions
• Energy Power Market Knowledge: Familiarity with the dynamics and regulations of energy markets, particularly in the context of ISO and RTO operations

If Interested: Kindly share resume on: payal.joshi@energyexemplar.com