Hiring: Data Engineer, Specialist Company: Vanguard Location: Dallas, TX Job Posted Time: 2026-09-15 10:16:19 Employment Type: Hybrid Target Skills & Keywords : AWS, Accessibility, Azure, Data Pipeline, Data Warehouse, ETL, Hadoop, Kafka, Lambda, Python, Redshift, S3, SQL, Spark About the job Required Skills: •Develop and maintain scalable ETL (Extract, Transform, Load) processes to efficiently extract data from diverse sources, transform it as required and load it into data warehouses or analytical systems. •Design and optimize database architectures and data pipelines to ensure high performance, availability and security while supporting structured and unstructured data. •Integrate data from multiple sources, including APIs, third-party services and on-prem/cloud databases to create unified and consistent datasets for analytics and reporting. •Partner cross-functionally with data scientists, analysts and business stakeholders to understand their data needs, develop data solutions and enable self-service analytics. •Develop automated workflows and data processing scripts using Python, Spark, SQL, or other relevant technologies to streamline data ingestion and transformation. •Optimize data storage and retrieval strategies in cloud-based data warehouses such as AWS Redshift, Google Big Query, or Azure Synapse, ensuring scalability and cost-efficiency. •Maintain and improve data quality by implementing validation frameworks, anomaly detection mechanisms and data cleansing processes. •Thoroughly tests code to ensure accuracy and alignment with its intended purpose. Reviews the final product with end users to confirm clarity and understanding, providing data analysis guidance as needed. Qualifications: •Undergraduate degree or equivalent combination of training and experience. Compensation: •Flexible work environment (work from home / hybrid options) Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!