Logo of Huzzle

Find 51,000+ jobs, internships & events from 6,000+ top companies on Huzzle using AI

Data Engineer

image

Vanguard

2mo ago

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Charlotte
  • Quick Apply

AI generated summary

  • You need 8+ years in data analytics, programming, or database management, plus an undergrad degree or equivalent experience; a graduate degree is preferred.
  • You will design and implement ETL processes, ensure data integrity, collaborate with teams, lead projects, mentor juniors, and test software solutions for effective data analytics.

Requirements

  • Minimum of 8+ years data analytics, programming, database administration, or data management experience.
  • Undergraduate degree or equivalent combination of training and experience. Graduate degree preferred.

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 complex and large scale 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 complex 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 an expert understanding of business functions and informational needs. Works closely with other technical and data analytics experts across the business to implement data solutions.
  • Leads all phases of solution development. Explains technical considerations at related meetings, including those with internal clients and less experienced team members.
  • Assesses data quality and tests code thoroughly for accuracy of intended purpose. Provides data analysis guidance and serves as a technical consultant for the client.
  • Educates and develops junior data engineers on the team while applying quality control to their work. Develops data engineering standards and contributes expertise to other data expert teams across Vanguard.
  • Tests and implements new software releases through regression testing. Identifies issues and engages with vendors to resolve and elevate software into production.

FAQs

What key technologies and skills are required for this position?

The key technologies and skills include Python and SQL for data processing and analysis, Redshift and Spark for data warehousing and big data processing, AWS Cloud Services for scalable and secure data solutions, and data modeling to design and optimize data structures.

What are the responsibilities of a Data Engineer at Vanguard?

Responsibilities include writing ETL processes, troubleshooting software for data consistency, integrating large-scale data, translating business specifications into design specifications, leading solution development phases, assessing data quality, educating junior data engineers, and testing new software releases.

What is the minimum experience required for this position?

A minimum of 8+ years of experience in data analytics, programming, database administration, or data management is required.

Is a specific educational background required for the Data Engineer role?

An undergraduate degree or equivalent combination of training and experience is required, with a graduate degree preferred.

Is Vanguard offering visa sponsorship for this position?

No, Vanguard is not offering visa sponsorship for this position.

How does Vanguard approach diversity, equity, and inclusion?

Vanguard is committed to creating an inclusive, equitable, and diverse work environment, recognizing that diversity is essential to deliver on the company's mission.

What is Vanguard's working model?

Vanguard has implemented a hybrid working model designed to capture the benefits of enhanced flexibility while enabling in-person learning, collaboration, and connection.

Will there be opportunities for professional development within this role?

Yes, there are opportunities for professional development, including educating and developing junior data engineers on the team and fostering a collaborative environment.

What coding practices are expected from Data Engineers?

Data Engineers are expected to ensure that all code is well-structured, documented, easy to maintain, and reusable.

What types of data integration will the Data Engineer be responsible for?

The Data Engineer will integrate complex and large-scale data from various sources to support business insights and decision-making.

Finance
Industry
10,001+
Employees
1975
Founded Year

Mission & Purpose

We are a community of 50 million who think—and feel—differently about investing. Together, we’re changing the way the world invests. Since our founding in 1975, helping investors achieve their goals has been our main reason for existence. At Vanguard, we’re built differently. Vanguard is investor-owned, meaning the fund shareholders own the funds, which in turn own Vanguard. When you’re surrounded by people who care about the same things, things tend to fall into place. With no other parties to answer to and therefore no conflicting loyalties, we make every decision—including keeping investing costs as low as possible—with your needs in mind. Because of our unique structure, your goals align with our goals. Whether you’re investing for your first house, college for your kids, or a comfortable retirement, you can be confident we’re on your side. That’s the value of ownership!