Yardi Database Analyst

Descripción del puesto

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 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 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

Más ofertas de Assistantly