Agent
Jobs
Applied
Tracker
Profile
    1. Jobs for you
    2. Job

    Job · 21337622

    PUNE · FULLTIME

    Associate Energy Market Analyst (Support - SQL Focused)

    Energy Exemplar

    Energy Exemplar

    Pune · onsite · Posted 4d ago

    Sourced fromNaukri
    Undisclosed1–6 yrsfulltimePune

    Your match

    ?

    Sign in to see your match score, skill gaps & tailored resume.

    Section · 01

    About this role

    Job Summary
    This role provides frontline support for consultants and customers using the Adapt2 (A2) ISO product, investigating shadow settlements and database-dependent processes in Microsoft SQL Server. Responsibilities include troubleshooting T-SQL stored procedures, tracing report downloads and parsing, validating market data, and supporting complex issue resolution with senior analysts. As a trusted advisor, this role builds client relationships while collaborating with internal teams to deliver effective solutions. Strong communication skills are essential to explain technical findings to diverse audiences, ensuring reliable service delivery and customer success.


    Responsibilities
    • 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.


    Qualifications
    • Microsoft SQL Server Knowledge: 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.
    • Technical Adaptability: Demonstrated experience in or eagerness to develop Python skills for A2 data validation, transformation, support automation and analysis.
    • API Testing: Experience testing RESTful APIs, SOAP APIs and A2 integrations using Postman, Swagger and web services; interpret requests, responses and errors.
    • Good to have: Microsoft Power BI, Azure Cloud, Azure DevOps, CI/CD pipelines for deploying microservices to Azure Kubernetes Service (AKS)
    • Communication skills: 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.


    Desired but not required
    • Power Settlements Knowledge: Experience or understanding of power market settlements, transaction processing and reconciliation of A2 settlement results.
    • Microsoft Azure Ecosystem knowledge: Understanding of Azure cloud services, storage and infrastructure supporting A2 integrations, report downloads and application operations.
    • Energy Power Market Knowledge: Familiarity with ISO and RTO operations, market reports and settlement data, including operating dates, participants and report versions.


    Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

    Sourced from naukri

    Let the agent run this one for you.

    Tailored resume, auto-apply, and referral lookup — in under 2 minutes.

    Section · 02

    Skills

    AutomationDevopsKubernetesAzure DevopsCI/CD PipelinesAuroraapisAksdiagnosticcustomer successAzure Kubernetes ServiceintegrationsMarket AnalystcloudCommunication SkillsAPI TestingData ValidationMicrosoft Azure

    Section · Company

    About Energy Exemplar

    Energy Exemplar

    Energy Exemplar

    Software Product

    300

    employees

    1999

    27 years old

    Pune, Maharashtra

    India

    ₹24L PA avg

    Avg at Energy Exemplar

    About

    Developer of PLEXOS®, a modeling software for the energy sector, enabling stakeholders to navigate the decarbonization challenge effectively.

    Industries

    Software Product

    Employee ratings

    10 reviews

    3.7/ 5

    Culture

    4.1

    Career growth

    3.8

    Work-life

    4.1

    Employees rate it well for

    Work-Life Balance45Company Culture41

    Find them on

    WebsiteLinkedInAmbitionBox reviews

    Job search guides

    • All 9,802 jobs in Pune
    • Auto-apply to jobs like this
    • Tailor your resume for this role
    • Naukri auto-apply, explained
    • How to find a job in India, fast