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.

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