Financial Data Ops Analyst: Reconciliation & Insights

Canopy; Singapore; On-site; SGD 55,000 - 85,000; Full time

Job summary

Canopy is seeking a Data Operations Analyst to manage data operations for investment portfolios, ensuring accuracy, integrity, and security of financial data.

You will extract, aggregate, and reconcile portfolio data, collaborate with Sales, Client Success and Product, and drive process improvements while maintaining regulatory compliance.

Strong Excel, Python/SQL, and data-wrangling tools like Tableau or Trifacta are preferred; fresh graduates welcome.

Qualifications

• Bachelor’s degree in Finance, Accounting, Information Systems, or related field.
• Advanced proficiency in Microsoft Excel; Python and SQL a bonus.
• Strong analytical and problem-solving abilities.
• Understanding of financial instruments across asset classes.
• Willingness to work with large data sets and approach as 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 preferred.

Responsibilities

• Manage data extraction, aggregation, and quality checks for complex portfolio data.
• Reconcile trading history and end-of-day holdings; identify discrepancies and solutions.
• Review reconciliation outputs and escalate aging exceptions.
• Contribute to tools and processes to scale data reconciliation.
• Work with product on new features and assess cost/impact.
• Ensure data security and regulatory privacy compliance.

Skills

Excel

Python

SQL

Analytical skills

Problem solving

Communication

Teamwork

Independent work

Proactive

Tableau

Trifacta

Data wrangling tools

Education

Bachelor’s degree

Tools

Tableau

Trifacta

Proprietary aggregation software

Job description

Canopy is seeking a Data Operations Analyst to manage data operations for investment portfolios, ensuring accuracy, integrity, and security of financial data.

You will extract, aggregate, and reconcile portfolio data, collaborate with Sales, Client Success and Product, and drive process improvements while maintaining regulatory compliance.

Strong Excel, Python/SQL, and data-wrangling tools like Tableau or Trifacta are preferred; fresh graduates welcome.