We are seeking an experienced data integration consultant with deep expertise in Microsoft Azure, Power BI, Azure Data Factory, and Yardi Data Connect. The consultant will support the architecture, development, and implementation of a scalable data pipeline and reporting solution tailored for a real estate and property management business. About Us: Al Rafay Consulting is a Microsoft-certified solutions provider specializing in real estate data automation, business intelligence, and AI-driven insights. We are working with some of the top names in the industry to modernize their data stack and integrate property management platforms like Yardi. Project Scope & Objectives: Integrate Yardi Voyager or Yardi Breeze Premier data with Microsoft Azure services using Yardi Data Connect (YDC). Design and implement Azure Data Factory pipelines to extract, transform, and load Yardi data into a centralized data warehouse (Azure SQL/Data Lake). Develop dynamic, role-based Power BI dashboards and reports for operations, leasing, finance, and asset management stakeholders. Ensure proper data governance, security, and scalability. Provide consultation on Yardi SIPP specifications and help align integration with best practices. Troubleshoot API connections and data syncing issues, and support UAT for data validation and reporting accuracy. Required Skills & Experience: Proven hands-on experience with: - Microsoft Azure (Data Lake, SQL Database, Azure Functions, Azure AD) - Azure Data Factory (ADF) - Power BI (DAX, data modeling, role-based access) - Yardi Data Connect (YDC) and familiarity with Yardi's web services & APIs Strong knowledge of ETL/ELT practices and data pipeline design Experience working with real estate data, lease abstraction, unit-level metrics, financials, and property operations Ability to interpret Yardi database schema or SIPP documentation Strong communication skills and ability to collaborate across technical and non-technical stakeholders Deliverables: Fully functional and tested Azure Data Factory pipelines connected to Yardi Power BI dashboards tailored to business needs with drill-down capabilities Technical documentation for data integration workflows Recommendations for performance optimization and long-term scalability Support for knowledge transfer and handover to internal IT/BI teams Engagement Details: Project Duration: 1 month Location: Remote (must be available during US business hours) Commitment: Part-time to full-time, based on availability and deliverables To Apply: Please include: - A brief overview of your experience with Yardi and Microsoft Azure - Sample Power BI dashboards or integration architecture (if available) - References or Upwork history with similar projects (if applicable)
Keyword: Business Consulting
Price: $70.0
Microsoft Power BI Data Modeling Data Visualization Microsoft Azure Microsoft Azure SQL Database
We are a consulting firm with about 170 employees in multiple cities within the US and we are seeking a Denver based corporate headshot photographer. We will be using other photographers in various other cities where our other offices are located and we really need all ...
View JobWe’re an AI SaaS startup seeking a US-based freelancer to support VC outreach during our A-round fundraising. Ideal candidates have experience in investment banking, VC, consulting PE team, or investor relations, etc., and have resources to engage early-stage investors ...
View JobI am seeking an experienced QuickBooks Bookkeeper to manage the financial records of interconnected entities. The ideal candidate will have a strong background in enterprise-level bookkeeping, ensuring accuracy and compliance across all accounts. Responsibilities includ...
View Job