Design, develop, and maintain ETL processes and workflows across 3rd-party data feeds, CRM data exhaust, and industry data / insights.
Optimize ETL processes for performance and scalability.
Maintain and update client data repositories to ensure accuracy and completeness, focusing on timely onboarding, QA, and automation of priority 3rd-party data feeds
Collaborate with USWA Client Data Management, data scientists, and business stakeholders to understand data requirements, improve data quality, and reduce time to market when new data feeds are received.
Partner with the central Aladdin engineering team on platform-level engagements (eg, Global Client Business Client Data Platform)
Ensure the seamless flow of data between internal and external systems.
Fix and resolve ETL job failures and data discrepancies.
Document ETL processes and maintain technical specifications.
Work with data architects to model data and ingest into data warehouses (eg, Client Data Platform)
Engage in code reviews and follow development standard methodologies.
Stay updated with emerging ETL technologies and methodologies.
Qualifications:
Bachelors or masters Degree in Computer Science, Engineering or a related field.
Eligibility Criteria:
4+ years of experience in ETL development and data warehousing.
Proficiency in ETL tools such as Informatica, Talend, or SSIS.
Experience with building ETL processes for cloud-based data warehousing solutions (eg, Snowflake).
In-depth working knowledge of Python programming language including libraries for data structures, reporting templates etc Extensive knowledge of writing Python data processing scripts and executing multiple scripts via batch processing.
Proficiency in programming languages like Python, Java, or Scala.
Experience with database management systems like SQL Server, Oracle, or MySQL.
Knowledge of data modeling and data architecture principles.
Excellent problem-solving and analytical skills.
Ability to work in a fast-paced and dynamic environment.
Strong communication skills and ability to work as part of a team.
Experience in the asset management or financial services sector is a plus.
