Automation Specialist​/RPA Developer; Power Platform

We are seeking a technical Automation Specialist / RPA Developer to design, build, and support robotic process automation solutions using the Microsoft Power Platform
, primarily Power Automate and Power Apps
. This role is a contract-to-full-time opportunity
.

The Automation Specialist will work closely with business and IT teams to automate manual, repetitive processes, integrate systems, and improve operational efficiency while adhering to security, audit, and compliance standards typical of financial institutions.

• Design, develop, test, and deploy Power Automate workflows (cloud flows and/or desktop flows) for business-critical processes.
• Build and maintain Power Apps (canvas apps preferred) to support automation-driven workflows, data entry, and approvals.
• Create robust flow logic using conditions, loops, expressions, error handling, and retry patterns.
• Maintain and enhance existing automations to ensure reliability, performance, and scalability.
• Follow secure coding and automation best practices, including environment separation and solution-based deployments where applicable.
• Leverage Microsoft Copilot (or a similar tool) to accelerate automation development, generate workflow logic, and assist with troubleshooting and optimization.

• Integrate Power Automate flows with internal systems, SharePoint, Dataverse, file systems, email, and third-party applications.
• Consume and work with REST APIs
  , including handling authentication, request/response payloads, and JSON data structures.
• Write and optimize SQL queries (preferred) to retrieve, validate, and manipulate data used by automation.
• Perform data validation and reconciliation to ensure automation accuracy and data integrity.

• Analyze existing business processes and document as-is workflows, automation logic, and dependencies.
• Assist in designing future-state automated solutions
  , identifying technical constraints and optimization opportunities.
• Translate business requirements into technical automation designs and implementation plans.
• Estimate effort and complexity for automation requests and contribute to prioritization discussions.

• Implement logging, exception handling, and notifications within automation workflows.
• Monitor automation runs and troubleshoot failures or performance issues.
• Support audits and reviews by providing documentation, run histories, and control evidence.
• Ensure automations align with security, access control, and compliance requirements common to banking environments.
• Document automation logic, configurations, data sources, and operational procedures.
• Collaborate with IT, operations, and business users during development, testing, and post-deployment support.
• Provide basic training or knowledge transfer to users and support teams as needed.

• 1–2 years of hands-on experience in automation, RPA, or Power Platform development.
• Practical experience with Microsoft Power Automate and Power Apps
  .
• Strong understanding of workflow logic, conditional branching, error handling, and automation lifecycle management.
• Experience working with REST APIs
  , JSON
  , and system integrations.
• SQL experience preferred
  , including writing queries for reporting, validation, or automation logic.
• Familiarity with basic IT concepts such as environments, permissions, and change management.
• Strong problem-solving skills and attention to detail.
• Ability to clearly document technical solutions and communicate with both technical and non-technical stakeholders.
• Experience using Microsoft Copilot or similar tool to assist with automation development, workflow creation, and iterative optimization.

• Experience in banking, financial services, or other regulated environments
  .
• Exposure to Power Platform governance, environments, or Dataverse.
• Experience with RPA concepts such as unattended automations, scheduling, and exception queues.
• Understanding of audit controls, data security, or compliance requirements.
• Experience with Copilot Studio or integrating Copilot-enabled experiences into business processes.