Automation Analyst

A.I.M. Mutual Insurance Companies•Burlington, MA

11d•$85,000 - $95,000•Hybrid

About The Position

The Automation Analyst designs, develops, supports, and maintains automated business processes and related applications to improve organizational operational efficiency. The position focuses on workflow automation, SQL development, application support, data management, and system optimization, collaborating with business users, IT team members, and external vendors to deliver scalable, reliable, and secure technology solutions. Under general supervision, the analyst identifies opportunities to improve business processes through automation and technology. The role develops and maintains workflow automation, supports C#-based applications, and provides SQL development and reporting support. Work is performed from functional requirements and technical specifications, in coordination with the IT Applications team and business stakeholders. This position has no supervisory responsibilities. This is a full-time hybrid position based in Burlington, Massachusetts. After an initial in-person training period, the employee is expected to work in the office at least two days per week. The typical work week is 35 hours, Monday through Friday, 8:00 AM to 4:00 PM; occasional weekend hours and local travel during the business day may be required.

Requirements

Experience with Microsoft Power Automate or similar workflow automation platforms.
Experience with Microsoft SQL Server and Visual Studio.
Experience in C#, .NET, or other object-oriented languages.
Experience with technical writing and process documentation.

Nice To Haves

At least 3 to 5 years of automation experience is preferred.
Insurance industry experience or knowledge is preferred.

Responsibilities

Design, develop, implement, and maintain automated business processes and workflows.
Use Microsoft Power Automate and related technologies to streamline business operations.
Test, troubleshoot, debug, and optimize automated workflows and applications.
Develop and maintain SQL queries, stored procedures, views, scripts, and data integration routines for automation, reporting, and business requirements.
Support and enhance existing applications and automated processes developed in C# and .NET.
Analyze, manipulate, and validate large data sets for operational and reporting needs.
Provide technical support for reporting solutions using SQL Server and relational database technologies.
Respond to support tickets and user requests in a timely and professional manner.
Collaborate with external vendors and software providers on enhancements, upgrades, defect resolution, and technical troubleshooting.
Ensure vendor-developed solutions comply with organizational standards, development best practices, and security requirements.
Analyze system defects, identify root causes, and implement corrective actions.
Document processes, technical specifications, solutions, and procedures.