Operations and Platform Automation Specialist

Fragomen; Phoenix (AZ); On-site; USD 52,000 - 80,000; Full time

Job summary

Fragomen is seeking an Operations & Automation Specialist to organize and run a portfolio of cross-office operations, initially manual and then automated using Power Platform solutions. The role will automate trackers, alerts, and data flows, while maintaining governance and documentation across the stack.

You will build Power Automate flows and Power Apps dashboards, manage SharePoint lists, and train users, under the direction of the Program Management Director, delivering the next wave of

Qualifications

• 1-2 years of professional experience with demonstrated Power Platform delivery.
• Proficiency in Power Automate, SharePoint Lists, Power Apps, Excel/Power Query.
• Strong familiarity with the Microsoft 365 stack (Teams, Outlook, Planner, Loop).
• Ability to translate operational pain points into automated solutions and document them for long-term sustainability.
• Highly organized and detail-oriented, with a passion for process standardization and managing multiple trackers, projects, and SLAs simultaneously.
• Excellent written and verbal communication; ability to engage internal stakeholders, partners, onsite teams, and colleagues with equal ease.

Responsibilities

• Own end-to-end management and review of cross-office operations, including original documents inventory, escalation tracking, and recurring log reviews.
• Maintain account trackers, checklists, and SharePoint resources with consistent version control; ensure data integrity and SLA adherence.
• Automate the operations using Power Automate flows and build Power Apps and SharePoint List solutions for intake forms, tracker front-ends, and dashboards.
• Provide light user training and connect into firm-wide automation and AI initiatives.

Skills

Power Automate

Power Apps

SharePoint Lists

Excel/Power Query

Microsoft 365

Governance

SLA tracking

Stakeholder comms

Job description

Job Description

Operations & Automation Specialist

Reports to: Program Management Director

Experience level: 1-2 years

Join the Program Management Team to organize and run a portfolio of cross-office operationson the account-first by managing them manually, then by automating them through Power Platform solutions. Once an operation is automated, the role keeps the momentum going byidentifyingand delivering the next wave of automation opportunities across the account.

Current in-scope operations include the inventory of original documents, escalation tracking, and identification and tracking of operational flow failures, with more addedover time.

Key Responsibilities

1. Account Operations & Trackers

• Own end-to-end management and review of cross-office operations-including the original documents inventory, escalation tracking, operational flow failure identification and tracking, and recurring logreviews.

• Maintain account trackers, checklists, and SharePoint resources with consistent version control; ensure data integrity, SLA adherence, and that process guides and QRGs stay current.

2. Power Platform & Automation

• Automate the operations above using Power Automate flows - auto-updating trackers, triggering notifications (reminders, SLA alerts, expirations), andeliminatingmanual data re-entryacross various platforms.

• Build Power Apps and SharePoint List solutions for intake forms, trackerfront-ends, and dashboards.

• Maintain documentation, governance, and version control; provide light user training.

• Connect into firm-wide automation and AI initiatives.

• Under the direction of the Program Management Director,identifyand deliver the next wave of automation opportunities across the account.

Required Qualifications

• 1-2 years of professional experience withdemonstratedPower Platform delivery.

• Power Platformproficiency:

• Power Automate (cloud flows, scheduled flows, approvals, error handling, connectors)

• SharePoint Lists / Online as a structured data backbone

• Power Apps

• Excel / Power Query

• Strong familiarity with the Microsoft 365 stack (Teams, Outlook, Planner, Loop).

• Ability to translate operational pain points into automated solutions and document them for long-term sustainability.

• Highly organized and detail-oriented, with a passion for process standardization and managing multiple trackers, projects, and SLAs simultaneously.

• Excellent written and verbal communication; abilityto engage internal stakeholders, partners, onsite teams, and colleagues with equal ease.

All offers and/or employment contracts are contingent upon the successful completion of the Firm’s pre-employment screening process. This process may include verifying the candidate’s identity, confirming legal authorization to work in the offered position’s location, and conducting a comprehensive background check, where permitted by local regulations. We use limited AI-assisted tools for administrative screening purposes only - never for decision-making. All hiring decisions are made by people. Applicants may have rights to information and explanations regarding the use of such tools, or request human review, as required by applicable regional laws.