Sr. Data Analytics Engineer - Internal Audit

Vanguard; Malvern (Chester County); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Vanguard is seeking a data engineering and automation-minded professional for our Internal Audit & SOX IAS team in Malvern, PA. You will design data pipelines and automate analytics infrastructure to improve assurance and efficiency across the control environment.

The role emphasizes Python/SQL, data visualization, and cloud-based solutions with collaboration across analysts, engineers, and IT. A hybrid work model applies with commutable access to our Malvern office.

Qualifications

• BS or higher in a related field or equivalent experience in data analytics and engineering.
• Strong coding, data modeling, and pipeline development skills.
• Experience designing scalable data solutions and analytics infrastructure.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL processes for analytics and automation.
• Translate business needs into technical specs and data models.
• Develop automation tools and scripts to streamline audit workflows.
• Support reporting front-ends using Streamlit hosted on cloud infrastructure.
• Collaborate with IT and analytics teams on cloud and data platforms.
• Identify opportunities for process improvement via automation and data insights.
• Stay current with GenAI, RPA, AI/ML and related technologies.

Skills

Python

SQL

Data engineering

Data visualization

Automation development

Education

Bachelor's degree in related field

Tools

Tableau

Power BI

AWS

SQL Server

Streamlit

Power Apps

Job description

Vanguard’s Internal Audit & SOX (IAS) department has an exciting opportunity in our Automation and Analytics team. We’re looking for a tech-savvy, innovative individual who’s passionate about building scalable data solutions and engineering robust analytics infrastructure. This role is a crucial part of our forward-thinking, dynamic team and is key to delivering automated utilities and data pipelines that provide greater assurance to the organization, increase stakeholder productivity, and deliver deeper insights into the operating effectiveness of our control environment—all of which ultimately support Vanguard’s purpose: to take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.

You’ll collaborate with a diverse and talented team of centralized and decentralized data analysts, and work closely with our analytics infrastructure and solutions using the latest technologies. The ideal candidate will have a strong background in data engineering, technical communication, and automation development, with hands-on experience in System frontend development, Streamlit, cloud platforms, Python, and data pipeline design.

Responsibilities

• Data Engineering & Pipeline Development: Design, build, and maintain scalable data pipelines and ETL processes to support analytics and automation initiatives. Ensure data quality, integrity, and performance across systems.
• Requirements Gathering and Technical Design: Partner with stakeholders to translate business needs into technical specifications. Design data models, process flows, and system integrations aligned with strategic objectives.
• Automation Development: Develop and deploy automation tools and scripts (e.g., Python, SQL, Power Apps) to streamline audit and business processes, improve efficiency, and reduce manual effort.
• Data Visualization: Support the development of reporting front-end interfaces using tools such as Streamlit, hosted on AWS infrastructure. Collaborate with analytics and audit teams to design user-friendly applications that deliver insights and enable interaction with automated utilities and data pipelines.
• Infrastructure & Systems Integration: Collaborate with IT and analytics teams to implement integrated solutions using cloud platforms (e.g., AWS), databases (e.g., SQL Server), and identity systems (e.g., Active Directory).
• Process Optimization: Identify and implement opportunities for process improvement through automation and data-driven insights within internal audit workflows.
• Innovation & Technology Adoption: Stay current with emerging technologies (e.g., GenAI, RPA, AI/ML) and recommend innovative solutions that align with organizational strategies.

What It Takes

• Proficiency in Python, SQL, and data engineering tools and frameworks.
• Experience with data visualization platforms (e.g., Tableau, Power BI), cloud infrastructure (e.g., AWS), and database systems (e.g., SQL Server).
• Familiarity with RPA, AI/ML concepts, and modern data architecture.
• Strong communication skills to bridge technical and non-technical stakeholders.
• Ability to thrive in a fast-paced, ambiguous environment and manage multiple priorities.
• Strong planning and organizational skills with a focus on execution and delivery.

Qualifications

• Minimum of 5 years related technical experience; some working knowledge of audit, risk, and controls.
• Undergraduate degree in a related field or the equivalent combination of training and experience (e.g., MIS, Information Technology, Data Sciences, Data / Business Analytics).

Special factor

• This is a hybrid role - candidates must be commutable to Vanguard's Malvern, PA office.

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.