> Markdown version of [/jobs/ext/2249303-rpa-rpd-enterprise-automation](https://www.wearedevelopers.com/jobs/ext/2249303-rpa-rpd-enterprise-automation). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # RPA/RPD & Enterprise Automation - **Company:** VGroup inc - **Location:** Albany, NY, United States (Remote available) - **Experience:** Expert - **Salary:** $145,600.0 - **Contract:** Temporary to permanent - **Skills:** Application Programming Interfaces (APIs), Audit Trail, Code Review, Databases, Extract Transform Load (ETL), Data Transformation, Data Warehousing, Software Debugging, File Systems, Performance Tuning, Software Requirements Analysis, System Testing, Systems Integration, Transaction Data, Web Services, Workflow Management Systems, Data Logging, Data Processing, Enterprise Software Applications, Data Ingestion, Analytic Functions, Physical Data Models - **Published:** August 26, 2026 - **Apply:** https://www.careerjet.com/jobad/us42471a10316504848776c50bda1b00de ## About the Role 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. 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. 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. 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 implementing enterprise automation and system-integration solutions within a large and complex organization. Experience working in environments involving large-scale users or systems, complex enterprise integrations, high-volume data processing, regulated/security-sensitive environments, or multi-divisional organizations. ## Description The New York State Department of Transportation (NYS DOT) is seeking an Expert Database Architect to design and implement enterprise automation and data-processing solutions using RPA, RPD, or comparable enterprise automation technologies. The selected consultant will support workflow orchestration, data ingestion, transformation, system integration, data quality, and automation initiatives across complex enterprise environments. The consultant will analyze business processes, develop automation solutions, integrate enterprise systems, provide technical leadership, and support testing, deployment, troubleshooting, and ongoing maintenance. Responsibilities:- The selected consultant will perform, but not be limited to, the following activities: Analyze business processes and system workflows to identify opportunities for automation and optimization. Design, develop, and implement RPD/RPA-based automation solutions for data ingestion, transformation, and system integration. Build and maintain automated workflows and orchestration pipelines across enterprise databases, applications, storage systems, and APIs. Integrate RPD/RPA solutions with databases, APIs, web services, file systems, enterprise applications, and external systems. Design and implement automation controls including exception handling, validation, logging, monitoring, alerting, audit trails, recovery, and reconciliation. Develop and maintain data-processing solutions including ETL/ELT, data ingestion, data transformation, workflow orchestration, scheduling, and data-quality controls. Monitor, troubleshoot, and optimize automation processes for performance, reliability, and scalability. Implement error handling, retry mechanisms, logging, and recovery processes within automated workflows. Create processes to maintain data quality and high accessibility. Design and document all components of approved application solutions, including system integrations. Write readable and testable code using advanced analytical functions. Review and refactor existing code, perform performance tuning, conduct code reviews, and recommend improvements aligned with agency and business needs. Collaborate with business analysts, developers, and architecture teams to ensure solutions align with enterprise standards. Manage the build phase and ensure quality-assured code fulfills requirements and adheres to Enterprise Architecture standards. Support system testing, debugging, deployment, and ongoing maintenance of automation solutions across environments. Develop and maintain technical documentation for automation workflows, configurations, processes, and system integrations. Provide technical leadership, architecture guidance, design reviews, and mentoring to cross-functional teams. Evaluate and recommend improvements to automation frameworks, tools, and implementation patterns. Provide database support by coding utilities, responding to user questions, and resolving database-related problems. ## Related Videos - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Resilient by Design: Building Robust Architectures in High-Stakes Financial Systems](https://www.wearedevelopers.com/videos/2106-resilient-by-design-building-robust-architectures-in-high-stakes-financial-systems) - [Are Code Reviews Worth It? Insights from 16 Years of Review Data](https://www.wearedevelopers.com/videos/1135-are-code-reviews-worth-it-insights-from-16-years-of-review-data) - [RPA in the Public Sector](https://www.wearedevelopers.com/videos/86-rpa-in-the-public-sector) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [RPA crash course for .Net developers – intro into the world of RPA from the perspective of a .Net developer](https://www.wearedevelopers.com/videos/271-rpa-crash-course-for-net-developers-intro-into-the-world-of-rpa-from-the-perspective-of-a-net-developer) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [The Top ChatGPT Plugins for Developers in 2023](https://www.wearedevelopers.com/magazine/259-the-top-chatgpt-plugins-for-developers-in-2023) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [13 AI Tools for Developers](https://www.wearedevelopers.com/magazine/302-13-ai-tools-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)