Financial Data Integrity & Reconciliation Analyst

Canopy; Philippines; On-site; PHP 400,000 - 700,000; Full time

Job summary

Canopy is seeking a Data Operations Analyst to manage data integrity for financial and investment data, delivering reliable reporting to stakeholders. You will ensure accuracy in data extraction and aggregation, and drive improvements in reconciliation and data security.

Key duties include validating data across balances, reconciling trading history and holdings, and collaborating with Sales, Client Success, and Product teams to answer data-related questions.

Qualifications

• Bachelor's degree in Finance, Accounting, Information Systems, or related field.
• Advanced Excel skills and data analysis proficiency.
• Experience with Python and SQL is a plus.
• Familiarity with data wrangling tools such as Tableau or Trifacta is preferred.

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 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.

Skills

Excel

Python

SQL

Tableau

Education

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

Tools

Tableau

Trifacta

Job description

Canopy is seeking a Data Operations Analyst to manage data integrity for financial and investment data, delivering reliable reporting to stakeholders. You will ensure accuracy in data extraction and aggregation, and drive improvements in reconciliation and data security.

Key duties include validating data across balances, reconciling trading history and holdings, and collaborating with Sales, Client Success, and Product teams to answer data-related questions.