Job Title: Business Process Analyst Power Platform Automation Developer
Location: O'Fallon, MO
Type: W2 Contract
***Only qualified Senior Analyst, Business Process Improvement candidates located near O'Fallon, MO to be considered due to the position requiring an onsite presence. ***
Responsibilities
Process Analysis & Design
- Map current Product Excellence workflows and identify repetitive manual activities.
- Identify opportunities to eliminate manual document creation, email outreach, folder setup, data entry, reminders, and workflow coordination.
- Work with process owners to understand triggers, inputs, business rules, approvals, and expected outputs.
- Design simple future-state workflows that clearly define what should happen automatically and what still requires human judgment.
- Document requirements, process flows, and standard operating procedures.
- Prioritize opportunities based on business value, implementation effort, complexity, and risk.
Automation Development
Design, build, test, and deploy automations using Power Automate, Power Apps, SharePoint, and Microsoft 365.
Examples Include
- Document creation: Automatically generate standardized Word, PowerPoint, Excel, PDF, or other business artifacts using information submitted through forms, lists, or workflow triggers.
- Folder and workspace creation: Automatically create SharePoint folders, Teams structures, Evidence Lockers, and associated templates when new work is initiated.
- Email outreach: Automatically generate and send standardized emails based on events, deadlines, approvals, status changes, or predefined outreach campaigns.
- Reminders and follow-ups: Automatically notify owners of outstanding actions, approaching deadlines, missing information, or required validations.
- Approvals and routing: Route requests, documents, or decisions to the appropriate stakeholders and capture resulting approvals or responses.
- Record creation and updates: Automatically create or update SharePoint Lists and other structured records based on workflow activity.
- Artifact management: Create, name, store, organize, and maintain recurring governance and Product Excellence artifacts.
- Cross-platform workflows: Connect Microsoft 365 tools with platforms such as Monday.com where technically appropriate.
Priority Product Excellence Use Cases
Potential Use Cases May Include
- Automatically creating an Evidence Locker, associated folders, templates, and metadata when a new initiative begins.
- Automatically generating standard governance or Product Excellence documents from structured information.
- Automatically sending email requests to owners for validation, approvals, updates, or missing information.
- Automatically following up with stakeholders who have not responded.
- Automatically creating folder structures and collaboration workspaces for new projects, initiatives, or governance activities.
- Automatically generating recurring meeting or governance artifacts.
- Automating Product Council decision tracking and follow-up.
- Automating intake, triage, routing, and status notifications.
- Automating lifecycle reminders and required actions.
- Automating reporting and intelligence workflows.
- Connecting Monday.com activity with relevant SharePoint and Microsoft 365 assets.
- Applying AI-assisted automation where it meaningfully improves document generation, summarization, classification, or routing.