Fund Accounting Analyst, NAV Automation Specialist

jobs.jerseyeveningpost.com-job boards; United Kingdom; On-site; GBP 40,000 - 60,000; Full time

Job summary

A dynamic finance organization based in the United Kingdom is looking for a Fund Accounting Analyst, NAV Automation Specialist. This full-time position focuses on enhancing operational efficiency through automation, including designing solutions with Python and SQL. Candidates should possess deep knowledge of NAV calculations, financial instruments, and a background in fund accounting. The role offers training and career development opportunities. Join us to innovate within the fund accounting space and make an impact with cutting-edge technology.

Benefits

Professional growth opportunities

Collaborative environment

Training and career development

Qualifications

• 3-5 years experience in fund accounting, NAV operations, middle office, or fund administration.
• Strong understanding of NAV calculations for various fund types.
• Proficient in writing complex SQL queries and optimizing them.

Responsibilities

• Engage with administrators to comprehend NAV workflows.
• Design and implement automated solutions using Python and SQL.
• Create real-time monitoring dashboards using Power BI.

Skills

Python programming

SQL proficiency

Power BI

Excel automation with openpyxl

Data manipulation with pandas

AI tools familiarity

NAV calculations understanding

Experience with financial instruments

Education

Bachelor's degree in Finance, Accounting, or Computer Science

Professional certifications such as CA, ACCA, CFA, or CAIA

Tools

Power BI

Excel

Python libraries (pandas, openpyxl, sqlite3)

SQL databases

Job description

Our client is seeking a Fund Accounting Analyst, NAV Automation Specialist to play a pivotal role in enhancing operational efficiency through automation. This is a full-time position with a unique opportunity to innovate within the fund accounting space, transitioning from traditional manual tasks to cutting-edge automation solutions using AI and data engineering tools.

Job Duties

• Engage with Jersey administrators to comprehend current NAV workflows and identify automation opportunities.
• Design and implement Python and SQL solutions to replace manual processes.
• Create Power BI dashboards for real-time monitoring.
• Build automated NAV workflows using Python libraries such as pandas, openpyxl, and sqlite3.
• Write complex SQL queries to extract and transform data from various fund accounting systems, including Paxus, Geneva, and SimCorp.
• Develop validation frameworks with tolerance checks to ensure data accuracy.
• Leverage AI tools to generate and refine code.
• Prepare formatted Excel deliverables and client reports.
• Calculate NAV for various fund types, including private equity, real estate, and open-ended funds.
• Process management fees, carried interest, and performance fee calculations.
• Reconcile positions across custodians, brokers, and internal systems.
• Prepare investor reports and regulatory filings.

Job Requirements

• Deep understanding of NAV calculations for open-ended and closed-ended funds, including asset valuation, expense accruals, and unit pricing.
• Working knowledge of various financial instruments, including equities, bonds, futures, options, and derivatives.
• Familiarity with fund structures such as master-feeder, series/class accounting, and offshore structures.
• Experience managing subscriptions, redemptions, capital calls, and investor reporting, with a background of 3-5 years in fund accounting, NAV operations, middle office, or fund administration.
• Proficient in Python programming, including data manipulation with pandas, Excel automation with openpyxl, and database management with sqlite3.
• Expertise in SQL, capable of writing complex queries, optimising queries, and understanding database logic.
• Advanced Excel skills, including complex formulas, data validation, and VBA programming.
• Experience with Power BI, including dashboard building and DAX measures.
• Strong familiarity with AI tools for generating and refining code.
• A bachelor's degree in Finance, Accounting, or Computer Science; professional certifications such as CA, ACCA, CFA, or CAIA preferred.
• Experience in a Jersey/offshore fund domicile is a strong plus, as is involvement in prior automation or technology transformation projects.

What You'll Love

This role offers the chance to play a key part in maintaining and enhancing the jurisdiction's reputation. You will work in a collaborative environment with opportunities to develop your skills in regulatory oversight, policy creation, and risk-based supervision. The organisation values professional growth and offers ample opportunities for training and career development.

Interested? Register today, confidentially, with one of our friendly and dedicated recruitment specialists by clicking here