Data Analyst

About Arcana
Arcana is a portfolio intelligence platform used by hedge funds and asset managers to analyze performance and risk. We’re rethinking the tools institutional investors rely on—and we’re hiring analysts who want to help drive that transformation.

Role Overview
We are looking for a Data Analyst to work with large-scale financial datasets, ensure high data quality, and deliver actionable insights through dashboards and reports.
The role focuses on building and maintaining robust data quality frameworks and collaborating closely with internal and external stakeholders at scale.

Key Responsibilities
Manage and analyze large volumes of daily financial data
Design, implement, and continuously improve data quality frameworks
Perform data validation, reconciliation, and monitoring
Resolve Level 1 & Level 2 data quality issues; escalate complex issues to Data Science teams
Use SQL and Python for data analysis, scripting, and development
Build and maintain dashboards and reports for business insights
Work with large-scale datasets (100TB+) covering 100K+ global companies
Apply statistical techniques to monitor data accuracy and anomalies
Collaborate with cross-functional teams and share insights with stakeholders

Requirements
Strong understanding of data quality, validation, and reconciliation concepts
Advanced SQL skills (complex queries, joins, performance optimization)
Proficiency in Python for data analysis and scripting

Experience with dashboarding and reporting tools
Ability to work in large-scale / big data environments
Working knowledge of statistics for data monitoring and validation
Strong communication and stakeholder management skills
Experience handling data from multiple and diverse sources

Qualifications
Bachelor’s degree in BCA / MCA / Engineering
CGPA: 8+
Prior experience in Finance / Fin Tech preferred
Exposure to financial datasets is a plus