RPA Automation Architect

Location: Albany, New York

Duration: 30 months (100% onsite)

About the role

Provides expert-level design and implementation of automation and data processing solutions using RPD, RPA or comparable enterprise automation technologies, supporting workflow orchestration, data ingestion, and system integration across business processes.

Responsibilities

• Analyze business processes and system workflows to identify opportunities for automation and optimization
• Design, develop, and implement RPD-based automation solutions for data ingestion, transformation, and system integration
• Build and maintain automated workflows and orchestration pipelines across multiple enterprise databases, applications, storage systems and APIs
• Integrate RPD / RPA solutions with databases, APIs, file systems, and enterprise applications
• Monitor, troubleshoot, and optimize automation processes for performance, reliability, and scalability
• Implement error handling, logging, retry mechanisms, and recovery processes within automated workflows
• Evaluate and recommend improvements to automation frameworks, tools, and implementation patterns
• Collaborate with business analysts, developers, and architecture teams to ensure solutions align with enterprise standards
• Develop and maintain technical documentation for automation workflows, configurations, and processes
• Manage build phase and quality assured code to ensure fulfilling requirements and adhering to Enterprise Architecture
• Create processes to maintain data quality and high accessibility
• Design and document all components of approved application solutions including system integrations
• Write readable, testable code using advanced analytical functions
• Review and refactor code including, but not limited to: performance tuning of existing code, code reviews, and suggest changes that will best fit the Agency/business needs
• Support testing, debugging, deployment, and ongoing maintenance of automation solutions across environments and documentation including, but not limited to: perform system testing and development of testing plans

Requirements

• 15+ years of overall IT experience
• 84 months of experience designing, developing, implementing, and supporting enterprise automation solutions using RPA, RPD, or comparable enterprise automation technologies, including reusable workflows, components, and business processes
• 84 months of experience analyzing business processes and translating business, functional, data, and system requirements into enterprise automation designs and technical solutions
• 72 months of experience integrating enterprise automation solutions with databases, APIs, web services, file-based interfaces, enterprise applications, and external systems
• 72 months of experience designing and implementing automation controls, including exception handling, validation, logging, monitoring, alerting, audit trails, recovery, reconciliation, and operational support
• 60 months of experience developing and maintaining data-processing solutions, including ETL/ELT, data ingestion, data transformation, workflow orchestration, scheduling, and data-quality controls
• 48 months of experience designing and working with enterprise databases and data models, including conceptual, logical, and physical data models, transactional data structures, analytical data structures, and data warehouses
• 36 months of experience providing technical leadership, architecture guidance, design reviews, and mentoring to cross-functional teams including business analysts, developers, and architecture teams implementing enterprise automation and system-integration solutions
• Experience in a large and complex organization environment meeting at least two or three of the following criteria:
  • User/Staff Scale: An organization with 5,000+ employees OR an IT system serving 10,000+ active internal/external users (e.g., citizens, business partners, or staff)
  • System Integration Complexity: An IT environment where solutions must integrate across 5 or more distinct enterprise-level systems (e.g., ERP, CRM, custom databases, mainframe legacy systems, and external APIs)
  • Data & Transaction Volume: Systems processing hundreds of thousands of daily transactions or managing multi-terabyte data environments
  • Regulatory & Security Environment: Organizations operating under strict, audited compliance frameworks such as HIPAA, IRS Publication 1075, PCI-DSS, FedRAMP, or NIST 800-53
  • Geographic or Divisional Scope: A federated or multi-divisional organization (such as a state-level agency, federal agency, or multinational corporation) with decentralized business units

Qualifications

• Copy of candidate identification (e.g., Driver’s License, Green Card, Visa, and Passport if applicable)
• Professional certifications and degrees referenced in the requested qualifications