Senior Portfolio Analyst

Position Summary

Reporting to the Director of Investment Operations, the Senior Portfolio Analyst is part of an internal investment operations team responsible for supporting the Investment Office. Utilizing one or more investment systems, the Senior Portfolio Analyst is responsible for the collection, entry, validation, monitoring, and quality of investment data and participation in various work processes to facilitate the onboarding, monitoring, and off boarding of investment managers. The position also supports technology-focused initiatives by developing and maintaining queries, scripts, data quality controls, reporting outputs, dashboards, and automation workflows that improve investment data accuracy, reconciliation, monitoring, and operational efficiency. The Senior Portfolio Analyst is a key contributor to investment system implementations and other project initiatives in support of the Investment Office.

Essential Functions

·        Collaborate with investment staff, external investment managers, and vendors to ensure complete, accurate, and timely investment data

·        Support investment staff with the completion of various tasks including compliance with investment office policies and procedures, completion of related work processes, and compliance with document retention policies

·        Support the development, maintenance, and enhancement of data management processes for data validation, analytics, reconciliation, and reporting utilizing SQL, Python, Microsoft Fabric, Power Query, Power BI, or similar tools.

·        Key contributor in investment system implementation and functionality upgrade projects

·        Manage various initiatives driven by Investment Operations Team to ensure projects are delivered on-time and within scope

·        Identify and resolve matters related to data quality that span multiple asset classes and investment systems

·        Monitor data for accuracy, consistency, and correct mapping to multiple investment systems

·        Assist with the development and maintenance of various investment data management reports and dashboards

·        Develop and maintain reconciliation tools and reports that validate and summarize data health

·        Develop and maintain data maps and process flows

·        Act as a subject matter expert for one or more investment systems

·        Oversee vendor for one or more investment systems by ensuring compliance with key performance indicators and being a key contributor during vendor service calls.

·        Participate in ad-hoc projects as requested

This list details the Trust’s assignment of essential functions to this position. Other duties or tasks may be assigned to this position. This job description is subject to change at any time.

Technical Competencies

·        Comfortable working with large data sets

·        Organizational skills with an ability to meet deadlines with accuracy

·        Preferred working knowledge of SQL, Python, Microsoft Fabric, Power BI or similar data platform tools to support data integration, transformation, reporting, automation, and analytics.

·        Highly proficient in personal computer skills and use of software (Microsoft suite and other applicable investment tools)

·        Demonstrated problem solving and analytical skills with a high level of attention to detail

Personal Effectiveness Competencies

All employees of the Trust are expected to demonstrate relevant personal effectiveness competencies as specified in the Trust’s competency definitions.

Minimum Required Experience

·        Two (2) years of investment experience in an institutional investment environment

·        Strong interpersonal skills and demonstrated commitment to teamwork

·        Strong oral and written communication skills

·        Understanding of basic accounting concepts

·        Project management work experience preferred

·        Experience working with investment systems preferred

·        Prior investment and/or investment operations experience

·        Fundamental understanding of various asset classes and investment data

·        Ability to work in a dynamic environment where roles and responsibilities are evolving as new processes and procedures are implemented

·        Demonstrated self-starter with ability to work with limited supervision

·        Ability to perform assigned tasks in a timely manner

Education, Professional Certifications and Licensure

·        Bachelor’s degree, preferably in Business, Finance, Accounting, or related subject

·        CFA, CPA, CIPM, CAIA or other similar professional investment designations desirable

Working Conditions and Physical Effort

·        The physical requirements of this position are typical of office work

·        Occasional travel as required to Trust’s Detroit office

Infrequent travel as required