The Data Analyst will manage and analyze large financial datasets, design data quality frameworks, perform data validation, and deliver insights through dashboards and reports while collaborating with various stakeholders.
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.
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.
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 / FinTech preferred
- Exposure to financial datasets is a plus
Similar Jobs
Artificial Intelligence • Analytics
Designs and maintains Microsoft Fabric data pipelines, Lakehouse and Warehouse solutions, layered data architectures, dimensional models, and scalable ETL/ELT processes. Develops SQL queries, Python transformation scripts, and data-quality validations using Pandas, NumPy, PySpark, and Requests. Builds Power BI-ready datasets, supports KPI and metric definitions, partners with stakeholders on analytics requirements, and promotes governance, lineage, performance, and reporting consistency.
Top Skills:
SparkCi/CdDelta TablesGitMicrosoft Azure Data ServicesMicrosoft Fabric Data FactoryMicrosoft Fabric LakehouseMicrosoft Fabric WarehouseNumpyPandasPower BIPysparkPythonRequestsSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Supports liquidity regulatory reporting controls by documenting data flows, business data elements, lineage, transformations, and controls from booking systems to reporting platforms. Performs SQL-based data analysis, test-case development, functional and business testing, quality remediation, root-cause analysis, requirements management, stakeholder coordination, and management reporting. Contributes to implementation activities, change control, documentation standards, and training junior team members.
Top Skills:
SQLVBA
Security • Software
Supports hosted e-discovery platforms by loading and transforming data, creating databases and user accounts, configuring permissions, investigating client technical inquiries, and assisting customers through phone, email, and screen sharing. The role also manages internal service-level tasks, collaborates with Engineering, IT, Application, and Project Management teams, and provides platform walkthroughs when needed.
Top Skills:
Custom PluginsE-Discovery ToolsFlat FilesExcelMS OfficeRelativity
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
