Senior Data Analyst
Tasks
- Build Excel models and templates for performance calculations
- Calculate and validate investment performance metrics
- Collaborate with data engineering and platform teams on pipeline requirements
- Conduct variance analysis on performance metrics
- Create performance dashboards using BI tools
- Develop and maintain ETL pipelines
- Execute data validation checks and reconciliations
- Extract performance data from source systems using SQL
- Maintain organized files and audit trails for investor deliverables
- Perform track record construction transformations
- Prepare NCREIF and MSCI benchmark submission files
- Prepare investor reporting data inputs and supporting schedules
- Reconcile performance metrics to Yardi Investment Accounting outputs
- Respond to DDQ requests with performance exhibits and documentation
- Support data modernization initiatives and UAT testing
- Support quarterly and annual close data validation
- Transform and normalize data into unified datasets
Perks/Benefits
- 401k match
- Health savings account
- Life and disability insurance
- Paid parental leave
- Paid time off
- Professional development programs
- Volunteer time off
- Wellness program
Skills/Tech-stack
DPI | Data Governance | Data Validation | Databricks | Domo | ETL | Excel | Gav | ILPA | IRR | MOIC | MSCI | NAV | NCREIF | Power BI | Power Query | Python | R | Rvpi | SQL | TWR | Tableau | Unity Catalog | Variance analysis | Yardi
Education
Bachelor of Arts | Bachelor of Engineering | Bachelor of Science
Roles
Related jobs
-
Analyst/Sr Analyst, Contact Center - Analytics USD 37K-54KData Manipulation | Data Modeling | Data Warehouse | Data extraction | Database Management401k program | Car discounts | Cruise discounts | Dental insurance | Employee assistance programSenior-level Full TimeFort Worth, TX, US4h ago
-
Business Intelligence | Data Analysis | Data Automation | Data Visualization | Excel401k | Dental insurance | Medical insurance | Paid sick hours | Vision insuranceMid-level Contract Full TimeRidgefield Park, NJ, United States11h ago
-
Data Analyst, LiveOps Digital Gaming USD 96K-136KA/B | A/B Testing | B testing | BigQuery | Data VisualizationSenior-level Full TimeEl Segundo, CALIFORNIA, United States12h ago
-
Data Analyst, Growth USD 100K-150KAttribution Modeling | Audience Segmentation | Clustering | Dashboard Development | Experimentation401k match | Company holidays | Fitness perks | Generous time off | Life insuranceEntry-level Full TimeSan Francisco, CA13h ago
-
Policy Data Analyst USD 97K-97KBigQuery | Cloud platform | Google Cloud | Google Cloud Platform | Jupyter401k match | ClassPass credit | Company offsite | Flexible time off | Medical, dental, and vision insuranceMid-level Full TimeRemote, New York City, or Oakland R15h ago
-
Access Management | Cause analysis | Dashboards | Data Dictionary | Data Management401k employer contribution | Commuter benefits | Fitness reimbursement | Medical/Dental/Vision insurance | Paid time offMid-level Full TimeSan Francisco, California, United States15h ago
-
Power & Load Optimization Trader USD 217K-329KCongestion Management | Day Ahead | Day Ahead Markets | Demand response | ERCOT401k employer contribution | Cell phone internet reimbursement | Company Paid Team Events | Family planning support | Food stipendMid-level Full TimeUnited States R15h ago
-
Project Engineer - Data Analysis USD 100K-155KAzure Data | Azure Data Factory | DAX | Dashboard Development | Data Factory401k | Dental insurance | HRA or HSA options | Health insurance | PTO and paid holidaysSenior-level Full TimeDenver, CO16h ago
-
Senior Data Analyst, Revenue Analytics USD 100K-120KData Engineering | Data Modeling | Data Validation | Data Visualization | Data Warehousing401(k) plan match | Cruise travel discount | Dental insurance | Disability insurance | Gym membership discountSenior-level Full TimeLos Angeles, California, United States17h ago
-
Data Analyst II USD 100K-145KDBT | Data Architecture | Data Governance | Data Modeling | Data Pipelines401k match | Company events and outings | Dental insurance | Dependent care | Employee discountsMid-level Full TimeBrooklyn, NY (Rent the Runway HQ) R17h ago
-
Data Analytics Manager - Marketing USD 86K-120KAmazon Redshift | Customer Lifetime Value | Data Cleansing | Data Quality | Digital Marketing AnalyticsBonus potential | Learning opportunities | Medical benefits | Retirement benefits | Travel up to 20 percentMid-level Full TimeRye Brook, NY, United States18h ago
-
Sales Compensation Analytics & Systems Specialist USD 111K-166KCRM | Compensation Management | Incentive Compensation | Incentive Compensation Management | SQL401k plan | Equity | Medical, dental, vision benefits | Wellness stipendsMid-level Full TimeCHI, SF, NYC18h ago
-
Regional Data Analyst USD 40K-40KDashboard Development | Data Modeling | Data Quality | Data Visualization | Data WarehousingDental insurance | Health insurance | Life insurance | Long-term disability | Retirement planEntry-level Full TimeOklahoma City & Tulsa, OK, United …18h ago
-
Analyst, Distribution & Partner Analytics USD 70K-95KBigQuery | Databricks | Excel | PowerPoint | Python401k | Dental insurance | Discounts | Medical insurance | Paid leaveMid-level Full TimeUniversal City, CALIFORNIA, United States18h ago
-
Machine Learning Co-Op (Summer 2026) USD 96K-180KDAX | Data Analysis | Data Visualization | Deep learning | GitMid-level Full TimeCanton, OH, United States18h ago
-
Principal Analytics Lead – Product Operations & AI USD 116K-194KAnalytics engineering | Capital management | Compliance | Dashboards | Data AccessibilitySenior-level Full TimeRoseland, NJ, United States18h ago
-
Sr Business Data Analyst USD 70K-115KDAX | Data Modeling | Data Pipelines | Data Visualization | ETLBonus plan | Dental insurance | Discounted stock purchase | Medical insurance | Paid time offSenior-level Full TimeLas Vegas, NV, US19h ago
-
Sr Business Data Analyst USD 70K-115KDAX | Dashboard Development | Data Modeling | Data Visualization | Data pipelineBonus plan | Dental insurance | Discounted stock purchase | Medical insurance | Paid time offSenior-level Full TimeCanal Winchester, OH, US19h ago
-
Sr Business Data Analyst USD 70K-115KDAX | Data Modeling | Data Visualization | ETL | Power BIBonus plan | Dental insurance | Discounted stock purchase | Medical insurance | Paid time offSenior-level Full TimeWaddell, AZ, US19h ago
-
Project Mgr, Business Intelligence USD 81K-101KData Cleansing | Data Modeling | Data Quality | Data Transformation | Data Validation401k match | Family leave | Legal insurance | Life insurance | Medical, dental, vision plansMid-level Full TimeSanta Monica, CA, United States19h ago
-
Collections Analyst USD 44K-54KAccounts Receivable | Automation rules | Cash Flow | Cash Flow Forecasting | Credit AnalysisMid-level Full TimeCharlotte, NC, United States19h ago
-
Data Analyst USD 100K-134KAlteryx | CRM | Data integration | Microsoft Excel | Netsuite401k match | Dental insurance | Health savings account contributions | Medical insurance | Paid time offMid-level Full TimeRemote, United States R19h ago
-
Customer Service | Data Analysis | Data Reconciliation | Data entry | Database ManagementDental insurance | Employee assistance program | Life insurance | Medical insurance | Short-term disabilityEntry-level Full TimeBuffalo, NY, United States19h ago
-
Demand Planning Data Analyst USD 46K-52KAI tools | Data Analysis | Data Visualization | Demand Planning | ExcelMid-level Full TimeLiverpool, NY, United States21h ago
-
ArcGIS | Data Mining | Data Modeling | Data Quality | Data Validation401k matching | 457(b) plan | Career Development Programs | Flexible work schedule | Health premiums paidMid-level Full TimeTexas-Austin22h ago