> Markdown version of [/jobs/ext/3991422-data-engineer-specialist](https://www.wearedevelopers.com/jobs/ext/3991422-data-engineer-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer, Specialist

- **Company:** Vanguard
- **Location:** Malvern, PA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Data Analysis, Big Data, Cloud Database, Code Reuse, Computer Programming, Information Engineering, Extract Transform Load (ETL), Data Security, Data Systems, Data Visualization, Database Development, Database Queries, Programming Tools, Identity and Access Management, Python (Programming Language), Power BI, Software Engineering, SQL Databases, Data Processing, Cloud Platform System, Apache Spark, Cloudformation, Data Management, Functional Programming, Cloudwatch, Data Pipelines, Programming Languages
- **Published:** October 28, 2026
- **Apply:** http://www.vanguardjobs.com/job/24076257/data-engineer-specialist-malvern-pa/?utm_medium=%22mcloud%2Djobads%22&utm_campaign=Technology&utm_content=Data%20Engineer%2C%20Specialist&utm_term=183417

## About the Role

* 8+ years of experience in data engineering, programming, database development or administration, data management, or related data-focused disciplines.
 * Undergraduate degree or an equivalent combination of education, training, and relevant experience.
 * Experience developing and optimizing ETL processes, data pipelines, and solutions that integrate data from multiple sources.
 * Experience using SQL for data querying, transformation, troubleshooting, and data-quality analysis.
 * Experience using Python or other programming languages to develop data solutions and automate workflows.
 * Experience developing reports, dashboards, or data visualizations using Power BI or similar platforms.
 * Experience translating business requirements into technical solutions and communicating with technical and non-technical stakeholders.
 * Experience with cloud-based data platforms or large-scale data-processing environments, preferred.
 * Experience supporting Financial Crimes, SEC regulatory reporting, regulatory compliance, or financial services data, preferred., * Supports data and reporting capabilities associated with Financial Crimes and regulatory compliance.

## Description

Provides expert-level data engineering solutions that process, integrate, store, and deliver data supporting Financial Crimes, SEC regulatory compliance, reporting, and analytics. Builds scalable and secure data pipelines while improving data quality, availability, and reporting automation. Partners with business, compliance, analytics, and technology teams to translate complex requirements into reliable data and analytics solutions and actionable insights., * Designs, develops, and optimizes ETL processes, data pipelines, database solutions, and cloud-based data infrastructure to support scalable, reliable data processing and analytical needs.

 * Integrates large and complex datasets from multiple sources and troubleshoots data and software issues to maintain data consistency, quality, availability, and integrity.
 * Translates business and regulatory requirements into technical designs and develops maintainable, reusable code, queries, and data solutions.
 * Expert building AWS cloud supporting services and technologies (Eg: Glue, Redshift, Step Functions, Amazon Q Foundational Services like IAM, Cloud Watch, Cloud formation, Lambda, Secrets Manager, Sagemaker).
 * Expert in building Spark data processing applications.
 * Builds and automates dashboards, reports, and data visualizations using Power BI or similar platforms to make data and insights accessible to business partners.
 * Automates recurring data analysis and reporting workflows using Python, SQL, and other programming tools to improve efficiency, reliability, and reduce manual effort.
 * Partners with business, compliance, analytics, and technology teams to understand data needs, develop solutions, and communicate technical considerations.
 * Collaborates with leadership and business partners to translate data and analytical findings into clear insights for technical and non-technical audiences.
 * Assesses data quality, tests solutions for their intended purpose, and supports implementation into production using established engineering and release practices.
 * Serves as a subject matter expert across data engineering and analytics, mentoring less-experienced data professionals and contributing to engineering standards and reusable practices.
 * Participates in special projects and performs other duties as assigned.