Data Quality and Governance Analyst 1
Core
Ensuring accuracy, completeness, and timely delivery of operational and financial data across a global real estate investment management platform.
Role type
Data Quality and Governance Analyst
Builds
Operational and financial data sets, dashboards, and reports for investment management
Domain
Real Estate Investment Management / Financial Data
Deliverable
dashboards & analysis
Required skills
Data extraction, data cleansing, data aggregation, data validation, SQL, Excel, Power BI, SSMS, JIRA, SFTP, process improvement
Preferred skills
Python, .NET, Java, VBA, Investment Banking, Finance, Insurance, Services, Real Estate industry experience
Technologies
YARDI, Power BI, SSBI, SSMS, JLLGPT, SFTP, RCA, CBRE-EA, Moody's Analytics, NCREIF, Altus, CoStar, Realpage, MSCI CVaR
Responsibilities
Acquire and validate operational/financial data from primary and secondary sources; Conduct data quality checks on Tenancy Schedules, Arrears templates, and dashboards; Filter and clean data by resolving discrepancies across systems; Manage daily data upload processes via SFTP; Maintain and refresh Climate Risk and Performance data; Collaborate with Engineering/Product teams to reduce ETL issues; Identify and implement process improvement opportunities; Support data warehousing projects including database maintenance and unit testing; Maintain logs, documentation, and SOPs.
Seniority
Junior to Mid-level (2+ years experience)
