Yardi Database Analyst

Assistantly

Yardi Database Analyst delivering actionable insights and reporting solutions for growth-stage businesses. Collaborating with Database Administrators and leadership teams to drive data integrity and excellence.

Posted 5/26/2026full-timeRemote • 🇵🇭 PhilippinesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

- 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

What you’ll need

- 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

Comp & perks

- 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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPower BIExcelDAXdata modelingstored procedurespivot tablesdata validationdata discrepanciesperformance tuning

Soft Skills

communicationproblem-solvingcollaborationdocumentationuser training