Data Engineer - Information Technology Jobs Near Me
Senior Data Engineer AWS / Snowflake Modernization
Location: Remote United States
Employment Type: W-2, 6-Month Contract-to-Hire
Work Authorization: U.S. Citizens and Green Card Holders Only, per end client requirements
***No C2C, subcontractors, or third-party candidates****
Capstone IT is seeking a Senior Data Engineer to support a Fortune 500 company’s enterprise data modernization initiatives. This role will focus on migrating legacy Informatica and Teradata data pipelines to cloud-based solutions using AWS, Snowflake, and Python.
The ideal candidate has a strong background in data engineering, ETL/ELT development, data warehousing, and cloud technologies. This individual will design and implement scalable data solutions, optimize data pipelines, and collaborate with cross-functional teams to support enterprise analytics and business operations.
Top 4 Technical Skills
- AWS Data Engineering: AWS Glue, AWS CDK, and cloud pipeline development.
- Snowflake: Data warehousing, data modeling, and SQL.
- Python: Data processing, transformation, and automation.
- ETL/ELT Modernization: Enterprise data pipeline development and cloud migration.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines for ingestion, transformation, integration, and reporting.
- Lead the migration of legacy Informatica and Teradata pipelines to AWS and Snowflake.
- Build and optimize ETL/ELT workflows using AWS Glue, Python, and SQL.
- Develop Snowflake data warehouses, dimensional data models, and aggregated data products.
- Implement data orchestration, cleansing, validation, and quality control processes.
- Integrate relational and document databases, including MongoDB, as needed.
- Utilize AWS CDK, Git, and automated testing practices to support reliable deployments.
- Monitor and optimize pipeline performance, scalability, reliability, and cloud costs.
- Ensure compliance with enterprise data governance, security, and architecture standards.
- Collaborate with engineers, architects, product owners, and business stakeholders to deliver data solutions aligned with business requirements.
- Participate in Agile ceremonies, code reviews, technical documentation, and mentoring activities.
Technical Qualifications
- Strong hands-on experience with AWS, Snowflake, Python, and SQL.
- Experience with AWS Glue and AWS Cloud Development Kit (CDK).
- Experience designing, developing, and migrating enterprise data pipelines.
- Strong knowledge of data modeling, dimensional modeling, star schemas, and data warehouse architecture.
- Experience with relational databases such as Oracle, SQL Server, Teradata, or Amazon RDS.
- Experience migrating legacy Informatica and Teradata pipelines to cloud-based data platforms is highly desirable.
- Experience with MongoDB or other document databases is a plus.
- Knowledge of enterprise data mesh architectures and reusable data products.
- Proficiency with Git-based version control, automated testing, and CI/CD practices.
- Understanding of data governance, security, data quality, and performance optimization.
Education and Experience
- 10+ years of professional experience in data engineering, ETL/ELT development, enterprise data warehousing, and cloud-based data solutions.
- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a closely related technical field from an accredited institution.
- Experience supporting enterprise-scale data modernization and cloud migration initiatives.
Additional Information
This position is fully remote within the United States and requires collaboration with distributed onshore and offshore teams during overlapping business hours.
Upon conversion to permanent employment, participation in an off-hours on-call rotation will be required.
Capstone Consulting is an EEO employer.
Capstone website:
Like us on Facebook:
Follow us on Twitter:
Connect with us on LinkedIn:
Required Skills
Required Languages
🇬🇧 English