- Design, build, and measure complex ELT jobs to process disparate data sources and form a high integrity, high quality, clean data asset.

- Executes and provides feedback for data modeling policies, procedure, processes, and standards.

- Assists with capturing and documenting system flow and other pertinent technical information about data, database design, and systems.

- Develop comprehensive data quality standards and implement effective tools to ensure data accuracy and reliability.

- Collaborate with various Investment Management departments to gain a better understanding of new data patterns.

- Collaborate with Data Analysts, Data Architects, and BI developers to ensure design and development of scalable data solutions aligning with business goals.

- Translate high-level business requirements into detailed technical specs.

Experience :

- 7 to 9 years of experience with data analytics, data modelling, and database design.

- 3+ years of coding and scripting (Python, Java, Scala) and design experience.

- 3+ years of experience with Spark framework.

- 5+ Experience with ELT methodologies and tools.

- 5+ years mastery in designing, developing, tuning, and troubleshooting SQL.

- Knowledge of Informatica Powercenter and Informatica IDMC.

- Knowledge of distributed, column- orientated technology to create high-performant database technologies like - Vertica, Snowflake.

- Strong data analysis skills for extracting insights from financial data

- Proficiency in reporting tools (e.g., Power BI, Tableau)

Technical Skills :

- Domain knowledge of Investment Management operations including Security Masters, Securities Trade and Recon Operations, Reference data management, and Pricing.

- Familiarity with regulatory requirements and compliance standards in the investment management industry.