Application Data Engineer - I at Vanguard

Malvern, Pennsylvania, United States

Vanguard Logo
Not SpecifiedCompensation
Junior (1 to 2 years)Experience Level
Full TimeJob Type
NoVisa
Financial ServicesIndustries

Requirements

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

Responsibilities

  • Writes ETL (Extract / Transform / Load) processes, designs database systems, and develops tools for real-time and offline analytic processing
  • Troubleshoots software and processes for data consistency and integrity
  • Integrates data from a variety of sources for business partners to generate insight and make decisions
  • Translates business specifications into design specifications and code
  • Responsible for writing programs, ad hoc queries, and reports
  • Ensures that all code is well structured, includes sufficient documentation, and is easy to maintain and reuse
  • Partners with internal clients to gain a basic understanding of business functions and informational needs
  • Gains working knowledge in tools, technologies, and applications/databases in specific business areas and company-wide systems
  • Participates in all phases of solution development
  • Explains technical considerations at related meetings, including those with business clients
  • Tests code thoroughly for accuracy of intended purpose
  • Reviews end product with the client to ensure adequate understanding
  • Provides data analysis guidance as required
  • Provides tool and data support to business users and fellow team members
  • Tests and implements new software releases through regression testing
  • Identifies issues and engages with vendors to resolve and elevate software into production
  • Participates in special projects and performs other duties as assigned

Skills

ETL
SQL
database design
data integration
analytic processing
programming
ad hoc queries
regression testing

Vanguard

Client-owned investment management firm offering low-cost funds

About Vanguard

Vanguard provides financial services with a focus on investment management. The company offers a variety of products, including mutual funds, exchange-traded funds (ETFs), individual retirement accounts (IRAs), and 401k rollovers, aimed at individual investors, financial advisors, and institutions. Vanguard's unique ownership structure means it is owned by its funds, which are in turn owned by the clients, allowing it to prioritize the needs of its investors over external shareholders. This model enables Vanguard to offer low-cost investment options, as it primarily earns revenue through management fees that are generally lower than industry standards. Additionally, Vanguard provides personalized investment advisory services, charging fees based on the assets managed. The company's goal is to help clients grow their wealth and achieve their financial objectives through effective investment strategies, while maintaining a competitive performance track record.

Kline Township, PennsylvaniaHeadquarters
1975Year Founded
SECONDARYCompany Stage
Fintech, Financial ServicesIndustries
10,001+Employees

Benefits

Best-in-class medical, dental & vision coverage
Onsite health clinic & fitness center
Health Smart Rewards program
Vanguard Retirement Savings Plan
Education Benefits
PTO
Family Planning Benefist
Parental leave
Personal development opportunities
Volunteer Time Off

Risks

Competition from AI-driven platforms like Writer challenges Vanguard's traditional advisory services.
Vanguard's stake in Steelcase exposes it to the volatile furniture market.
New active bond ETFs may struggle in a low-yield environment with increasing competition.

Differentiation

Vanguard is client-owned, aligning its interests with investors, unlike traditional firms.
The firm offers low-cost investment products, making it attractive to cost-conscious investors.
Vanguard's ownership structure allows it to focus on long-term investor value.

Upsides

Vanguard's new active bond ETFs offer diversified, low-cost fixed income options.
The acquisition of Steelcase shares diversifies Vanguard's portfolio into the furniture industry.
Launching the International Dividend Growth Fund appeals to investors seeking sustainable dividend growth.

Land your dream remote job 3x faster with AI