JOB DESCRIPTION
Job Description
ABOUT CIM GROUP:
CIM is a community-focused real estate and infrastructure owner, operator, lender, and developer.
Our team of experts works together to identify and create value in real assets, benefiting the communities in which we invest.
Back in 1994, our three founders focused on projects in Southern California neighborhoods.
Today, we are a diverse team of 900+ employees with projects across the Americas.
Our projects have delivered jobs; created comfortable places to live, work, and relax; and provided necessary and sustainable infrastructure.
Our focus on enhancing communities is unwavering, and we strive to make an even greater impact in the years to come.
Join us and make an impact today!
POSITION PURPOSE:
The Sr.
Data Analyst is responsible for extracting, transforming, validating, and analyzing investment performance data to support the firm's alternative investment reporting and decision-making processes.
- Working closely with the Data Steward, this role executes day-to-day data operations across fund structures, track record calculations, and investor deliverables.
The Sr.
Data Analyst serves as a key contributor to data quality initiatives, helping ensure accuracy and consistency of performance metrics across the investment hierarchy.
This position offers exposure to real estate private equity operations, institutional investor reporting, and enterprise data modernization initiatives—providing an excellent foundation for career growth in investment data management.
RESPONSIBILITIES:
Data Extraction & Transformation
- Extract performance data from source systems including Yardi, Salesforce, and internal databases. using SQL queries and data export tools.
- Use Databricks to ingest structured and unstructured data for investment analysis and reporting.
- Transform and normalize data from multiple sources to create unified datasets for performance reporting and analysis.
- Develop and maintain automated data pipelines and ETL processes to improve efficiency and reduce manual data handling.
- Prepare and format data files for NCREIF (NFI) and MSCI benchmark submissions under the direction of the Data Steward.
- Support AUM/EUM data collection processes, ensuring completeness and accuracy of assets under management reporting.
- Document data sources, transformation logic, and business rules for all recurring data processes.
- Performance Calculations & Analysis
- Calculate and validate investment performance metrics including IRR, MOIC, DPI, RVPI, TWR, and GAV/NAV at property, investment, and fund levels.
- Support Track Record construction by preparing data inputs and performing data transformations related to financial performance metrics.
- Assist with multi-level return aggregation calculations, ensuring accurate roll-up from property through investor levels.
- Perform variance analysis to identify discrepancies between calculated performance and source system data.
- Build and maintain Excel-based models and templates for recurring performance calculations and ad-hoc analysis.
- Generate performance dashboards and visualizations using Domo, Power BI, Tableau, or similar tools to support stakeholder reporting needs
Data Quality & Validation
- Execute data validation checks and reconciliations to ensure accuracy of performance data across systems and reports.
- Identify, document, and escalate data quality issues to the Data Steward with recommended remediation actions.
- Reconcile calculated performance metrics to Yardi Investment Accounting (IA) module outputs.
- Support quarterly and annual close processes by validating performance data used in investor reporting and financial statements.
- Work with the Data Steward to implement Data Governance through Databricks Unity Catalog.
- Maintain data quality scorecards and exception logs to track resolution of identified issues.
Investor Reporting Support
- Prepare data inputs and supporting schedules for Partner Reports, quarterly investor letters, and annual reports.
- Assist with Due Diligence Questionnaire (DDQ) responses by compiling performance data, track record exhibits, and supporting documentation.
- Support ad-hoc data requests, ensuring timely and accurate responses.
- Compile capital account data and investor allocation details for reporting packages in compliance with ILPA standards.
- Maintain organized files and audit trails for all investor deliverables to support compliance and regulatory requirements.
- Assist with preparation of disclosures and footnotes for investor communications.
Systems & Process Improvement
- Support data modernization initiatives by assisting with current-state documentation, target-state data mapping, and UAT testing.
- Assist with interpretation and migration to target-state data platforms.
- Identify opportunities to automate manual processes and improve data workflow efficiency.
- Collaborate with Data Engineering and Platform teams on requirements gathering and testin