Data Engineer, Senior Specialist

Segwae; Charlotte (NC); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Vanguard is seeking a Data Engineer, Senior Specialist to design, develop, and optimize data pipelines and architectures for scalable data processing. You will build ETL workflows, integrate diverse data sources, and design optimized schemas for analytical workloads, while guiding and reviewing code within the data engineering team.

The role is hybrid and based in Charlotte, NC, requiring strong SQL and big data framework experience alongside cloud services on AWS, Azure, or GCP.

Qualifications

• 8+ years of experience in data analytics, programming, DB admin, or data management.
• Undergraduate degree required; graduate degree preferred.
• Strong SQL proficiency with relational databases.
• Hands-on experience with big data frameworks such as Spark, Hadoop, or Databricks.
• Proficiency in Python, Scala, or Java.
• Experience with cloud data services on AWS, Azure, or GCP.
• Data modeling experience required.
• No visa sponsorship available.

Responsibilities

• Design, develop, and optimize data pipelines and architectures for scalable processing.
• Build and manage ETL workflows and data integration across sources.
• Provide technical guidance and code reviews to the data engineering team.
• Collaborate with data scientists and analytics teams to enable insights.

Skills

8+ years experience

SQL proficiency

Big data frameworks

Python/Scala/Java

Cloud data services

Data modeling

Education

Bachelor's degree

Master's degree preferred

Tools

PostgreSQL

MySQL

Oracle

SQL Server

Apache Spark

Hadoop

Databricks

Job description

Vanguard is a globally recognised investment management company on a mission to work for the long-term financial wellbeing of its clients. They're hiring a Data Engineer, Senior Specialist to design, develop, and optimise data pipelines and architectures for scalable, efficient data processing. You'll build and manage ETL workflows, integrate diverse data sources, design optimised schemas for analytical workloads, leverage orchestration tools like Airflow or Prefect, and provide technical guidance and code reviews to the broader data engineering team. This is a hybrid role based in Charlotte, NC.

• Minimum 8 years of experience in data analytics, programming, database administration, or data management.
• Undergraduate degree required, graduate degree preferred.
• Strong SQL proficiency and experience with relational databases (PostgreSQL, MySQL, Oracle, SQL Server).
• Hands‑on experience with big data frameworks (Apache Spark, Hadoop, or Databricks).
• Strong Python, Scala, or Java programming skills.
• Experience with cloud data services on AWS, Azure, or GCP (Glue, Redshift, BigQuery, Snowflake).
• Data modeling experience required.
• No visa sponsorship available.