# Yardi Database Analyst

> Assistantly · Venezuela, Bolivarian Republic of (Remote) · Full-time · Posted 2026-05-26

**Workplace:** remote

## Description

Assistantly is a leader in recruiting and embedding high-performing remote professionals (“Unicorns”) into client teams, offering ongoing coaching, clear standards, and long-term support. As a Yardi Database Analyst, you will play a pivotal role in supporting growth-stage businesses and leadership teams by delivering actionable insights and robust reporting solutions. You will work closely with a Database Administrator and be embedded within operational and leadership teams to drive data integrity and reporting excellence.  
  
Key responsibilities include:

-   Writing, optimizing, and troubleshooting SQL queries and stored procedures against the Yardi database for reporting, data validation, and ad-hoc analysis
-   Designing, building, and maintaining Power BI dashboards and reports for operational, leasing, and financial KPIs
-   Developing advanced Excel models, pivot tables, and reconciliations to support month-end close, audits, and recurring reporting
-   Partnering with the Database Administrator on data integrity checks, performance tuning, and routine database maintenance
-   Translating accounting, operations, and leadership requirements into technical specifications and deliverables
-   Investigating and documenting data discrepancies across Yardi modules (GL, AP, AR, lease administration) and proposing corrections
-   Documenting queries, reports, data sources, and processes to ensure repeatability and auditability
-   Supporting user training and responding to internal reporting requests

## Requirements

-   Bachelor’s degree in Information Systems, Accounting, Finance, Computer Science, or a related field (or equivalent professional experience)
-   3+ years of relevant experience in Yardi, SQL, BI, or reporting-focused roles
-   Hands-on experience with Yardi Voyager across GL, AP, AR, and lease administration modules
-   Intermediate-to-advanced proficiency in SQL, including joins, subqueries, aggregations, window functions, and stored procedures
-   Experience building dashboards in Power BI, including data modeling and DAX
-   Advanced proficiency with Microsoft Excel, including pivot tables and Power Query
-   Working knowledge of accounting fundamentals, including GL structure, debits/credits, accruals, P&L, and balance sheet
-   Full professional fluency in English (written and spoken)
-   Authorized to work in the Philippines
-   Availability to work and overlap standard business hours in GMT

## Benefits

-   Permanent work-from-home opportunities
-   Paid Holidays and PTO
-   Part-time or Full-time positions tailored to your availability
-   Performance, Tenure, and Health & Wellness bonuses
-   Opportunities for professional development within the Assistantly community
-   Be part of a vibrant and supportive community of Unicorns

## Apply

[Apply at Assistantly](https://apply.workable.com/assistantly/j/807C7E74A6/apply)

---
Powered by [Workable](https://www.workable.com)