Systems & Automation Analyst
Summary
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.
- Alteryx experience.
- 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. Employee benefits include Medical/Dental Benefits, Paid time off, Paid Holidays, and 401(k). H1-B Visa sponsorship is not available for this position. No third-parties, please.
#LI-BH1