Financial Data Analyst Wealth Tech

Canopy; Manila; On-site; PHP 400,000 - 560,000; Full time

Job summary

Canopy is seeking a Data Operations Analyst to manage data operations for financial data, ensuring accuracy, integrity, and security. You will provide reliable reporting to stakeholders and collaborate with Sales, Client Success and Product teams.

Responsibilities include data extraction and aggregation of portfolio data, reconciliation of trading history and end-of-day holdings, identification and escalation of aging exceptions, and process improvements. Fresh graduates are welcome to apply.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Systems, or related field; fresh graduates welcome.
• Advanced proficiency in Microsoft Excel is a must; Python/SQL is a bonus.
• Strong analytical and problem-solving skills; ability to work with large data sets and tight deadlines.

Responsibilities

• Ensure the accuracy, completeness, and consistency of data extraction and aggregation of complex investment portfolio data using our proprietary aggregation software.
• Identify, investigate and resolve aggregated data inconsistencies and errors across all balances.
• Dig deeply into trading history and end-of-day holdings data to perform reconciliation and identify account discrepancies.
• Review recon output and escalate aging data exceptions in a timely manner.

Skills

Excel

Python

SQL

Data analysis

Attention to detail

Collaboration

Education

Bachelor's degree in Finance, Accounting, Information Systems, or related field

Tools

Tableau

Trifacta

Aggregation software

Job description

Job Description:

The Data Operations Analyst manages all aspects of data operations within the team, ensuring the accuracy, integrity, and security of financial and investment data. This role provides reliable reporting to stakeholders and requires strong technical skills, attention to detail, and collaborative abilities.

Data Management and Processing:

• Ensure the accuracy, completeness, and consistency of data extraction and aggregation of complex investment portfolio data using our proprietary aggregation software.
• Identify, investigate and resolve aggregated data for inconsistencies and errors across all balances
• Dig deeply into trading history and end of day holdings data to perform reconciliation, identify account discrepancies, and find potential solutions.
• Review recon output and ensure timely identification and escalation of aging exceptions.

Product and Process development:

• Actively contribute to the enhancement of internal systems to drive efficiency, accuracy, and timeliness of data aggregation
• Help build tools and processes to improve and scale the data reconciliation competency.
• Work with the product team on new features to understand cost and process impacts
• Ensure the security and privacy of sensitive data in compliance with regulatory requirements.

Collaboration and Communication:

• Act as escalation point for queries from Sales, Client Success & Product team to resolve clients data-related questions
• Liaise with custodian representatives to address gaps found in financial data sources
• Provide training and support to staff on data-related processes and systems

• Bachelor's degree in Finance, Accounting, Information Systems, or a related field, Fresh Graduates are welcome to apply
• Advanced proficiency in Microsoft Excel is a must, proficiency in Python, SQL is a bonus.
• Strong analytical skills and problem-solving skills
• Understanding of financial instruments across asset classes.
• A willingness to work with large data sets, approaches it as if it's a fun puzzle to solve.
• Meticulous attention to detail and ability to work under pressure.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Proactive in seeking workflow improvements.
• Experience with Tableau, Trifacta, or other data wrangling tools is highly preferred.

Requirements: