Business Intelligence Analyst (Remote)

Collective Residential; Colombia; Remote; COP 178,353,000 - 312,118,000; Part time

Benefits offered by this job

Competitive hourly rate

Flexible schedule

USD payments

Job summary

Collective Residential seeks a data validation contractor to act as the liaison between portfolio operations and UDP, ensuring accuracy of metrics and formulas across PMS integrations. You will validate outputs, rebuild dashboards, and rollout automated reporting while preserving NDA compliance.

The role requires property management background, experience validating BI metrics, and strong attention to detail. Flexible scheduling and USD payment terms apply, with some US-hours overlap.

Qualifications

• Must have prior property management experience.
• Experience validating metrics and formulas in a BI or reporting platform.
• Experience building reports or dashboards in a BI tool (Power BI or Tableau).
• Solid understanding of property management operations and metrics.
• Working knowledge of PMS systems (Yardi, RealPage, AppFolio, Entrata).

Responsibilities

• Validate metrics, formulas, and calculated fields in UDP against source data.
• Cross-reference UDP figures against PMS data to confirm accuracy.
• Identify discrepancies and document them clearly for follow-up.
• Track existing issues and maintain an up-to-date issue log.
• Work with the UDP team to communicate problems and confirm fixes.
• Apply property management knowledge to judge whether figures look right.
• Rebuild dashboards and reports in UDP.
• Roll out reports and dashboards as automated deliveries.
• Support reporting design projects by surfacing key metrics and visualizing data.
• Maintain confidentiality of all company data per NDA.

Skills

Property management experience

BI validation

Dashboard reporting

Attention to detail

Vendor coordination

Cross-functional communication

Tools

Power BI

Tableau

Yardi

RealPage

AppFolio

Entrata

Job description

Supports Collective Residential's portfolio operations team by validating metrics and formulas in UDP, our consolidated BI platform, tracking open data issues through to resolution with the UDP team, cross-referencing figures against source data in our property management systems (PMS), and building out new and improved reporting and dashboards in UDP.

Responsibilities

• Validate metrics, formulas, and calculated fields in UDP against source data and expected outputs.
• Cross-reference UDP figures against PMS data (Yardi, RealPage, AppFolio, Entrata) to confirm accuracy.
• Identify discrepancies, broken formulas, or mismatched metrics and document them clearly for follow-up.
• Track existing known issues and their status through to resolution, maintaining an up-to-date issue log.
• Work directly with the UDP team to communicate problems, provide supporting detail, and confirm fixes.
• Apply property management knowledge (occupancy, delinquency, turnover, NOI) to judge whether figures look right.
• Rebuild existing dashboards and reports in UDP.
• Roll out reports and dashboards out as automated, scheduled deliveries.
• Support reporting design projects, identifying key metrics to surface and identifying the best way to visualize and show the data.
• Maintain confidentiality of all company and portfolio data per NDA.

• Previous experience in Property Management or similar industries is a must!
• Experience validating metrics and formulas in a BI or reporting platform, not just viewing dashboards.
• Experience building reports or dashboards in a BI tool (Power BI, Tableau, or similar).
• Solid understanding of property management operations and metrics.
• Working knowledge of at least one major PMS (Yardi, RealPage, AppFolio, or Entrata); multiple is a plus.
• Strong attention to detail, able to spot when a number or formula looks wrong.
• Comfortable tracking multiple open issues to resolution.
• Clear written communication for documenting issues and vendor coordination.
• Reliable internet and own equipment.
• Some overlap with U.S. business hours will be required.

• Contractor Agreement; payments in USD.
• Competitive hourly rate.
• Flexible schedule.