Yardi Database Analyst

This is a fully remote position, open to applicants in Philippines.

📋 Description

• Writing, optimizing, and troubleshooting SQL queries and stored procedures utilizing the Yardi database for reporting, data validation, and ad-hoc analysis.

• Designing, constructing, and maintaining Power BI dashboards and reports to track operational, leasing, and financial KPIs.

• Developing sophisticated Excel models, pivot tables, and reconciliations to assist with month-end closing, audits, and recurring reporting.

• Collaborating with the Database Administrator on data integrity assessments, performance optimization, and regular database maintenance.

• Converting accounting, operations, and leadership requirements into technical specifications and deliverables.

• Investigating and documenting data inconsistencies across Yardi modules (GL, AP, AR, lease administration) and recommending solutions.

• Documenting queries, reports, data sources, and processes to guarantee repeatability and auditability.

• Assisting with user training and addressing internal reporting inquiries.

⛳️ Requirements

• Bachelor’s degree in Information Systems, Accounting, Finance, Computer Science, or a related field (or equivalent professional experience).

• Over 3 years of relevant experience in Yardi, SQL, BI, or reporting-focused positions.

• Practical experience with Yardi Voyager across GL, AP, AR, and lease administration modules.

• Intermediate-to-advanced SQL proficiency, including joins, subqueries, aggregations, window functions, and stored procedures.

• Experience in creating dashboards in Power BI, encompassing data modeling and DAX.

• Advanced skills in Microsoft Excel, particularly with pivot tables and Power Query.

• Familiarity with accounting fundamentals, including GL structure, debits/credits, accruals, P&L, and balance sheet.

• Full professional proficiency in English (both written and spoken).

• Authorized to work in the Philippines.

• Availability to work and overlap standard business hours in GMT.

🏝️ Benefits

• Permanent remote work opportunities.

• Paid Holidays and Paid Time Off (PTO).

• Flexible part-time or full-time positions to suit your availability.

• Bonuses for performance, tenure, and health & wellness.

• Opportunities for professional growth within the Assistantly community.

• Join a vibrant and supportive community of Unicorns.