Investment Coordinator

JOB SUMMARY:

The Investment Coordinator will be a key member of the team with an in-depth focus on the Firms' Investment vehicle, RGIP LP. The role will have direct exposure to the Managing Partners of RGIP and other finance leaders. The scope of this role includes a wide variety of accounting, reporting, analysis, and internal controls.

ESSENTIAL FUNCTIONS:

1. Gather reports from Fund portals and extract relevant data for internal reporting.

2. Processing capital calls and distributions in timely manner.

3. Support month-end close process by preparing account reconciliations and analyses; identifies, researches, and resolves reconciling items as needed.

4. Prepares and records monthly journal entries.

5. Evaluates internal controls and makes recommendations for new controls and improvements to existing controls.

6. Cash management including monthly bank reconciliation, partner capital calls, partner distributions and tracking investment funding/redemptions.

7. Acts as liaison with external auditors. Prepares audit schedules and responds to audit inquiries.

8. Works with R&G tax team and external tax advisors to ensure tax compliance and the successful completion of K-1s.

9. Assist with maintenance of the RGIP database (an internally developed database within Microsoft Access/SQL) and the General Ledger system for RGIP (within Elite 3E).

10. Prepares timely and accurate statements and analyses for distribution to RGIP investors.

11. Supports RGIP management team (consisting of 5 partners) in making changes to RGIP-related reporting, recordkeeping, and analysis.

EDUCATION, EXPERIENCE, AND SKILLS REQUIRED:

• Bachelor's degree with a concentration in Accounting, Finance, or related majors.

• 1-3 years of related work experience or Asset Management.

• Superior computer software skills with a particular expertise in Excel, Access, and SQL.

• Knowledge of 3E, Microstrategy, Crystal Reports preferred but not required.

• Excellent written and verbal communications skills.

• Strong analytical and problem-solving skills.

• Self-motivated with an ownership mindset.

• Must be a critical thinker able to question what is and recommend what should be.

• Must have the ability to analyze financial data and prepare concise reports to assist management in understanding financial performance.

• Attention to detail is a must.

• The ability to manage multiple priorities and complete tasks with minimum supervision is required.

• Team player with a strong work ethic.