Real Estate Data Analyst
Microsoft · Washington, United States · 1d ago
Global Workplace Services (GWS) plans, delivers, and operates Microsoft's global real estate portfolio of approximately 40 million square feet (SF). Trusted data is the foundation for how GWS monitors performance, plans its portfolio, and makes enterprise real estate decisions, and that foundation is only as reliable as the cleanliness and integrity of the data behind it.
The Real Estate Data Analyst is the accountable owner of the day-to-day data-management and data-quality function for the GWS real estate portfolio, consolidating the hands-on data cleanliness, validation, reference-data, and single-source-of-truth work into one role, with supporting analytics and reporting as a secondary component. It executes against the analytics standards defined by the Portfolio Strategy, Transactions & Analytics lead, while data-foundation strategy and architecture sit with GWS Platforms leadership.
Responsibilities
Data Governance – Collection, Cleanliness, & Validation
- Own and run the data validation framework across GWS real estate data: attendance & headcount data and forecasts; audit, map, and clean up portfolio, projects, buildings, lease, and space records across source systems, and reconcile discrepancies to a single source of truth.
- Maintain business reference values and mappings for Finance (cost centers, internal orders, and plant codes) and the business (taxonomy, approvals, and status values), and support building-to-plant-code cleanup and SAP alignment.
- Own the recurring audit, mapping, and cleanup cycles; apply and refine validation logic; and identify, flag, and correct errors while reducing duplicate data entry.
- Maintain consistent metric definitions, data dictionaries, and reference materials, and support adherence to data governance, reporting standards, and compliance.
- Track and report data-quality measures such as error rates, correction cycle times, and completeness so data health is visible to stakeholders.
Supporting Analytics & Reporting
- Produce and maintain recurring reporting cadences (for example, weekly and monthly attendance and utilization reports and quarterly refreshes) and build and maintain dashboards, primarily in Power BI.
- Supply clean datasets and supporting analysis and visuals to the Portfolio Strategy, Transactions & Analytics function for scenario planning, demand planning, and transaction-pipeline reporting, working to the specifications that role defines.
- Contribute data, visuals, and analysis to Portfolio Insights sessions and business reviews such as QBRs.
Data Systems, Automation & Partnership
- Partner with GWS data, systems, and technology teams to maintain the health, accuracy, and scalability of portfolio analytics data, including CAFM and IWMS and space-management systems and integrated data pipelines.
- Identify and support automation of validation and error-correction, including AI-assisted or rules-based approaches, to reduce cycle time and manual effort.
- Partner with Portfolio Managers, the Portfolio Strategy, Transactions & Analytics lead, Finance, Procurement, GWS Technology, and the Workplace Research & Standards team to source data, align on definitions, and communicate clearly to technical and non-technical audiences.
Qualifications
Required / Minimum Qualifications
- Master's Degree in Mathematics, Analytics, Data Science, Engineering, Computer Science, Business, Economics or related field OR Bachelor's Degree in Statistics, Mathematics, Analytics, Data Science, Engineering, Computer Science, Business, Economics or related field AND 2+ years experience in data analysis and reporting, data science, business intelligence, or business and financial analysis OR equivalent experience.
Additional or Preferred Qualifications
- Experience with data quality, data validation, data governance, or master-data management, including auditing, mapping, and cleanup of business data.
- Working knowledge of SQL and/or Python or R for data extraction, cleanup, and analysis.
- Familiarity with corporate real estate and workplace data (attendance, occupancy, utilization, space, lease, and projects data) and with CAFM/IWMS, space-management, or ERP systems such as SAP.
- Experience building and maintaining dashboards and recurring reporting cadences in Power BI, or comparable platforms such as Tableau or Looker.
- Attention to detail and the ability to translate data into clear, decision-ready insights; demonstrated interest in the corporate real estate industry.
- Bachelor's Degree in Business Analytics, Data Science, Statistics, Finance, Real Estate, Information Systems, Business Management, or related field AND 1+ year(s) of experience in data analytics, data management, business intelligence, reporting, or real estate, portfolio, or workplace-occupancy analysis, OR 2+ years of equivalent experience.
- Proficiency with data analysis and visualization tools, including Microsoft Excel and Power BI.
Skills
Data Quality & Governance | Detail Oriented | Analytical Skills |
Data Visualization & Business Intelligence | Business Technology Optimization | Operational Excellence |
Problem Solving | Data Management | Financial Analysis |
Change Management | Written Communication | Oral Communication |
Forecasting | Team Facilitation | Customer Relationship Management (CRM) |
Data Analytics IC3 - The typical base pay range for this role across the U.S. is USD $86,100 - $169,800 per year. There is a different range applicable to specific work locations, within the San Francisco Bay area and New York City metropolitan area, and the base pay range for this role in those locations is USD $113,300 - $187,400 per year.
Certain roles may be eligible for benefits and other compensation. Find additional benefits and pay information here:
https://careers.microsoft.com/us/en/us-corporate-pay
This position will be open for a minimum of 5 days, with applications accepted on an ongoing basis until the position is filled.
Microsoft is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity or expression, genetic information, immigration status, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations and ordinances. If you need assistance with religious accommodations and/or a reasonable accommodation due to a disability during the application process, read more about requesting accommodations.