Vanguard Logo

Vanguard

Data Engineer, Specialist

Posted 4 Days Ago
In-Office
Malvern, PA
Senior level
In-Office
Malvern, PA
Senior level
The Data Engineer, Senior Specialist designs and optimizes data pipelines, ensuring efficient data processing and integration of diverse sources to support business intelligence needs.
The summary above was generated by AI

Role Summary

The Data Engineer, Senior Specialist is responsible for designing, developing and optimizing data pipelines and architectures to support scalable and efficient data processing. This role involves working with complex datasets, integrating multiple data sources and ensuring high data quality and reliability.

Responsibilites
1. Develop and maintain efficient ETL (Extract, Transform, Load) pipelines that ingest, process and transform large datasets from diverse sources.
2. Build and manage data storage solutions using relational and non-relational databases, ensuring high availability, performance and scalability.
3. Work with APIs, third-party data sources and internal databases to create unified datasets that provide actionable insights for business stakeholders.
4. Partner with business intelligence analysts, data scientists and software engineers to design and implement data-driven solutions that meet business requirements.
5. Design optimized data schemas and structures that support analytical workloads and improve query performance.
6. Leverage orchestration tools like Apache Airflow or Prefect to automate ETL workflows and improve operational efficiency.
7. Provide technical guidance, review code and promote best practices within the data engineering team.
Qualifications and Skills

  • Minimum of eight years data analytics, programming, database administration, or data management experience.
  • Undergraduate degree or equivalent combination of training and experience. Graduate degree preferred.
  • Data modeling experience is required.
  • Proficiency in SQL and database technologies such as PostgreSQL, MySQL, Oracle, or SQL Server.
  • Hands-on experience with big data frameworks like Apache Spark, Hadoop, or Databricks.
  • Strong programming skills in Python, Scala, or Java for data processing and automation.
  • Experience with cloud platforms such as AWS, Azure, or GCP, particularly in data services like AWS Glue, Redshift, Big Query, or Snowflake.

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.

Vanguard Charlotte, North Carolina, USA Office

Two North Falls Plaza, Charlotte, NC, United States, 28217

Similar Jobs

Yesterday
In-Office
Mid level
Mid level
Fintech
The Data Engineer, Specialist designs and maintains scalable data pipelines, builds ETL processes, optimizes data storage, and collaborates with stakeholders to support analytics efforts.
Top Skills: SparkAws RedshiftAzure SynapseData FactoryDataflowGlueGoogle Big QueryHadoopKafkaPythonScalaSQL
2 Days Ago
In-Office
Charlotte, NC, USA
Senior level
Senior level
Fintech
The Data Engineer, Specialist designs and maintains scalable ETL processes, manages databases, collaborates for data delivery, and optimizes data workflows for analytics.
Top Skills: SparkAws RedshiftAzure SynapseGoogle Big QueryHadoopKafkaPythonScalaSQL
20 Days Ago
Hybrid
Mid level
Mid level
Information Technology • Consulting
As a Data Engineer, you will optimize data platforms using Microsoft technologies, support clients in data challenges, and implement data solutions.
Top Skills: AksAzure Cosmos DbAzure Data FactoryAzure SqlDatabricksDelta LakeDockerGitAzureMicrosoft FabricPower BIPysparkPythonSpark SqlSQLSynapse Data Analytics

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account