Data Engineer, Specialist

Vanguard
Dallas, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Dallas, United States of America

Tech stack

Artificial Intelligence
Amazon Web Services (AWS)
Amazon Web Services (AWS)
JIRA
Cloud Database
Code Review
Continuous Integration
Data Validation
Information Engineering
Data Infrastructure
ETL
Data Visualization
Github
Python
Machine Learning
Power BI
Cloud Services
SQL Databases
Tableau
Parquet
Large Language Models
GIT
PySpark
Data Lineage
Streamlit Framework
Software Version Control
Data Pipelines
ServiceNow

Job description

  • Design, build, and maintain scalable ETL/ELT pipelines for critical IT data sources

  • Develop curated, high-quality datasets to support reporting, dashboards, and analytics products

  • Write, optimize, and maintain SQL and Python code for transformation, automation, and performance

  • Deliver cloud-based data solutions using AWS services such as Glue, S3, and Athena

  • Partner with analysts, product managers, and stakeholders to translate data needs into practical solutions

  • Implement data quality checks, validation rules, monitoring, and documentation to ensure trusted data

  • Troubleshoot pipeline issues, investigate anomalies, and resolve data defects end-to-end

  • Apply engineering best practices including version control (Git), code reviews, testing, and CI/CD deployment

  • Contribute to standards for data lineage, governance, documentation, and production support

Requirements

  • Bachelor's degree or equivalent combination of education and relevant experience

  • 3-5+ years of experience in data engineering, analytics engineering, or data platform development

  • Strong proficiency in SQL and Python for data transformation and automation

  • Hands-on experience building and supporting ETL/ELT pipelines

  • Experience with AWS or similar cloud data platforms

  • Solid understanding of data modeling, curated datasets, and BI/reporting use cases

  • Demonstrated problem-solving skills and commitment to data quality and reliability

  • Ability to communicate effectively with both technical and non-technical stakeholders

  • Experience working in collaborative, agile team environments

Preferred:

  • Experience with AWS Glue, PySpark, Athena, Dremio, Parquet

  • Exposure to BI and visualization tools such as Tableau, Power BI, or Streamlit

  • Familiarity with Jira, GitHub, ServiceNow, or technology operations data

  • Interest in building reusable data products and enabling self-service analytics

  • Exposure to AI/ML concepts, LLMs, or agent-based tools to enhance data engineering workflows and automation

About the company

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, one of the world's leading investment management companies, serves individual investors, institutions, employer-sponsored retirement plans, and financial professionals. We have a diverse and talented crew with a culture that promotes teamwork, along with an unwavering focus on serving our clients' best interests. This website uses "cookies" to distinguish you from other users. A cookie is a small file of letters and numbers placed on your computer or device. This helps us to provide you with a good experience when you browse our website and also allows us to improve our site and services. The cookies are stored locally on your computer or mobile device. To accept cookies you can continue browsing as normal. Or you can go to ourPrivacy Policy (https://www.vanguardjobs.com/site-privacy-policy/) to read more information and learn how to change your preferences. Read More

Apply for this position