Our client located just South of Pittsburgh is seeking an organized and self-motivated individual to join their team.Our client provides integrated wealth management and administrative services for an office of high wealth families.

The Financial Data Analyst will be responsible for managing day-to-day data aggregation, curation, and structuring tasks. A key focus of this role is on continuous process improvement and automation. The ideal candidate will possess a strong technological aptitude, excellent organizational and analytical skills, and a keen eye for detail. The ability to work collaboratively with cross-functional teams and a deep intellectual curiosity are essential attributes for success in this role.

Key Responsibilities:

Data Management and Analysis:

• Collect, process, and analyze investment data from various sources.
• Maintain investment data accuracy and integrity.
• Manage Alteryx workflows and investment data imports into Sage Intacct.
• Reconcile investment data, including transactions, valuations, and cash movements with custodians and investment managers.

Accounting Task Ownership:

• Perform general accounting tasks related to investment operations, including preparing journal entries for investment transactions and valuations.
• Assist in the preparation of quarterly and annual financial reports.
• Support annual audit preparations.
• Collaborate with the tax team to ensure proper tax treatment and reporting of investment activities.
• Aid in the automation of accounting processes and reporting.

Investment Administrative Tasks:

• Aggregate and file monthly, quarterly, and annual bank, custodian, and private equity statements and tax documents electronically.
• Communicate with custodians and investment managers as needed.

Qualifications:

• Bachelor’s degree in data science, accounting, or finance is required.
• Advanced degree or certification (e.g., CAP, MBA, CPA) is a plus.
• 3 years of experience as a Data Analyst, Public Accountant, Investment Accountant, or in a similar role.
• Experience with partnership and investment accounting preferred.
• Proficient with data analytics or business intelligence software such as Alteryx, PowerBI, Tableau, etc.
• Proficient with Microsoft Office products, specifically Excel, Power Automate, and SharePoint.

We are looking for a proactive individual who is eager to drive efficiency and innovation within our organization. If you meet these qualifications and are excited about the opportunity to contribute to our team, we encourage you to apply.