Senior Analyst

Data Governance
Posted: 11/07/2019
Full Time
Los Angeles, CA
The Sr. Analyst, Data Governance, is responsible for improving the accuracy and reliability of financial / operational data used for analysis and reporting. This individual will be also responsible for improving the efficiency of various processes across all CIM business units.
Essential Functions
  • Build user friendly tools that create efficiencies for various business processes and improve the accuracy and reliability of financial and operational data using programs / languages such as VBA (Excel Macro), SQL. Assess opportunities to make improvements to existing, temporary tools and processes that should be transitioned to permanent solutions. Propose an improvement or transition plan while weighing overall project objectives and priorities and assist in the transferring of knowledge, development or implementation of new tools or processes as needed
  •  Analyze data flow in and out of various systems such as YARDI and evaluate alternative tools to organize the data in reporting database managed by Data Governance team. Work with other teams such as Property Management, Leasing, Portfolio Oversight, Investments and Accounting & Financial Reporting to gain understanding of where source data is created and how it is used by all business units. Apply understanding of database modeling and relational database management to design, re-design, build and maintain firm wide data management solutions as needed
  • Analyze source data for potential discrepancies and missing data elements in data used by Data Governance. Propose and implement solutions to remediate discrepancies. Maintain integrity of Data Governance team’s data management tools to ensure they do not create additional discrepancies and take ownership of information in all reports, tables or other tools created
  • Contribute to joint initiatives related to the implementation of enterprise data warehouse solutions by working with IT
  • Ensure data points used by Data Governance team conforms to standard industry guidelines and internal data definitions using GAAP, GIPS/REIS/NCREIF performance metrics and general real estate operating metrics
  • Requirements
  • Bachelor’s degree in Financial Engineering, Computer Science, Statistics, Mathematics or related quantitative field
  • 3+ years' previous data analysis, management experience in the financial services industry
  • Experience with financial modeling in Excel
  • Real estate private equity experience (preferred)
  • Information Technology, Finance / Accounting experience (optional)
  • CPA, CFA (optional)
  • Knowledge of logical database modeling concepts and relational database management
  • Knowledge of US GAAP, GIPS/REIS/NCREIF performance metrics, and real estate operating metrics
  • Proficient in Excel and financial modeling (complex formula, pivot with data connection)
  • Proficient in SQL
  • Proficient in VBA (Excel Macro), and ability to learn other languages
  • Experience with data warehouse and BI tools
  • Experience in YARDI, MRI, J. D. Edwards or comparable software (optional)
  • Reasoning Skill Requirements
  • Highly analytical and detail oriented
  • Deadline driven and ability to manage multiple tasks
  • Ability to work independently and to proactively evaluate and address work opportunities within the area of responsibility
  • Experience with logical data modeling concepts (optional)
  • Experience with data mining/data analysis (optional)

  • CIM does not accept unsolicited resumes from Agencies.  Any unsolicited resumes received from Agencies will be considered property of CIM and no fees will be due or paid.  If you wish to become an approved Agency with CIM or any of its Affiliates, please contact a member of the CIM Talent Acquisition Team.