insiderOne
Sign in
Energy ExemplerVia Unstop

Posted today

Associate Energy Market Analyst ​(Support - SQL Focused)

Pay

Salary (undisclosed)

Location

Pune, India

On site

Apply by

4 Nov

13 days left

Skills this role screens for

SQLMicrosoft SQL serverDatabase queryingIT service desk supportClient support

Opens on Energy Exempler's site. Sign in first and we keep it in your pipeline.

Still studying?Paid data internships open now

About the role

Energy Exemplar is hiring for the role of Associate Energy Market Analyst!

The work

Responsibilities of the Candidate

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

Who they want

Requirements

  • 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

Where this listing comes from

From a public listing board (Unstop).

insiderOne never charges students to apply. Never pay anyone for an internship. Check an offer you received

Prove SQL first

This role screens for SQL. Sit a ten-minute live challenge, get a signed receipt, and the employer sees it verified on your application instead of claimed.

Prove it, then apply

Ask about this role

SCOUT, an AI agent, not a person, answers from this ad, and says so when the ad doesn't cover it. No account, and nothing you type here is kept.

More data roles

Every data role here

insiderOne University

Get certified for roles like this: SQL Associate

Free, about 2 hours, ending in a project a person reviews and a certificate any employer can check. Put it on this application and every one after it.

Start the certificationWhat is in it

Interned at Energy Exempler? Report what it paid

From the Wire Desk