Bachelor's or Master’s Degree in Computer Science, Engineering or a related field
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 (e.g., 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
Responsibilities
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 (e.g., 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 (e.g., Client Data Platform)
Engage in code reviews and follow development standard methodologies
Stay updated with emerging ETL technologies and methodologies