The business and/or technical problem the job is looking to solve is to acquire and compile structured and unstructured data, perform analyses of historical data to surface trends and insights, and translate analytic insights into tangible, actionable solutions for business partners to implement. The role also aims to mentor junior analysts and foster a culture of continuous learning.
Requirements
- SQL
- Python
- Tableau
- Data Modeling
- Ability to analyze large and complex data sets through robust SQL skills.
- Experience with large data warehouses and a strong understanding of data modeling principals.
- Ability to cleanse data and create automated scripts using Python
Responsibilities
- Acquire and compile structured and unstructured data, verifying its quality, accuracy, and reasonableness.
- Perform analyses of historical data to surface trends and insights using advanced analytical methods.
- Validate analytical techniques employed by other analysts.
- Prepare and deliver visualizations and internal presentations that translate analytic insights into tangible, actionable solutions for business partners to implement.
- Develop, own, and manage recurring analytic or reporting processes.
- Bring structure to business requests, translate requirements into an analytical project approach, and lead projects through completion.
- Ability to analyze large and complex data sets through robust SQL skills.
Other
- Engage with internal partners to understand business strategy, questions, and goals.
- Interacting with stakeholders to understand strategy, questions and goals.
- Proactively identify opportunities within the business to contribute to its growth and success.
- Mentor and coach junior analysts to elevate technical and storytelling capabilities.
- Vanguard is not offering visa sponsorship for this position.
