Data and Reporting Specialist II

Corient Capital Partners
$71,901 - $94,680 a year
Houston County, Texas
2 weeks ago

Description

Maintain Internal Systems:

  • Maintain Portfolio Management System (PMS) and all relevant Data and Reporting datapoints in the CRM
  • Overseeing PMS account lifecycle activities (opening, closing, transfers, renaming) within the PMS
  • Identify, understand, and provide input related to enhancements, system integrations and data transformation requirements
  • Ensure data integrity. Deploy efficient audits through use of available tools for daily, monthly, and quarterly reconciliation of PMS data against custodian records and statements
  • Uploading and verifying cost basis data for security transfers
  • Monitoring and resolving undefined/missing sectors, prices, and security data
  • Reviewing and managing corporate actions (e.g., splits, spin-offs) within the PMS
  • Troubleshooting TWR/IRR performance discrepancies, including FX impacts
  • Benchmark maintenance across accounts
  • Documenting and testing PMS automations to enhance processes
  • Reconciling and maintaining manual accounts and incoming asset data
  • Coordinating with custodians to onboard new interfaces, ensuring all documentation is complete
  • Attend webinars, workshops, and conferences to remain current on product releases and roadmaps

User Support:

  • PMS data and reporting liaison between business unit, corporate, and vendors
  • Managing the client portal, including user access, uploads, troubleshooting, and vendor communication
  • Manage user experience including creating, updating, and terminating users as well as setting up appropriate profiles and permission sets to adhere to firm’s compliance guidelines
  • Provide users with support/training on PMS and its related information in CRM
  • Support bulk data and reporting deliverable needs across the organization (transfer and renames of account records in PMS, uploading documents to client portal)

Reporting and Billing:

  • Maintain client performance reports within the PMS
  • Provide business intelligence by creating/maintaining reports and dashboards
  • Generate timely monthly/quarterly corporate data extract reports
  • Generate ad hoc reports for internal and external stakeholders’ requirements
  • Work with Billing team to maintain and clean billing -related data in PMS
Apply
Other Job Recommendations:

Medical Data/ Healthcare Data/ Data Collector/ Data Management

Roush
Wayne County, Michigan
$22 - $23 an hour
  • VLOOKUP/XLOOKU (Filters & sorting).
  • Pivot tables (Conditional formatting)...
3 weeks ago

Associate Registrar, Data Systems and Reporting

St. Olaf College
Rice County, Minnesota
$62,000 - $70,500
  • Manage the validity and integrity of the data that are...
  • Establish and manage processes for inputs into the College...
1 day ago

Data Reporting - Lead Software Engineer

JPMorgan Chase & Co.
Columbus, Ohio
  • Develop secure, high-quality production code; review and...
  • Identify opportunities to automate or eliminate recurring...
1 week ago

Manager, Data Analytics & Reporting (SQL, PowerBI)

Managed Health Services Indiana
Indiana
$86,000 - $154,700 a year
  • Manage scheduled and adhoc reporting needs of the...
  • Execute and manage the completion of large reconciliation...
1 week ago

LOTTERY - Reporting & Writing Specialist (Technical Writer III)

Texas Comptroller of Public Accounts
Austin County, Texas
$61,176 - $85,992
Our Mission Statement: The Texas Lottery is committed to generating revenue for the State of Texas through the responsible...
3 weeks ago