Process Improvement and Automation Analyst

Position overview

Responsibilities

• Assess workflows, record 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 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 that highlight metrics, trends, risks, decisions, and recommended actions.
• Deliver user-friendly interfaces compatible with approved Army IT environments, Microsoft 365, and standard web browsers; do not use unauthorized third-party software.
• Test functionality, accuracy, and usability; resolve validated issues; and provide user guides, application support, and training for approximately four users.
• Manage approximately 12 concurrent monthly reporting requirements, or 144 reports annually, and measure progress toward a potential 20% reduction in targeted processing time over 12 months.

Required qualifications

• Bachelor’s degree from an accredited college or university and an 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.

Location and work arrangement

• The position is 100% on-site at Redstone Arsenal.

Conditions of employment