Data Engineer, Specialist

Vanguard’s IT Data & Analytics team is seeking a Data Engineer to design, build, and scale reliable data pipelines and reusable datasets that power IT reporting, dashboards, analytics products, and AI-ready data. In this role, you will partner with engineers, analysts, and technology stakeholders to ingest, transform, validate, and publish high‑value data while improving usability and reducing manual effort. You will contribute to modern data engineering practices and help elevate data quality, governance, and accessibility across the organization. This is an opportunity to influence how data products are built and consumed across IT. This Hybrid Role (in office Tues‑Wed‑Thurs) is based in Charlotte, NC, Dallas, TX, Scottsdale, AZ, or Malvern, PA (HQ) Responsibilities: Design, build, and maintain scalable ETL/ELT pipelines for critical IT data sources Develop curated, high-quality datasets to support reporting, dashboards, and analytics products Write, optimize, and maintain SQL and Python code for transformation, automation, and performance Deliver cloud-based data solutions using AWS services such as Glue, S3, and Athena Partner with analysts, product managers, and stakeholders to translate data needs into practical solutions Implement data quality checks, validation rules, monitoring, and documentation to ensure trusted data Troubleshoot pipeline issues, investigate anomalies, and resolve data defects end-to-end Apply engineering best practices including version control (Git), code reviews, testing, and CI/CD deployment Contribute to standards for data lineage, governance, documentation, and production support Support the evolution of reusable data products and self-service analytics capabilities Education & Experience: Bachelor’s degree or equivalent combination of education and relevant experience 3–5+ years of experience in data engineering, analytics engineering, or data platform development Strong proficiency in SQL and Python for data transformation and automation Hands-on experience building and supporting ETL/ELT pipelines Experience with AWS or similar cloud data platforms Solid understanding of data modeling, curated datasets, and BI/reporting use cases Demonstrated problem-solving skills and commitment to data quality and reliability Ability to communicate effectively with both technical and non-technical stakeholders Experience working in collaborative, agile team environments Preferred: Experience with AWS Glue, PySpark, Athena, Dremio, Parquet Exposure to BI and visualization tools such as Tableau, Power BI, or Streamlit Familiarity with Jira, GitHub, ServiceNow, or technology operations data Interest in building reusable data products and enabling self-service analytics Exposure to AI/ML concepts, LLMs, or agent-based tools to enhance data engineering workflows and automation Special Factors Sponsorship Vanguard is not offering visa sponsorship for this position. About Vanguard At Vanguard, we don't just have a mission—we're on a mission. To work for the long-term financial wellbeing of our clients. To lead through product and services that transform our clients' lives. To learn and develop our skills as individuals and as a team. From Malvern to Melbourne, our mission drives us forward and inspires us to be our best. How We Work Vanguard has implemented a hybrid working model for the majority of our crew members, designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection. We believe our mission-driven and highly collaborative culture is a critical enabler to support long-term client outcomes and enrich the employee experience. Vanguard, one of the world's leading investment management companies, serves individual investors, institutions, employer-sponsored retirement plans, and financial professionals. We have a diverse and talented crew with a culture that promotes teamwork, along with an unwavering focus on serving our clients' best interests. This website uses "cookies" to distinguish you from other users. A cookie is a small file of letters and numbers placed on your computer or device. This helps us to provide you with a good experience when you browse our website and also allows us to improve our site and services. The cookies are stored locally on your computer or mobile device. To accept cookies you can continue browsing as normal. Or you can go to our Privacy Policy to read more information and learn how to change your preferences.