Associate Energy Market Analyst ​(Support - SQL Focused)

The role

This role provides frontline technical support for customers and consultants using the Adapt2 ISO product. You will investigate shadow settlements and database-dependent processes in Microsoft SQL Server.

What you will do

• Provide frontline technical support for A2 customers and consultants
• Escalate tier 3 cases with clear diagnostic evidence
• Build and maintain strong client relationships
• Collaborate with Software Development, Implementation/Delivery, and Product Management to reproduce A2 issues
• Analyze A2 data and job status in Microsoft SQL Server
• Troubleshoot and optimize complex T-SQL stored procedures for A2 shadow settlements, allocations and transmission profit and loss

Required qualifications

• 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
• Explain technical concepts to non-technical audiences

Nice to have

• Microsoft Power BI
• Azure Cloud
• Azure DevOps
• CI/CD pipelines for deploying microservices to Azure Kubernetes Service (AKS)
• Computer Science or Engineering background
• Power Settlements Knowledge
• Microsoft Azure Ecosystem knowledge
• Energy Power Market Knowledge

About the company

Energy Exemplar's mission is Empowering Transformative Energy Decisions. Founded in 1999 in Adelaide, Australia, they provide a software portfolio including PLEXOS, Aurora, and Adapt2.