Application Support Engineer

The scope of this role includes, but is not limited to:

• Analyzing and resolving data issues in a complex database environment
• Writing SQL queries for reporting, and stored procedures for automation
• Automating repetitive tasks via scripting, or innovating effective tools
• Diagnosing issues via logging tools, and reproducing in lower environments
• Using company training resources to build the insurance domain knowledge, application expertise, and technical understanding needed to support customers effectively
• Recreating, analyzing, troubleshooting, and diagnosing customer-reported questions and issues
• Assisting development teams and business teams with root cause analysis and solution development for recurring issues
• Maintaining consistent communication with customers regarding open issues and responding promptly to follow-up inquiries
• Performing routine system audits to support preventative application maintenance and reporting on system status
• Running processes after hours to support batching and/or month-end processing as required.

• Advanced knowledge of SQL, including joins, CTEs, and window functions
• Proven ability to write complex SQL queries from scratch
• Experience performing SQL updates in production environments
• Experience with at least one major programming language such as C#, Python, or Java
• Proven experience writing and maintaining stored procedures
• Strong technical troubleshooting skills
• Ability to adapt in a complex, fast-paced environment
• Ability to multitask and prioritize effectively while remaining composed in a customer-facing environment
• Strong written and verbal communication skills in English, including email and phone communication
• Ability to continuously gather, assess, and classify information
• Strong reasoning and decision-making skills, with the ability to analyze, interpret, and prioritize information logically
• Ability to follow direction and consistently adhere to established procedures

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, Physics, Electrical Engineering, or a related field, or equivalent professional experience