Data Analyst

Must-Have

• Proficient SQL skills with the ability to write and optimize queries.

• Capital markets experience, specifically in equity derivatives (EQD) and equity securities (EQS).

• Strong finance and accounting knowledge, including GL and SGL processes.

• Expertise in data analysis and ability to interpret financial datasets.

• Experience in business analysis, requirement gathering, and process optimization.

• Excellent communication and stakeholder management skills.

Proficiency in Excel, BI tools, or other data visualization platforms is a plus.

Good-to-Have

• Good to have BI tools, or other data visualization platforms is a plus.

• Good to have knowledge in Big data Concepts.

• Good to have knowledge in Java/Python/Spark.

Key Expectations from the Role

SQL & Data Analysis:

· Write and optimize SQL queries to extract, transform, and analyze data from multiple sources.

· Perform data validation, cleansing, and reconciliation to ensure accuracy.

· Generate reports and dashboards for business insights.

Capital Markets & Financial Knowledge:

· Apply knowledge of equity derivatives (EQD) and equity securities (EQS) to analyze trading and market data.

· Work with stakeholders to understand financial products, risk exposure, and trade lifecycle processes.

· Collaborate with teams to optimize trade data and reporting systems.

· Finance & Accounting:

· Understand general ledger (GL) and sub-ledger (SGL) accounting processes.

· Reconcile financial data and support accounting teams in maintaining data integrity.

· Assist in financial reporting, audits, and regulatory compliance.

Business Analysis:

· Gather and document business requirements for data-driven initiatives.

· Work with cross-functional teams to improve data workflows and reporting frameworks.

· Support business stakeholders in decision-making through data insights.

· Identify inefficiencies and propose solutions to enhance operational effectiveness.