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.

The Minimum Qualifications

Education: Bachelor’s or Master’s degree in Computer Science, Information Systems or related field.

Experience:

• 7-9 years of experience with data analytics, data modeling, 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 Power center 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).