Data Engineer

Location: Malvern, PA (Hybrid- 3 days a week onsite & must be willing to relocate and be onsite on day 1)

** Must be willing to take onsite interview at Malvern, PA- so Local/ Tristate candidates only**

If the candidate cannot do onsite interview, then please DO NOT submit the resumes

Responsibilities

Vanguard's Trading Analytics and Strategy (TAS) team works with our global trading desks to optimize their trading strategies, saving millions of dollars for clients every year. The team works with our trader and portfolio manager partners, across asset classes and passive as well as active mandates, to conduct data-driven analyses and build tools to help shape our trading strategy. As an Engineer on the full stack team, you will be dedicated to help design, implement, and maintain a modern, robust, and scalable platform which will enable the TAS team to meet the increasing demands from the various trading desks.

Qualifications

• 1. Proficiency in Python programming
• 2. Strong expertise in SQL, Presto, HIVE, and Spark
• 3. Knowledge of trading and investment data
• 4. Experience in big data technologies such as Spark and developing distributed computing applications using PySpark
• 5. Experience with libraries for data manipulation and analysis, such as Pandas, Polars and NumPy
• 6. Understanding of data pipelines, ETL processes, and data warehousing concepts
• 7. Strong experience in building and orchestrating data pipelines
• 8. Experience in building APIs Write, maintain, and execute automated unit tests using Python
• 9. Follow Test-Driven Development (TDD) practices in all stages of software development
• 10. Extensive experience with key AWS services/components including EMR, Lambda, Glue ETL, Step Functions, S3, ECS, Kinesis, IAM, RDS PostgreSQL, Dynamodb, Timeseries database, CloudWatch Events/Event Bridge, Athena, SNS, SQS, and VPC
• 11. Proficiency in developing serverless architectures using AWS services
• 12. Experience with both relational and NoSQL databases
• 13. Skills in designing and implementing data models, including normalization, denormalization, and schema design
• 14. Knowledge of data warehousing solutions like Amazon Redshift
• 15. Strong analytical skills with the ability to troubleshoot data issues
• 16. Good understanding of source control, unit testing, test-driven development, and CI/CD
• 17. Ability to write clean, maintainable code and comprehend code written by others
• 18. Strong communication skills
• 19. Proficiency in data visualization tools and ability to create visual representations of data, particularly using Tableau