SR. ANALYST, DATA MANAGEMENT & REPORTING

For UCOP internal applicants, please login to the internal candidate gateway at:

UC OFFICE OF THE PRESIDENT

At the University of California (UC), your contributions make a difference. A world leader producing Nobel and Pulitzer prize recipients with over 150 years of groundbreaking research transforming the world. Choose a career where you can leverage your knowledge, skills and aspirations to inspire and support some of the greatest minds in the world, and those who will follow in their footsteps. Working at the University of California is being part of a unique institution, and a vibrant and diverse community. At the University of California, Office of the President, we propel our mission through impactful work locally, in government centers and systemwide. We are passionate people, serving the greater good.

The University of California, one of the largest and most acclaimed institutions of higher learning in the world, is dedicated to excellence in teaching, research and public service. The University of California Office of the President is the headquarters to the 10 campuses, six academic medical centers and three national laboratories and enrolls premier students from California, the nation and the world.

DEPARTMENT OVERVIEW

The Office of the Chief Investment Officer ("UC Investments") is responsible for managing the University of California's retirement, endowment, working capital, and cash assets under the policies, guidelines, and performance benchmarks established by the Regents. The mission of the Office is to implement those policies and guidelines by selecting, executing, and monitoring investment strategies designed to add value over the benchmarks within a risk-controlled framework. The Office adheres to high ethical as well as professional standards in serving the investment management needs of its constituency. The Chief Investment Officer has full investment discretion while the Regents retain responsibility for Asset Allocation and Investment Guidelines.

POSITION SUMMARY

Reporting to the Director of Data Management, the Senior Analyst plays an important role in planning, developing, and executing new investment data related initiatives, as well as providing data support for the various investment teams and downstream applications within UC Investments. The Senior Analyst is primarily responsible maintaining the Investment Book of Record by ensuring accuracy and granularity investment exposures and transactions data for all assets under management. This individual will analyze and resolve any data issues, while ensuring that internal and external partners are communicated on status data. They will work closely with the investment, operations, compliance, and risk teams to develop new reports and analytics to support the investment decision making process at all levels.

The Senior Analyst will have the opportunity to work with large sets of investment data and relation tables/structures across various disciplines including Performance & Attribution, Risk, Accounting, Compliance, and Asset Allocation. The individual in this role will be the main point of contact to address data related issues including maintenance of custom data and mapping tables, configure reports and reporting scripts, identifying and resolving data gaps, and providing oversight to daily and monthly data feeds to and from downstream systems. As a member of the team they will support the office by developing a thorough understanding of our governing body, stakeholders, portfolio structures, benchmarks, and systems, as well as identifying and executing on ways to challenge/improve current processes to increase efficiency and data accuracy throughout the UC Investments and be able to effectively communicate and collaborate with the different teams.

Responsibilities

30% INVESTMENT REPORTING

• Produce high quality, accurate, and timely investment reports for the Investment team, the Regents, and clients of UC Investments.
• Report on asset mix with a particular focus on future cash flows and notional exposures.
• Prepare scheduled investment reports to various committees and foundations.
• Partner with Senior Management and Investment Teams to produce and incorporate new content (charts, tables, graphs, infographics) to investment reports.
• Manage list, format, and timeline of internal and external reports for stakeholders.
• Collaborate with Investment, Operation, and Data Management teams to develop scalable and impactful analytics to enhance messaging and storytelling of investment reports.
• Develop a reporting production line that includes elements of review, compliance, and approval processes.
• Develop, maintain, improve, and automate reports.

30% DATA MANAGEMENT/ AUTOMATION

• Ensure the accuracy of underlying data in data (historical exposures, asset mix, performance, policy weights, and more) warehouse used for investment decision making purposes.
• Prepare, interpret, and investigate anomalies with appropriate individuals/groups to resolve errors.
• Build data integrity reports to cross-check data across multiple views and sources.
• Ensure daily and monthly scheduled tasks are completed without errors.
• Develop methodologies to capture and/or enrich data tables/elements to increase ability to automate reports.
• Provide guidance on data flow/capture/display processes to support the review and approval process.
• Build new investment structures/assets from a data management capacity.
• Augment and/or write custom functions fit for purpose to answer time sensitive and mission critical questions regarding the portfolios.

30% PORTFOLIO MAINTENANCE AND ADMINISTRATION

• Manage setup and maintain a variety of systems that support asset mix, performance, attribution, exposure, and risk calculations for all assets under management of approximately $160 billion.
• Maintain lineage and reconciliation between portfolio management, performance, accounting, risk, and investment compliance systems.
• Lead change management process to assemble views and decisions made from senior management and other stakeholders.
• Collaborate with various vendors to source and collect index and market data to provide further insights for the investment team.
• Proactively seek out and implement process improvements to increase efficiency, and increase the level of service provided to stakeholders.
• Investigate ad-hoc issues as raised by the investment, risk, compliance, and operations teams.

5% PROJECT MANAGEMENT

• Lead and represent the interests of the reporting function in new tools and systems implementations. In so doing, develops a strong project management culture to:
  • Coordinate internal resources and third parties/vendors for execution of projects
  • Assist in the definition of project scope and objectives for reporting
  • Manage the development of detailed project plans to monitor and track progress

5% AD-HOC REQUESTS

Ad-hoc and custom data requests across departments including queries, reports, custom calculations, assess new tools to improve quality of reports.

Support continuous improvement projects across departments.

Required Qualifications

• Minimum of four (4) years of job related experience.
• Demonstrated ability to build and utilize extensive personal network of industry contacts to share industry best practices.
• Excellent interpersonal skills as demonstrated by the ability to interact with others in a consistently positive manner, exercise discretion and tact, and gain consensus in an environment where others may have strongly conflicting ideas and goals.
• Demonstrated ability to quickly research and collect pertinent information, identify critical points and integrate them to define and test options and alternatives. Insightful and creative skill in reasoning and logic and quantitative analysis demonstrated by ability to develop recommendations and justification for the most productive course of action.
• Excellent verbal and written communication and presentation skills, including the demonstrated ability to articulate ideas and issues clearly, concisely, and persuasively to a variety of audiences and prepare and/or edit complex reports involving logical and quantitative analysis, so that it is clearly understandable by both technical and lay readers and effectively advances and justifies a specific proposal or set of recommendations
• Ability to generate both qualitative and quantitative independent analysis.
• Plan and manage projects in their entirety and ensure they are delivered on time.
• Demonstrates good judgement when asking questions both internally and externally to seek desired information or understanding.
• Knowledge of project management and systems development life cycle principles and practices within the context of investment management systems.
• Deep understanding of portfolios, asset classes, risk factors, and data structures.
• Knowledge of investment software programs such as BlackRock Aladdin, Custodian and Banking Systems, Investment Manager databases, Bloomberg, Solovis
• Working knowledge of data visualization tools/methods.
• Ability to query databases; coding experience preferred.
• Working knowledge of best practices for website design and development.

Preferred Qualifications

• Understanding of UC policy, guidelines, asset allocation, portfolio structure, investment strategies, managers, and holdings.
• Knowledge of UC data structure.

Education

• Bachelor's degree in related area and a minimum of four (4) years of job related experience and/or equivalent experience/training.
• Master's degree and/or CFA or equivalent experience/training.

SPECIAL CONDITIONS

This position is eligible for a hybrid work arrangement and may be required to report to work onsite in Oakland, CA at least 3 days per week.

SALARY AND BENEFITS

Salary: $103,000 - 120,000, commensurate with experience.

Benefits: For information on the comprehensive benefits package offered by the University visit:

ADDITIONAL INFORMATION

HOW TO APPLY

Please be prepared to attach a cover letter and resume with your application.

APPLICATION REVIEW DATE

The first review date for this job is August 31, 2022. The position will be open until filled.

CONDITIONS OF EMPLOYMENT

Background Check Process: Successful completion of a background check is required for this critical position.

Smoke Free Work Environment: The University of California, Office of the President, is smoke & tobacco-free as of January 1, 2014.

August 2021 Update: The University of California has issued a policy requiring employees to be fully vaccinated against COVID -19 before physically accessing the University location or programs. Upon hire into a UCOP position, you will be provided detailed instructions on how to comply with this policy including access to the COVID vaccination at no cost. New hires to UCOP who work onsite or will come onsite for any activities at a UCOP or other UC location must comply with this policy within 8 weeks after their start date. The policy allows for employees to request approval for an exception or deferral.

EEO STATEMENT

The University of California, Office of the President, is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status.

The University of California, Office of the President, strives to make this job board accessible to any and all users. If you have comments regarding the accessibility of our website or need assistance completing the application process, please contact us at: or email the Human Resource Department at: