Porfolio Data Analyst Job

Porfolio Data Analyst (Job Number: 1313280)

Description

The Portfolio Data Analyst is responsible for gathering, analyzing, troubleshooting, maintaining and developing applications used to prepare performance returns, attribution reports, risk metrics and other portfolio performance and risk measurement reports. The Portfolio Data Analyst will provide data support to the Performance Reporting team by developing analytical applications using Excel, Access, VB and SQL. Additionally, he/she will perform ad-hoc database queries and reporting to assist Performance Analysts with production report generation and validation. The incumbent will also help the Performance Reporting team to determine and implement automated or operational routines to facilitate, streamline and enhance data management and reporting productivity. Job Responsibilities: Perform data import/export using various performance systems: Eagle PACE, Factset, Point, Oracle, SQL Server; Design and develop tools using Excel, Access, VB or .Net to analyze accounting data for performance and risk measurement calculation; Work closely with performance analysts and report developers to research and review data quality and confirm data accuracy; Coordinate with Operations and Technology teams on data requirements, data integrity issues, and data validation; Determine and implement automated or operational procedures to facilitate daily and monthly report generation; Work as part of a team on projects and support all aspects of the project lifecycle including: research, analysis, requirements, development and testing; Perform system analysis to determine data requirements and technical recommendations; Produce ad-hoc queries and reports for non-standard requests from Performance Analysts or Distribution Support; Master the understanding of portfolio accounting data and be the subject matter expert for the Performance Reporting team; and Review and analysis of accounting data gathered from various accounting systems to facilitate performance, attribution and risk measurement analysis.

Qualifications

Qualifications: BA/BS Degree required with a major/minor in Computer Science preferred with 2 years of experience working in Asset Management or related financial services company (brokers or vendors); Advanced Excel/Macro experience; Ability to use SQL to extract and analyze data; Ability to develop simple analytics using Access or VB is a strong plus; Knowledge VB or .Net programming; Understanding of the markets and various instruments (equity, fixed income, foreign exchange, derivatives); Familiar with portfolio accounting data (positions, transactions, contributions, redemptions, realized/unrealized gains/losses, margins, collaterals, cash balance); Familiar with performance return calculation and reporting; and Solid communication skills and comfortable and capable of working with Operations, Technology, Client Reporting and Portfolio Management teams.

Primary Location: San Francisco, CA, US
Internal Jobcode: 32535
Job: Investment Management
Organization: Mellon Capital Management-HR06141

September 9, 2013 • Tags:  • Posted in: Financial

Leave a Reply

You must be logged in to post a comment.