Data Analyst, Specialist

Title: Data Analyst, Specialist

Location:

Charlotte, NC

Scottsdale, AZ

Malvern, PA

Job Description:

Join the Compliance Risk & OGC Operational Reporting (CROR) Data Domain team and help modernize how Compliance, Risk, and Legal leaders access and use data.

This role sits at the intersection of data analytics, analytics engineering, and data product development. You will leverage SQL, Python, AWS, and modern analytics technologies to build scalable data products, automate reporting processes, and deliver actionable insights that support regulatory oversight, risk management, and operational decision-making.

Successful candidates are curious, technically minded problem-solvers who enjoy building solutions, working with large datasets, and partnering with stakeholders to turn business challenges into data-driven outcomes.
What You'll Do

• Build and support data products that enable self-service reporting and analytics.

• Develop SQL- and Python-based solutions to automate data preparation, reporting, and monitoring processes.

• Analyze and validate data from multiple sources to ensure accuracy, quality, and reliability.

• Partner with Compliance, Risk, Legal, and Technology stakeholders to understand business needs and translate requirements into scalable analytical solutions.

• Design and enhance dashboards, visualizations, and lightweight applications that improve access to trusted data and insights.

• Work within AWS-based data environments to acquire, transform, and analyze data.

• Contribute to data governance efforts including data quality, metadata management, and documentation.

• Identify opportunities to reduce manual processes through automation and improved data architecture.

• Communicate findings, recommendations, and technical concepts effectively to both technical and non-technical audiences.

• Contribute to agile product teams focused on delivering incremental business value.

Required Qualifications
•    Bachelor's degree or equivalent combination of training and experience.
•    Experience using SQL to query, analyze, and transform data.
•    Experience developing analytical solutions using Python.
•    Strong analytical and problem-solving capabilities.
•    Experience working with large and complex datasets.
•    Ability to translate business requirements into technical solutions.
•    Strong written and verbal communication skills.
•    Demonstrated curiosity and ability to learn new technologies quickly.
Preferred Qualifications

• Experience working in AWS environments (Athena, S3, Glue, SageMaker, EMR, or similar technologies).

• Experience developing applications using Streamlit or similar frameworks.

• Experience building dashboards using Tableau, Power BI, or comparable visualization tools.

• Familiarity with data modeling, ETL/ELT processes, and modern data architectures.

• Experience using Git or other version-control tools.

• Experience supporting Compliance, Risk, Audit, Legal, or regulatory reporting functions.

• Experience working within agile product teams.

Technical Environment
You may work with technologies including:
•    Python
•    SQL
•    AWS (Athena, S3, Glue, SageMaker)
•    Tableau
•    Streamlit
•    Git
•    Agile delivery practices
What Success Looks Like

• Deliver trusted data products used by Compliance and Risk leaders.

• Improve reporting efficiency through automation.

• Increase data quality, transparency, and governance.

• Enable faster and more informed business decisions through modern analytics solutions.

• Continuously build technical expertise while contributing to a culture of innovation and continuous improvement.

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.