Senior Portfolio Analyst

UAW Retiree Medical Benefits Trust; Ann Arbor (MI); On-site; USD 90,000 - 130,000; Full time

Job summary

UAW Retiree Medical Benefits Trust in Ann Arbor seeks a Senior Portfolio Analyst to join the Investment Operations team. The role focuses on collecting, validating, and monitoring investment data, supporting onboarding, and facilitating offboarding of investment managers, using SQL, Python, Power BI and related tools.

The successful candidate will develop data management processes, maintain dashboards, and contribute to system implementations and project initiatives, ensuring data quality and

Qualifications

• Two years of investment experience in an institutional setting.
• Strong interpersonal skills and demonstrated commitment to teamwork.
• Strong oral and written communication skills.
• Understanding of basic accounting concepts.
• Experience with investment systems preferred.
• Ability to work in a dynamic environment with evolving processes.

Responsibilities

• 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 policies and procedures and document retention.
• Develop, maintain, and enhance data management processes for validation, analytics, reconciliation, and reporting using SQL, Python, Power Query, Power BI or similar tools.
• Contribute to investment system implementation and functionality upgrade projects.
• Manage initiatives to ensure projects are delivered on-time and within scope.
• Identify and resolve data quality issues across multiple asset classes and systems.
• Monitor data for accuracy, consistency, and correct mapping to investment systems.
• Develop and maintain investment data reports and dashboards.
• 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 and participate in service calls.

Skills

Teamwork

Communication

Attention to detail

Problem solving

Self-motivated

Education

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

CFA, CPA, CIPM, CAIA or similar desirable

Tools

SQL

Python

Power BI

Power Query

Microsoft Fabric

Job description

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.

• 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