RPA Automation Architect - HBITS-08-14953

Location: Albany, NY 12232 – on-site, long-term engagement (30 months).

About the Role

Provides expert-level design and implementation of automation and data-processing solutions using RPA, RPD, or comparable enterprise automation technologies. Responsibilities include workflow orchestration, data ingestion, and system integration across business processes within a large, complex organization that meets at least two of the following criteria:

• User/Staff Scale: 5,000+ employees or an IT system serving 10,000+ active internal/external users (e.g., citizens, business partners, or staff).
• System Integration Complexity: Integration across five 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: 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 (e.g., state-level agency, federal agency, or multinational corporation) with decentralized business units.

Requirements

• 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 (business analysts, developers, and architecture teams) implementing enterprise automation and system-integration solutions.

Agency: New York State Department of Transportation. Visa sponsorship is not available.