Fund Accounting - Data Analyst

HedgeServ; Philippines; On-site; PHP 600,000 - 900,000; Full time

Job summary

HedgeServ is seeking a Fund Accounting – Data Analyst to improve processes across the business units. The role involves learning the financial services and hedge fund industry and applying technology within it.

You will develop ETL solutions, automate reporting, and write Python scripts to streamline data workflows. Candidates should have 3+ years in fund accounting or finance data roles, strong Python/SQL skills, advanced Excel, and the ability to work with large datasets.

Qualifications

• Degree in Business, Accounting, Finance, or related Data Analyst fields.
• Experience in Python and SQL.
• Advanced Excel skills.
• Strong analytical skills with large datasets if possible.

Responsibilities

• Develop and implement ETL processes from diverse sources into accounting and reporting systems.
• Automate internal fund accounting and other operational processes.
• Create Python scripts for data automation and reporting.
• Transform legacy Excel processes into Python-based workflows.
• Build and maintain reconciliations between financial sources and datasets.
• Test the product in controlled environments before production deployment.

Skills

Python

SQL

Excel (Advanced)

Data analysis

Education

Business/Accounting/Finance related data analyst degree

Tools

Pandas

NumPy

Job description

Department Overview:

The Business Solutions Group supports process automation, data extraction, and customized solutions across the various business units. Externally, BSG works with clients to deliver innovative data solutions, and customized reporting requirements. The scope of work is entirely project based, so there will always be new challenges and problems for our team to solve. Our tight-knit group fosters collaboration and open communication for each project we take on.

Job Description:

A Fund Accounting – Data Analyst is responsible for observing, documenting, and leveraging technology to improve processes across the various business units. A successful candidate will be able to learn about the financial services and hedge fund industry, in addition to the application of technology and programming within the industry.

Key Responsibilities:

• Develop and implement ETL processes from diverse sources into our accounting and reporting systems.

• Engage, improve, and automate internal Fund Accounting and other operational processes used by business teams

• Leverage applicable technologies through the development of python scripts and other technological innovations.

• Automate key operational reports by converting legacy excel-based processes into python scripts

• Applying new technologies to develop solutions to new problems as they arise, while continually addressing current issues

• Produce clean and efficient code based on given specifications.

• Build and maintain reconciliations between various financial sources and datasets.

• Troubleshoot, debug, and upgrade existing scripts.

• Testing the product in controlled, real-world situations before deploying to production

• Identifying, rectifying, and streamlining inefficiencies and at-risk processes in current systems by coordinating with internal stakeholders

• Take ownership of special projects on an as-needed basis and deliver them in a short turn-around.

• Stay up to date with industry trends, emerging technologies and best practices in data analysis and financial services to drive innovation and efficiency.

Job Requirements for the role:

Education:

• Degree in Business, Accounting, Finance, or other related Data Analyst fields

Experience:

• Minimum of 3 years' experience in fund Accounting, data analysis or other related finance experience

• Experience in Python, SQL, or other relevant coding language

• Advanced excel skills

• Strong analytical skills with the ability to manipulate large datasets using Pandas, NumPy, SQL or other relevant tools.

Personal skills:

• High attention to detail and problem-solving skills, with an ability to multi-task, and work well in a team environment.

• Must be organized and flexible to work well with frequent priority changes.

• Must be able to self-start and work independently.

• Ability to find new, creative, and unconventional solutions to problems.

• Excellent written and verbal communication skills.

• Available to accommodate U.S. and European time zones.