Fund Accounting - Data Analyst

HedgeServ Corporation; Metro Manila; On-site; PHP 600,000 - 900,000; Full time

Job summary

HedgeServ Corporation seeks a Fund Accounting – Data Analyst to observe, document, and improve processes using technology within the hedge fund industry. The role requires learning financial services concepts and applying programming to drive efficiency.

Focus areas include ETL development, automation of reports, and building reconciliations across data sources. Must work US hours and collaborate across teams.

Qualifications

• Degree in Business, Accounting, Finance, or related data analyst field.
• Minimum 3 years in Fund Accounting, data analysis, or related finance role.
• Strong Python and SQL skills with advanced Excel proficiency.

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 technologies through development of Python scripts and other innovations.
• Automate key operational reports by converting legacy Excel processes into Python scripts.
• Apply new technologies to address problems and improve current systems.
• Produce clean, efficient code based on specifications.
• Build and maintain reconciliations between financial sources and datasets.
• Troubleshoot, debug, and upgrade existing scripts.
• Test the product in controlled real-world situations before deployment.
• Identify and streamline inefficiencies in collaboration with stakeholders.
• Own special projects and deliver them on tight turn-around.
• Stay current with industry trends to drive innovation.

Skills

Python

SQL

Excel

Pandas

NumPy

Education

Bachelor's degree in Business, Accounting, Finance, or related Data Analyst fields

Tools

Python scripting

SQL databases

Excel (Advanced)

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.

Please note that this role requires working U.S. hours.

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:

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 role.
• 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. or European time zones.