RPA Developer

Job Description
About the Role
We are seeking a Robotic Process Automation (RPA) Developer to design, build, and maintain bots that streamline operational, accounting, and reporting workflows across our real estate portfolio. You will automate high-volume tasks in accounts payable, lease administration, compliance, property management operations, and investor reporting—improving accuracy, cycle times, and scalability.

Responsibilities
Key Responsibilities

• Design, develop, test, and deploy attended and unattended RPA workflows using Power Automate Desktop, UiPath or Automation Anywhere.
• Automate end-to-end processes: intake, validation, transformation, system updates, reconciliations, and exception handling.
• Build integrations with real estate systems (e.g., RMS, Costar or Realquest) and corporate tools (ERP, CRM, SharePoint, Outlook, Teams, SQL).
• Implement robust document processing using OCR/IDP (e.g., UiPath Document Understanding) for invoices, lease abstracts, W-9s, and bank statements.
• Create reusable components, libraries, and templates; enforce development standards and code reviews.
• Configure orchestration, scheduling, and monitoring in UiPath Orchestrator/AA Control Room; set up alerting, logging, and dashboards.
• Partner with business stakeholders to assess processes, quantify ROI, and prioritize an automation pipeline; document PDD/SDD and runbooks.
• Ensure security best practices: credential vaults (CyberArk/Azure Key Vault), role-based access, audit logs, and PII handling.
• Support production operations: incident triage, root cause analysis, SLAs, and continuous improvement.
• Collaborate with Data/BI to feed automated outputs into Power BI dashboards and financial reporting packages.

Real Estate–Specific Use Cases You'll Tackle

• Accounts Payable: ingest vendor invoices, 3-way match, post to GL in Yardi/MRI, route exceptions, and reconcile vendor statements.
• Lease Administration: extract key terms from leases/amendments, update critical dates, rent steps, and options; automate abstract QA.
• Bank and Cash: daily bank feed ingestion, cash reconciliation, and variance alerts.
• Resident/Tenant Operations: automate move-in/move-out checklists, delinquency outreach, payment posting, and fee reversals under rules.
• Compliance and Lender Reporting: compile DSCR/LTV metrics, covenant tracking, and package submission with document assembly.
• Data Hygiene: normalize rent rolls, COA mapping, unit and tenant IDs, and address standardization for portfolio reporting.
• Market/Regulatory Monitoring: scrape public records, permits, and property tax updates; notify asset managers of changes.

Qualifications
Required Qualifications

• 3+ years building and deploying RPA solutions with UiPath, Automation Anywhere, or Power Automate Desktop.
• Strong skills in workflow design, selectors, queues, exception handling, retry logic, and parallelization.
• Experience with OCR/IDP and document classification/extraction; supervised learning models for template variability.
• Proficiency with SQL and APIs (REST/JSON); ability to connect bots to databases and enterprise systems.
• Solid understanding of accounting workflows (AP/AR, GL postings, reconciliations) and data validation controls.
• Clear communication and documentation skills; ability to translate business processes into technical specs (PDD/SDD).

Preferred Qualifications

• Experience with real estate platforms (Yardi, MRI, RealPage) and Argus Enterprise exports.
• Power Platform (Power Automate cloud, Power Apps), Power BI, and DAX for reporting handoffs.
• Basic scripting/programming: Python or .NET for custom activities, web scraping, and data transformations.
• Process mining (Celonis, UiPath Process Mining, Power Automate Process Advisor) and task mining for discovery and ROI sizing.
• Familiarity with SOX/internal controls, audit evidence, and secure bot credentialing.

Tools & Tech Stack

• RPA: UiPath, Automation Anywhere, or Power Automate Desktop
• Data: SQL Server/PostgreSQL, Excel/Power Query, SharePoint/OneDrive
• APIs/Integration: REST/JSON, ODBC/ADO, Outlook/Exchange, Teams
• Security: Azure AD, CyberArk/Azure Key Vault, role-based access
• BI/Reporting: Power BI, scheduled refresh, dataflows