Role: Data analyst Location: Malvern PA 19355 Hybrid 3 days a week in Malvern, PA Duration: 6 months About the Role: (SQL, excel, ETL, SAP Business Object Web Intelligence) <ul> <li>They are implementing a new system (Adacom). During the initial mapping of data fields that are required, they found a bunch of missing data and clean up that is needed</li> <li>anyone who has anti money laundering systems or data experience would be a big benefit (but not required)</li> <li>Looking for resources who have experience doing data quality work, more support for data mapping</li> <li>Looking for previous banking experience (must have)</li> <li>Ability to work independently</li> <li>Strong SQL experience</li> <li>Ability to create formulas in excel</li> <li>Querying experience - (specifically in SAP Business Object Web Intelligence would be beneficial)</li> <li>Data Analysis skills</li> <li>Someone who can take business terms and connect them to the technical data (where is that located in their systems/databases)</li> <li>Understand lineage </li> <li>Root Cause Analysis - trace data issue back to source. Both mapping and data quality</li> <li>Need the ability to read a snowflake view with transformations and joins - not building view but understanding it.</li> <li>Understand ETL</li> </ul>

Vanguard's Self-Directed (SD) Client Strategy and Brokerage and Investment Analytics team is growing! We have an opening for an experienced data analyst to support Client Strategy and Product initiatives. This analyst will partner closely with the business to uncover insights and will help to shape the strategy to improve the same. The analyst will be responsible for a range of analytic tasks including ownership of KPI reporting all the way through advanced analyses (drivers analyses, development of data driven strategies to influence business strategies, etc.)The ideal candidate has:A deep understanding of or interest to learn about the Self-Directed businessAbility to take large disparate data and synthesize actionable insights for leadership consumptionStrong technical skill set (SQL, python preferred)Experience with PI enterprise DataDesire & ability to collaborate closely with our business partners to consult & gather requirementsExperience in building resilient reporting products (e.g. dashboards)Experience applying advanced analytical techniques in a workplace setting (e.g. predictive modeling)Knowledge of analytic roadmap development in partnership with business stakeholdersCore ResponsibilitiesEngages with internal partners to understand business strategy, questions and goals. Brings structure to business requests, translates requirements into an analytical project approach, and leads complex projects through completion. Delegates tasks and provides tactical and strategic guidance to peers. Serves as the analytics expert on cross-functional teams for large strategic initiatives.Acquires and compiles structured and unstructured data and verifies its quality, accuracy and reasonableness.Performs analyses of historical data to surface trends and insights using advanced analytical methods. Validates analytical techniques employed by other analysts.Prepares and delivers expert level visualizations and internal presentations that translate analytic insights into tangible, actionable solutions for business partners to implement.Develops, owns and manages recurring analytic or reporting processes.Actively develops the analytics community at Vanguard by mentoring, coaching and connecting others with resources and training. Participates and presents during scheduled analytics seminars.Participates in special projects and performs other duties as assigned.QualificationsMinimum of five years related work experience.Undergraduate degree or equivalent combination of training and experience. Graduate degree preferred.Special FactorsSponsorshipVanguard is not offering visa sponsorship for this position.About VanguardAt Vanguard, we don't just have a missionwe'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.Our commitment to diversity, equity, and inclusionVanguards commitment to diversity, equity, and inclusion (DEI) is central to our ability to deliver on our mission. We aspire to create a work environment that is inclusive, equitable, and diverseone that enables our employees, whom we call crew, to thrive and bring their best selves to work every day on behalf of our clients.Cultivating DEI lifts our entire organization, and everyone shares accountability for our progressfrom our senior leaders who lay the foundation and set the example for inclusive behaviors to crew who are growing in their personal DEI learning experiences.Together, were on a mission. We are fueled by the value of diverse voices and connected through friendships and a culture of carefor our clients, our communities, and each other.Vanguards DEI journey has no finish line. Our commitment is enduring, and we remain focused on the path ahead. To learn more about Vanguard goals and progress toward DEI, download our Diversity, Equity, and Inclusion Report (https://corporate.vanguard.com/content/corporatesite/us/en/corp/who-we-are/we-care-about/diversity-equity-inclusion.html) .How We WorkVanguard 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.

The Internal Audit & SOX (IAS) department has an exciting opportunity for a Senior Audit Data Analyst on the Global Investment & Finance Audit Services Team (GIFAS). Within the organization, IAS is seen as a critical line of defense for the organization. In this role you'll be acting as a subject matter expert and liaison between your GIFAS team members and a central team in IAS comprised of solutions developers and data engineers. With these teams you will collaboratively identify, prioritize, design, build and deliver highly effective analytic results and insights for audit engagements across our Finance division. You'll also work collaboratively with IAS audit leaders to identify and prioritize opportunities for data analysis or continuous assurance. Then you'll liaise amongst the IAS teams to design, build and deliver analytic routines that support the assurance objectives with increased efficiency, coverage, and insights. We look for individuals who can think critically and conceptually, have excellent project management, relationship management, influence, communication, judgement, and decision-making skills. In addition to the qualifications listed below, the ideal candidate has: Knowledge and proficiency with the following tools & technologies: Tableau, PowerBI, Python, SQL, AWS, RPA (UiPath), Database Platforms (Oracle, SQL Server) Strong understanding of data analytics techniques and their application across business processes Ability to communicate effectively with both non-technical auditors and technical developers / engineers Planning and organizational skills with ability to successfully execute and deliver concurrent priorities Ability to handle ambiguity and achieve success in a fast-paced, complex work environment Strong working knowledge of audit, risk, and controls with a relevant certification is a plus but not required (CISA, CIA, CPA) Responsibilities: Collaborate with audit / SOX teams and manage the identification, organization, and prioritization of data analytics ideas to deploy data analytics resources most effectively and efficiently Partner with audit / SOX teams in effectively building data analytics, visualized reporting, and automation utilities across all phases of the audit / SOX lifecycle (annual planning, risk assessments, individual engagements, continuous monitoring, etc.) Periodically engage with business area key stakeholders to share work completed and value delivered Identify opportunities and provide analytic design specifications to the IAS central team for the development of more complex and repeatable analytics Consult, educate and empower audit / SOX team members to identify analytic opportunities and utilize analytic tools and techniques Support departmental data analytics transformation workstreams and initiatives Participate in special projects and perform other duties as assigned Qualifications: Minimum of five years related work experience. Undergraduate degree or equivalent combination of training and experience (e.g., MIS, Information Technology, Data Sciences, Data / Business Analytics, Finance, Business Administration) Special Factors: Vanguard is not offering visa sponsorship for this position. This position is hybrid and would require you to be local to our Chesterbrook, PA office. You should be aware this will designate you as a Fund Access Person and carries with it certain responsibilities and restrictions. For more information see the following article. In Finance we are committed to providing you a supportive and inclusive environment, one where all crew feel a sense of belonging and diverse voices make a positive impact globally. Learn more about #FINclusion and how you can join us in raising the bar on excellence. Why join Finance? Are you interested in purposeful work, exposure, and growth? A career in Finance enables you to gain a vast portfolio of unique, valuable experiences, networks, and critical business knowledge. Learn more by visiting the Finance About Us and Why work in Finance pages and make Finance your career destination. To support your career journey, leverage the Finance Grow Your Career (GYC) site - a robust resource to promote and empower crew development. The Explore page helps to provide valuable insights into the sub-divisions by showcasing what we do, who we are and the career opportunities that exist. To get started reference the sub-divisional 1-pager, Career Opportunities documents and crew testimonials to learn more! Click here to learn more about Internal Audit (IA)Vanguard's Internal Audit & SOX (IAS) department has an exciting opportunity for a Senior Audit Data Analyst on the Global Investment & Finance Audit Services Team (GIFAS). Within the organization, IAS is seen as a critical line of defense for the organization. In this role you'll be acting as a subject matter expert and liaison between your GIFAS team members and a central team in IAS comprised of solutions developers and data engineers. With these teams you will collaboratively identify, prioritize, design, build and deliver highly effective analytic results and insights for audit engagements across our Finance division. You'll also work collaboratively with IAS audit leaders to identify and prioritize opportunities for data analysis or continuous assurance. Then you'll liaise amongst the IAS teams to design, build and deliver analytic routines that support the assurance objectives with increased efficiency, coverage, and insights.We look for individuals who can think critically and conceptually, have excellent project management, relationship management, influence, communication, judgement, and decision-making skills.Responsibilities :* Collaborate with audit / SOX teams and manage the identification, organization, and prioritization of data analytics ideas to deploy data analytics resources most effectively and efficiently* Partner with audit / SOX teams in effectively building data analytics, visualized reporting, and automation utilities across all phases of the audit / SOX lifecycle (annual planning, risk assessments, individual engagements, continuous monitoring, etc.)* Periodically engage with business area key stakeholders to share work completed and value delivered* Identify opportunities and provide analytic design specifications to the IAS central team for the development of more complex and repeatable analytics* Consult, educate and empower audit / SOX team members to identify analytic opportunities and utilize analytic tools and techniques* Support departmental data analytics transformation workstreams and initiatives* Participate in special projects and perform other duties as assignedQualificaitons:* Minimum of 5 years related business or technical experience preferred* Undergraduate degree in a related field or the equivalent combination of training and experience (e.g., MIS, Information Technology, Data Sciences, Data / Business Analytics, Finance, Business Administration)* Knowledge and proficiency with the following tools & technologies: Tableau, PowerBI, Python, SQL, AWS, RPA (UiPath), Database Platforms (Oracle, SQL Server)* Strong understanding of data analytics techniques and their application across business processes* Ability to communicate effectively with both non-technical auditors and technical developers / engineers* Planning and organizational skills with ability to successfully execute and deliver concurrent priorities* Ability to handle ambiguity and achieve success in a fast-paced, complex work environment* Strong working knowledge of audit, risk, and controls with a relevant certification is a plus but not required (CISA, CIA, CPA)Special Factors:Vanguard is not offering visa sponsorship for this position.This position is hybrid and would require you to be local to our Chesterbrook, PA office.Special FactorsSponsorshipVanguard is not offering visa sponsorship for this position.About VanguardAt 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.Our commitment to diversity, equity, and inclusionVanguard's commitment to diversity, equity, and inclusion (DEI) is central to our ability to deliver on our mission. We aspire to create a work environment that is inclusive, equitable, and diverse-one that enables our employees, whom we call crew, to thrive and bring their best selves to work every day on behalf of our clients.Cultivating DEI lifts our entire organization, and everyone shares accountability for our progress-from our senior leaders who lay the foundation and set the example for inclusive behaviors to crew who are growing in their personal DEI learning experiences.Together, we're on a mission. We are fueled by the value of diverse voices and connected through friendships and a culture of care-for our clients, our communities, and each other.Vanguard's DEI journey has no finish line. Our commitment is enduring, and we remain focused on the path ahead. To learn more about Vanguard goals and progress toward DEI, download our Diversity, Equity, and Inclusion Report.How We WorkVanguard 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.

Data Analyst Jobs in Malvern, PA

Data Analyst
December 5, 2024

Data Analyst Specialist
December 5, 2024

Senior Audit Data Analyst
December 4, 2024

Quick filters

Top companies

Data Analyst Jobs in Malvern, PA

Data AnalystDecember 5, 2024

Data Analyst SpecialistDecember 5, 2024

Senior Audit Data AnalystDecember 4, 2024

Quick filters

Top companies

Data Analyst
December 5, 2024

Data Analyst Specialist
December 5, 2024

Senior Audit Data Analyst
December 4, 2024