Fund Accounting Analyst, NAV Automation Specialist

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

Job summary

A reputable financial services organization in the UK is seeking a Fund Accounting Analyst/NAV Automation Specialist to enhance operational efficiency through automation. This full-time role involves designing Python and SQL solutions, creating Power BI dashboards, and implementing complex NAV workflows to optimize fund accounting processes. Candidates should have a strong background in NAV calculations and programming skills in Python and SQL.

Benefits

Professional growth opportunities

Training and career development

Qualifications

• 3-5 years in fund accounting, NAV operations, or fund administration required.
• Experience with financial instruments like equities, bonds, futures, options.
• Familiar with fund structures such as master-feeder and offshore structures.

Responsibilities

• Engage with administrators to identify NAV workflows for automation.
• Implement Python and SQL solutions to automate manual tasks.
• Create Power BI dashboards for real-time fund monitoring.

Skills

NAV calculations

Python programming

SQL expertise

Excel automation

Power BI dashboard building

Education

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

Tools

Python libraries (pandas, openpyxl, sqlite3)

Power BI

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