Yardi Database Analyst

2 hours, 23 minutes ago
Assistantly

Assistantly

Assistantly is a 360º solution that helps businesses find, hire, manage, and support top talent from the Philippines and Latin America. They offer services in outsourcing, offshoring consulting, virtual assistants, marketing, social media management, s...

Professional Services
51-250
Founded 2020

Description

  • Write, optimize, and troubleshoot SQL queries and stored procedures against the Yardi database for reporting, validation, and ad hoc analysis.
  • Design, build, and maintain Power BI dashboards and reports for operational, leasing, and financial KPIs.
  • Develop advanced Excel models, pivot tables, and reconciliations to support month-end close, audits, and recurring reporting.
  • Partner with the Database Administrator on data integrity checks, performance tuning, and routine database maintenance.
  • Translate accounting, operations, and leadership requirements into technical specifications and deliverables.
  • Investigate and document data discrepancies across Yardi modules, including GL, AP, AR, and lease administration.
  • Propose corrections and improvements to address data issues and strengthen reporting accuracy.
  • Document queries, reports, data sources, and processes to ensure repeatability and auditability.
  • Support user training and respond 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.
  • A vibrant and supportive community of Unicorns.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Database Administrator (DBA)

Sleek 251-1K Professional Services

Sleek is hiring an experienced Database Administrator to own and optimize its production database platform across multiple engines and AWS services in support of business-critical workloads for a fast-growing, tech-enabled company.

AWS Bash CI/CD CloudFormation Docker DynamoDB Elasticsearch Grafana Kubernetes MariaDB MongoDB MySQL PostgreSQL Prometheus Python Redis Secrets Management SQL Terraform
1 hour, 37 minutes ago

Senior Analyst Advanced Analytics

Airbnb 5K-10K Hotels, Restaurants & Leisure

Airbnb is seeking a Senior Analyst, Advanced Analytics to support the Airbnb for RealEstate team in expanding hosting within multifamily buildings through data-driven measurement, experimentation, and cross-functional decision support.

Apache Spark Hive Presto Python R SQL Tableau
2 hours ago

Marketing Analytics and Insights Developer

JeffreyM Consulting 251-1K Professional Services

Marketing Analytics and Insights Developer for a tech client to partner with global marketing teams on building dashboards, reporting, and analysis that improve data-driven decision-making and growth planning.

Python Salesforce SQL Tableau
2 hours, 38 minutes ago

Manager, Analytics

WorkMoney 11-50 Diversified Consumer Services

WorkMoney, Inc. is hiring a remote Manager, Analytics to lead project-based analytics work that strengthens impact measurement, informs organizational decisions, and improves how teams use data to support mission-driven goals.

AWS dbt GCP Looker SQL Tableau
2 hours, 38 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers