Portfolio Associate

Ultipro; Little Rock, Northern (AR, KY); Hybrid; USD 50,000 - 70,000; Full time

Benefits offered by this job

HIPAA Training

Job summary

Ultipro is seeking a Portfolio Account Administration professional to manage performance analysis, tax lot reporting, and reconciliation across diverse securities and accounts.

The role requires a Bachelor's degree in accounting or related field and 1+ years of experience, with strong Excel and data-entry skills. You will handle setup, reconciliation, and cost-basis tasks while supporting IRS 1099 reporting processes.

Qualifications

• Bachelor's degree in accounting or related field with 1+ years of related experience.
• Equivalent combination of education and experience acceptable.
• Strong Excel and data management capabilities required.

Responsibilities

• Set up new accounts and CUSIP records in portfolio systems per guidelines.
• Reconcile cash and security positions for outside custodian accounts daily.
• Maintain tax lot cost basis per IRS guidelines and review corporate actions.
• Update benchmarks and perform performance analyses for reports.
• Reconcile portfolios, resolve discrepancies, and generate client reports.
• Prepare data and spreadsheets for audits and regulatory reviews.

Skills

Verbal communication

Written communication

Organizational skills

Attention to detail

Analytical thinking

Problem solving

Multitasking

Confidentiality

Education

Bachelor's degree in Accounting

Bachelor's degree in related field

Tools

Microsoft Excel

Microsoft Word

10-key by touch

Alpha/Numeric Data Entry

Database skills

Job description

Portfolio Account Administration, Performance Analysis and tax lot accounting for cost basis reporting to clients and IRS 1099's. Investment account reconciliations to custodians. Work with all multiple types of securities and investment accounts.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Set up new accounts on portfolio management system following exact guidelines and coding.
• Set up new security master CUSIP records on portfolio management system and trading system.
• Reconcile Portfolio cash and security positions for outside custodian accounts,
• Maintain accurate tax lot cost basis following IRS guidelines.
• Perform security CUSIP and benchmark price analysis.
• Complete performance rate of return reconciliation and analysis for total portfolio, composite households, and CUSIP level.
• Gain knowledge of corporate actions such as spinoffs, splits, mergers, share class exchanges and effects on performance calculations.
• Problem solving for corporate actions and review of Form 8937 to interpret outcome of events.
• Reconcile portfolios upon request from brokers for date range performance reports.
• Add/change/remove benchmarks on portfolios, per broker’s request.
• Update time sensitive cash and/or positions in trading system, as required.
• Complete data entry, as required, for large projects that are manual across many portfolios.
• Update and maintain composites' performance for GIPS audit verification (Global Inv Performance Standards).
• Review marketing material for accurate performance reporting.
• Review Wash Sales and submit Service Center request to Clearing Firm when questions or errors arise.
• Set up new Model portfolios, update transaction’s as requested, and analyze model performance.
• Submit Service Center Request for Cost basis adjustments as needed for date of death transfers and gifted securities.
• Reconcile outside custodian portfolio accounts daily by comparing Stephens’ back office to portfolio systems.
• Resolve any differences daily and generate reports as necessary.
• Portfolio account performance analysis and maintenance.
• Research as necessary and resolve portfolio problems, some of which may be complex.
• Maintain files of both confidential and routine materials.
• Maintain supplemental database information and prepare Excel spreadsheets using portfolio data when necessary.
• Perform miscellaneous duties such as prepare price update, generate and distribute reports, make copies, send faxes, order supplies, create new files, maintain files, storage of historical files and maintain files on computer as necessary.
• Performs other tasks as assigned by management.

EDUCATION AND/OR EXPERIENCE

• Bachelor's degree in a related field.
• 1+ years of related experience and/or training.
• Equivalent combination of education and experience.

KNOWLEDGE, SKILLS, AND ABILITIES

• Excellent verbal, written and organizational skills and strong attention to detail.
• Self-motivated with the ability to work independently in a fast-paced environment.
• Ability to prioritize and handle multiple tasks simultaneously.
• Analytical, critical thinking and problem solving skills with the ability to determine the appropriate action.
• Process management skills.
• Establish and maintain effective working relationships at all levels of the organization.
• Proficient in Microsoft Office Suite or similar software, with the ability to learn and utilize industry specific software as required.
• Ability to maintain confidentiality.
• Demonstrated reliability in attendance and work performance.
• Data Analysis and regulation interpretation.
• Advanced 10-key and alpha/numeric data entry accuracy.
• Basic accounting and database skills.

REQUIRED TESTING

• Microsoft Word
• Excel
• Alpha/Numeric Data Entry

Qualifications

Skills

Required

10-key by touch

Expert

Alpha/Numeric Data Entry

Expert

Microsoft Excel

Expert

MicroSoft Word

Expert

Education

Required

Bachelors or better in Accounting.

Licenses & Certifications

Preferred

HIPAA Training

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.