Reverse-engineer Yardi schema and APIs to document finance entities and processes; reconstruct procure-to-pay and record-to-report flows; model flows into Gold-layer containers; produce source-to-target mappings and data-quality rules; define crosswalk keys with Procore and Oracle P6; steward finance KPI certification; support pipeline development, automated transformation testing, and reconciliation to Yardi system-of-record balances.
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
Hexaware Technologies Chicago, Illinois, USA Office
Chicago, United States, 0
Similar Jobs
Artificial Intelligence • Information Technology • Professional Services • Software • Analytics • Generative AI • Big Data Analytics
Lead design and implementation of an enterprise Databricks lakehouse, build scalable batch and streaming pipelines, enforce governance and CI/CD standards, optimize Spark workloads, operationalize ML with MLflow, manage cloud infrastructure and IaC, and mentor data engineering teams.
Top Skills:
AdlsAWSAzureDatabricksDatabricks Asset BundlesDatabricks WorkflowsDbxDelta LakeDelta Live TablesFeature StoreGCPGcsGitMlflowPhotonPysparkPythonS3ScalaSpark SqlSQLStructured StreamingTerraformUnity Catalog
AdTech • Enterprise Web • Information Technology • Machine Learning • Marketing Tech • Sales
Lead global DSP operations to optimize partner performance, scalability, and supply competitiveness. Build operational frameworks, KPIs, and cross-functional programs; manage a distributed team; drive platform integrations, traffic shaping, identity and exchange optimization to support revenue growth and operational excellence.
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Design interactive reporting and analytics solutions using SQL, Python, and BI tools. Develop AI models on call/chat transcripts, interpret analyses, present actionable insights to business partners, troubleshoot data/reporting issues, document best practices, and coach junior team members while collaborating across cross-functional teams.
Top Skills:
ExcelPower BIPythonSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
