Data Engineer

The Impact :

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-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.