Senior Data Engineer

The Transaction Cost Analysis (TCA) team seeks to provide decision support and decision automation to improve outcomes in the investment process by minimizing transaction costs, via quantitative and data-driven research. If you are looking to work in a lively environment while learning and developing your AWS and python skills to help the trading desks reduce transaction costs, then this opportunity is for you.

In this role, you will:

• Provide senior level system analysis, design, development, and implementation of applications and databases. Integrate third party products.
• Translate technical specifications into code for complex new or enhancement projects for internal clients. Write programs, develop code, test artifacts, and produce reports. Employ software development techniques to ensure tests are implemented in a way that support automation.
• Elevate code into the development, test, and production environments on schedule. Provide follow-up production support. Submit change control requests and documents.
• Thoroughly understand software development methodology. Thoroughly understand development architecture standards. Train and mentor staff with less experience. Resolve elevated issues.
• Participate in design, code, and test inspections throughout the life cycle to identify issues. Explain technical considerations at related meetings, including those with internal clients. Perform systems analysis activities.
• Thoroughly understand client business functions and technology needs. Has a broad understanding of Vanguard’s technologies, tools, and applications, including those that interface with business area and systems.
• Collaborate with cross functional team members, and communicate systems issues at the appropriate technical level for each audience.
• Thoroughly understand and align with Information Technology and Information Security policies and procedures, and verify that deliverables meet requirements.

Additional responsibilities:

• Writes ETL (Extract / Transform / Load) processes.
• Troubleshoot software and processes for data consistency and integrity. Integrates 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. Write complex programs, ad hoc queries, and reports. Ensure that all code is well structured, includes sufficient documentation, and is easy to maintain and reuse.
• Partner with internal clients to gain an enhanced understanding of business functions and informational needs. Gain expertise in tools, technologies, and applications/databases in specific business areas and company-wide systems.
• Lead all phases of solution development. Explain technical considerations at related meetings, including those with internal clients and less experienced team members.
• Test code thoroughly for accuracy of intended purpose. Review end product with the client to ensure adequate understanding. Provide data analysis guidance as required.
• Design and conduct training sessions on tools and data sources used by the team and self provisioners. Provide job aids to team members and business users.
• Test and implement new software releases through regression testing. Identifies issues and engages with vendors to resolve and elevate software into production.

What it takes:

• Minimum of five years related work experience, with at least one year of development experience.
• Undergraduate degree or equivalent combination of training and experience.

Skills that will make an impact:

• Python, PySpark programming experience
• Experience with pandas
• Experienced with SQL/Presto/HIVE/Spark
• Experience with Key AWS services/components:  EMR , Lambda, Glue ETL, Step Functions, s3,ECS, IAM, RDS PostgreSQL, CloudWatch Events/Event Bridge, Athena, SNS, SQS, VPC
• Knowledge of Tableau
• Exposure to designing and building web environments on AWS
• Good analytical skills
• Good understanding of source control, unit testing, test driven development, and CICD
• Able to write clean, maintainable code, and read code created by others.

Special Factors

Sponsorship

Vanguard is offering visa sponsorship for this position.

About Vanguard

We are Vanguard. Together, we’re changing the way the world invests.

For us, investing doesn’t just end in value. It starts with values. Because when you invest with courage, when you invest with clarity, and when you invest with care, you can get so much more in return. We invest with purpose – and that’s how we’ve become a global market leader. Here, we grow by doing the right thing for the people we serve. And so can you.

We want to make success accessible to everyone. This is our opportunity. Let’s make it count.

Inclusion Statement

Vanguard’s continued commitment to diversity and inclusion is firmly rooted in our culture. Every decision we make to best serve our clients, crew (internally employees are referred to as crew), and communities is guided by one simple statement: “Do the right thing.”

We believe that a critical aspect of doing the right thing requires building diverse, inclusive, and highly effective teams of individuals who are as unique as the clients they serve. We empower our crew to contribute their distinct strengths to achieving Vanguard’s core purpose through our values.

When all crew members feel valued and included, our ability to collaborate and innovate is amplified, and we are united in delivering on Vanguard’s core purpose.

Our core purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

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.