Process Improvement and Automation Analyst

MbSolutions • Huntsville, AL

20h • Onsite

About The Position

The Process Improvement and Automation Analyst will streamline administrative, analytical, and reporting workflows for Army Materiel Command. The analyst identifies practical improvements and develops intuitive automation prototypes, dashboards, and decision-support tools using Microsoft 365, the Microsoft Power Platform, and approved scripting technologies. The position is 100 percent on-site at Redstone Arsenal.

The role includes managing approximately 12 concurrent monthly reporting requirements (144 reports annually) and measuring progress toward a potential aggregate 20% reduction in targeted processing time over 12 months. The analyst will also provide application support, user guides, and training for approximately four users.

Requirements

• Bachelor's degree from an accredited college or university.
• Active Secret security clearance that must be maintained.
• Experience in process improvement, requirements documentation, data analysis, visualization, executive reporting, and automation development.
• Advanced proficiency in Microsoft Office and Power Platform.
• Experience with SharePoint and Teams.
• Demonstrated proficiency in Python, VBA, macros, or comparable approved scripting technologies.
• Knowledge of Agile and Scrum, with experience using Jira and Confluence or equivalent tools.
• Strong communication, user-training, and documentation skills.
• Ability to design tools for nontechnical users and manage competing priorities and deadlines.
• Must obtain and maintain access to applicable government systems and facilities and comply with security, privacy, records-management, information-assurance, and technology-governance requirements.

Responsibilities

• Assess workflows, document baseline processing times, and recommend improvements with projected efficiency gains, risks, dependencies, and implementation considerations.
• Gather stakeholder requirements and maintain development logs covering design, testing, revisions, feedback, and prototype status.
• Build functional prototypes, templates, data-tracking tools, and automated workflows using Excel, Power BI, Power Automate, Power Apps, Python, VBA, and macros.
• Consolidate and validate data; create executive-ready reports and dashboards highlighting key metrics, trends, risks, decisions, and recommended actions.
• Deliver simple, user-friendly interfaces compatible with approved Army IT environments, Microsoft 365, and standard web browsers, without unauthorized third-party software.
• Test functionality, accuracy, and usability; resolve validated issues; provide user guides, application support, and training for approximately four users.
• Manage approximately 12 concurrent monthly reporting requirements and measure progress toward a potential aggregate 20% reduction in targeted processing time over 12 months.

What This Job Offers

• Job Type: Full-time