Job Function Summary -
The role involves gathering and running data analytics to improve middle‑office and operational processes, identifying gaps and risks in procedures, and ensuring the accuracy of regulatory reports. The successful candidate will bring a robust technical background to develop ETL workflows, data engineering solutions, business intelligence solutions, and process re‑engineering documentation as part of the wider Operations & Middle Office organization.

The candidate will work closely with key stakeholders and senior management across departments and regions to design and implement data projects and initiatives, ensuring timely delivery. The candidate will also work in parallel with the global Operations Control team and with internal resources and external counterparties to drive continuous process improvements.

Principal Responsibilities -
- Design, develop, and maintain backend services and APIs (primarily in Python) integrated with internal systems and databases.
- Build and operate ETL/data pipelines to support analytics, risk controls,



and regulatory/management reporting across the trade lifecycle.
- Perform data extraction, transformation, and analysis using Python (pandas, NumPy) and SQL, ensuring data quality and integrity.
- Generate reports on trades, positions, and exposures for internal stakeholders and regulatory requirements, maintaining accuracy and timeliness in reporting.
- Automate manual reporting processes through the development of SQL/Python solutions and, where applicable, dashboards (e.g., Tableau).
- Optimize and maintain databases, including query tuning, storage and capacity monitoring, naming conventions, index/schema optimization, and stored procedure reviews.
- Coordinate and work closely with internal teams across Operations, IT, Legal, Compliance, and Finance globally, as well as with external parties, to deliver projects, regulatory reports, and control frameworks.
- Produce daily, weekly, and monthly reporting

📌 Data Analytics Specialist (Bengaluru)
🏢 Millennium
📍 Bengaluru