Data Automation Analyst – AI & Process Improvement

Responsibilities

• Review existing processes, identify automation opportunities, and measure potential time savings and error reduction
• Design, test, implement, and maintain automations using tools such as Microsoft Power Automate, Copilot, Python, SQL, Excel/Power Query, and robotic process automation platforms
• Start with correspondence review, critical-status tracking, and audit data gathering, then expand improvements across other departments
• Extract, transform, and validate data from AS400/IBM i and other business systems
• Create reports and dashboards to track audit activity and automation results
• Document workflows, write standard operating procedures, and train employees on new processes
• Follow CMS security, compliance, and approved AI-use requirements, including appropriate controls, audit trails, and human review of AI output
• Gather data and documentation for customer and client audits
• Review IT controls and communication issues and assist with daily departmental audits
• Review and catalog incoming correspondence and agent critical statuses
• Complete daily client maintenance in AS400 related to audit requirements
• Protect the confidentiality of consumer and client information

Preferred

• AS400/IBM i experience; training is available
• Experience with Power BI and Python
• A background in collections, financial services, or another regulated industry

Benefits

• Consistent weekday schedule.
• The opportunity to apply AI and automation to real business challenges.
• Direct collaboration with IT leadership and operational teams.
• Accounts receivable management, debt collection, and customer service BPO.
• Buffalo, New York, USA
• http://cms-collect.com
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Marketing
• Trends of Total Sponsorships
• *2025
• (2)
• Growth Stage
• Leadership Team
• Rachael Weiss Small
• Partner/Chief Executive Officer
• Recent News
• Pulse 2.0
• CW Advisors Adds $575 Million In AUM Through Acquisition Of Two Firms
• 2025-09-04
• CW Advisors: $575 Million In AUM Added Through Recent Acquisitions
• 2025-09-02
• ZAWYA
• Sahm Capital among the first batch of companies to participate in transformative Capital Management IPO Project
• 2024-10-20
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter

Qualifications

• A bachelor's degree in Information Technology, Data Analytics, Computer Science, or a related field-or equivalent experience
• At least two years of hands-on experience automating business processes using Power Automate, UiPath, Python, or similar tools
• Practical experience using AI tools such as Microsoft Copilot, ChatGPT, or other generative AI platforms, including writing prompts and validating results
• Strong Excel skills, including formulas, pivot tables, and Power Query
• Working knowledge of SQL and Microsoft Access, plus proficiency with Word and Outlook
• Strong problem-solving, organization, and communication skills
• The ability to manage projects day to day and explain technical changes clearly to nontechnical employees
• Sound judgment when handling confidential information
• Typing ability of at least 55 words per minute with 80% accuracy
• AS400/IBM i experience; training is available
• Experience with Power BI and Python
• A background in collections, financial services, or another regulated industry
• At least two years of hands-on experience automating business processes using Power Automate, UiPath, Python, or similar tools.

Required skills

• AS400/IBM i, Business Process Automation, ChatGPT, Microsoft Access, Microsoft Copilot, Microsoft Power Automate, Power Query, Prompt Engineering, Python, SQL, UiPath

Preferred skills

• AS400/IBM i experience; training is available, Experience with Power BI and Python

Experience

• 2+ years