Description

You will build data structures, manage platform integrations, and optimize data processes to support Business Intelligence and Reporting initiatives.

This role is on-site.

Responsibilities

• Create data structures for reporting systems and develop data exchanges between platforms.
• Build real-time API-based data ingestion and integration solutions using iPaaS offerings.
• Develop scheduled batch processes for data integration using ETL tools.
• Optimize existing and new data processes, including indexing and query tuning.
• Implement data transformation rules through source-to-target mapping.

Required Skills

• Extensive hands-on experience with MS SQL Server.
• Very strong knowledge of SQL and RDBMS concepts.
• Expertise in developing stored procedures, functions, and scripts.
• Deep understanding of ETL concepts and transformation rules.
• Proven experience with Data Warehousing, MDM, or Enterprise Data Lake projects.
• Expertise in database and query performance optimization.
• Experience with data modeling and database design.

Preferred Skills

• Experience with Big Data, unstructured data sources (AWS), Databricks, or Airflow.
• Experience with MuleSoft or Informatica.
• Background in the Investment Firm industry or Capital Markets domain.

Key Skills

Education

Any graduate