Solution Architect / Technical Lead – Yardi (ERP)
Location: Denver, CO (Onsite from day 1)
Duration: 6-12 Months
Location: Denver, CO (Onsite from day 1)
Duration: 6-12 Months
NEED LOCAL ONLY
Key responsibilities
- Reverse-engineer the Yardi schema and APIs to document the general ledger, accounts payable, purchase order, invoice, journal, vendor, property and asset entities and their true relationships.
- Reconstruct the procure-to-pay and record-to-report process flows end to end, including the commitment, accrual, and period-close behaviours that determine when a figure becomes reportable.
- Model those flows into Gold-layer business containers linked to the Data Backbone, preserving the process context that raw extracts lose.
- Produce source-to-target mappings from Bronze through Silver to Gold, documenting transformation logic, business rules, reconciliation points and known data-quality defects.
- Define the Yardi contribution to DNA crosswalk keys (Project, Vendor, Cost Code, Asset, Entity) and resolve identifier conflicts against Procore and Oracle P6.
- Define data-quality gates and confidence scoring for finance KPIs and steward them through certification with Finance data owners.
- Support pipeline development, automated transformation testing, and reconciliation of Gold outputs back to Yardi system-of-record balances.
Required qualifications and experience –
- 5+ years hands-on with Yardi (Voyager and/or Elevate) in a data, reporting, integration, or finance-systems capacity.
- Demonstrated ability to reverse-engineer an ERP schema and produce an authoritative business-entity and process model.
- Strong SQL and data-profiling skills against large, complex financial schemas.
- Solid working understanding of core finance processes — procure-to-pay, general ledger, accruals, period close — and the ability to reconcile derived data back to the system of record.
- Experience producing source-to-target mapping specifications and data-quality rules for analytics platforms.
Preferred qualifications
- Experience with Yardi in a real-estate, data centre, or infrastructure operating environment.
- Exposure to medallion / lakehouse architectures (Microsoft Fabric, Azure Databricks, OneLake).
- Familiarity with Microsoft Purview or comparable catalog and lineage tooling.
- Prior finance data-governance or master-data management experience.
Programme deliverables owned
- Yardi entity and process-flow documentation (incl. PO → Journal → Invoice model)
- Yardi source-to-target mapping specification
- Yardi contribution to DNA crosswalk-key definitions
- Finance data-quality rules, KPI definitions and certification evidence
Thanks & Regards,