RPA Developer

Job Title - RPA Developer - Real Estate Operations, Finance, and Reporting

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 reportingimproving accuracy, cycle times, and scalability.

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 EstateSpecific Use Cases Youll 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.

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

Work Arrangement :

- Location : On-site and hybrid.

- Employment Type : Full-time.

Interview Process :

- Recruiter/HR screening focused on experience and project outcomes.

- Technical assessment : build or review a small bot, selectors, exception handling, and IDP extraction.

- Panel interview with Operations for process design and stakeholder management.