Database Architect

JSM Consulting Inc.; City of Albany (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

JSM Consulting Inc. in the United States is seeking an experienced enterprise automation leader to design, develop, and support large-scale automation programs using RPA, workflow orchestration, and data integration.

The role requires guiding cross-functional teams, performing design reviews, and mentoring analysts and developers while ensuring compliance and system reliability across complex environments.

Job description

Experience 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 Including Business Analysts, Developers, And Architecture Teams Implementing Enterprise Automation And System-integration Solutions Within 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.