Data Engineer, Specialist (The Vanguard Group, Inc. / Malvern, PA) -- Write ETL (Extract / Transform / Load) processes, design database systems and, develop tools for real-time and offline analytic processing; troubleshoot software and processes for data consistency and integrity; integrate complex and large-scale data from a variety of sources for business partners to generate insight and make decisions; translate business specifications into design specifications and code; responsible for writing complex programs, ad hoc queries, and reports; ensure that all code is well structured, includes sufficient documentation, and is easy to maintain and reuse; lead all phases of solution development; explain technical considerations at related meetings, including those with internal clients and less experienced team members; educate and develop junior data engineers on the team while applying quality control to their work; develop data engineering standards and contribute expertise to other data expert teams across company. Requires Master's in Computer Science, Computer Engineering, Electrical and Computer Engineering, Electronic(s) Engineering, or closely related field and two years of experience in job offered or in IT position(s) including Data Developer; or Bachelor's and five years of experience. Background in education, training or experience must include AWS (AWS Glue, S3, Athena, CloudWatch, IAM, SNS, EMR, EC2, Lambda, DynamoDB), SQL, Python, and PySpark. Company operates on hybrid model with three days in office and work-from-home available two days.