Systems & Automation Analyst

TriCom Technical Services, Inc.; Kansas City (MO); Remote; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical/Dental Benefits

Paid time off

Paid Holidays

401(k)

Job summary

TriCom Technical Services, Inc. seeks a Systems & Automation Analyst to design and build automation and AI-driven solutions that cut manual work, improve data quality, and scale service delivery. You will work hands-on across Power Platform, Copilot, Python, and Alteryx with cross-functional teams.

This remote, direct-hire role supports a Kansas City, MO client. Benefits include Medical/Dental, PTO, Holidays, and 401(k).

Qualifications

• 5+ years in workflow automation and BI.
• Hands-on with Power Platform and AI productivity tools.
• Experience with Copilot or similar AI tools.
• Knowledge of data structures and storage (Azure tables, SQL, JSON).
• Experience building automation workflows, bots, or AI agents.
• Experience presenting to leadership.

Responsibilities

• Identify manual workflows and replace with Power Automate, Power Apps, and M365.
• Build AI-assisted workflows and agents for intake, triage, summarization, and reporting.
• Serve as Copilot SME across Excel, Outlook, Teams, SharePoint, Power BI.
• Use Python to automate data transformations.
• Integrate Alteryx, Power BI, and Microsoft data sources into reporting pipelines.
• Present to leadership and senior management.
• Influence decisions as a key stakeholder.

Skills

Power Platform

Automation/BI

Python

Copilot AI

Data structures

Tools

Power Automate

Power Apps

Power BI

Azure SQL

JSON

Job description

Systems & Automation Analyst

Our client is seeking a Systems & Automation Analyst to support an absence management practice within a large insurance brokerage. This analyst will design and build automation and AI-driven solutions that cut manual work, improve data quality, and scale service delivery. This is a hands-on technical role working across Power Platform, Copilot, Python, and Alteryx; partnering closely with consultants, operations, analytics, and technology teams.

Responsibilities

• Identify manual, repetitive workflows and replace them with Power Automate, Power Apps, and M365 solutions.
• Build AI-assisted workflows and agents for intake, triage, summarization, and reporting.
• Serve as the Copilot SME, developing use cases across Excel, Outlook, Teams, SharePoint, and Power BI.
• Use Python to automate data transformations and replace spreadsheet-driven processes.
• Integrate Alteryx, Power BI, and Microsoft data sources into automated reporting pipelines.
• Presenting to leadership and senior management.
• Be influential and decision maker.

Requirements

• 5+ years of workflow automation and BI experience.
• Hands-on experience with Power Platform (Power Automate, Power Apps, Power BI).
• Hands-on experience with Microsoft Copilot or similar AI productivity tools.
• Working knowledge of data structures and storage (Azure tables, SQL, JSON).
• Experience building automation workflows, bots, or AI agents.
• Experience with presenting Leadership and Senior Leaders.
• Demonstrate ability to make decisions and be influential.

Preferred

• Experience using Python for operational or consulting analytics.
• Background in insurance, benefits, HR operations, consulting, or professional services.
• Strong communication skills and ability to translate business needs into technical solutions.

This is a remote, Direct-Hire opportunity with our Kansas City, MO client.

• Medical/Dental Benefits
• Paid time off
• Paid Holidays
• 401(k)

H1-B Visa sponsorship is not available for this position. No third-parties, please.