AWS Data Engineer

Interon IT Solutions; Malvern (Chester County); Hybrid; USD 34,000 - 55,000; Full time

Benefits offered by this job

Hybrid work model

Job summary

Interon IT Solutions is seeking an experienced AWS Data Engineer to design, build, and support scalable data solutions for real-time and offline analytics. You will work with ETL development, Spark/PySpark, SQL, and Tableau to deliver reliable analytics products.

The role requires strong hands-on skills with AWS services (S3, Glue, Redshift, Lambda, IAM) and CI/CD with GitHub. Hybrid work model in Malvern, PA with three days onsite and ongoing collaboration with cross-functional teams.

Qualifications

• Experience designing and building ETL pipelines for real-time and batch data.
• Strong Python and PySpark development experience.
• Expertise in SQL and data modeling for analytics.
• Hands-on with AWS cloud data services (S3, Redshift, Glue, Lambda).
• Experience with Tableau reporting and data visualization.

Responsibilities

• Design, develop, and maintain ETL processes for real-time and batch data processing.
• Build and support data pipelines and analytics tools.
• Integrate data from multiple sources to support business reporting.
• Troubleshoot data quality issues and ensure data integrity and performance.
• Translate business requirements into technical designs, reports, and data solutions.

Skills

ETL design

Python

PySpark

SQL

AWS services

Tableau

Data quality

CI/CD

Documentation

Communication

Education

Bachelor's degree in Computer Science or related field

Tools

Tableau

GitHub

AWS (S3, Redshift, Glue)

Spark/PySpark tooling

Job description

Hiring AWS Data Engineer W2 position
Location: Malvern,PA Hybrid 3 days onsite
Pay :.5-40/hr on W2
Must have 7+ yrs of experience
Any visa is fine except H1b
W2 position only no C2C

Job Description

We are seeking an experienced Data Engineer to design, build, and support scalable data solutions for real-time and offline analytics. The ideal candidate will have strong hands‑on experience with ETL development, AWS cloud data services, Spark/PySpark, SQL, and reporting tools.

This role involves working closely with business and technical teams to understand data needs, integrate data from multiple sources, troubleshoot data quality issues, and deliver reliable analytics solutions.

Key Responsibilities

• Design, develop, and maintain ETL processes for real‑time and batch data processing.
• Build and support database systems, data pipelines, and analytics tools.
• Integrate data from multiple sources to support business reporting and decision‑making.
• Troubleshoot data issues related to consistency, quality, integrity, and performance.
• Translate business requirements into technical design, code, reports, and data solutions.
• Develop Spark‑based data processing applications using Python and PySpark.
• Write complex SQL queries, ad hoc reports, and reusable data scripts.
• Build and maintain reporting solutions using Tableau.
• Work with AWS cloud services such as ECS, Glue, S3, Glue Crawler, Redshift, Step Functions, IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, and SageMaker.
• Participate in all phases of the SDLC, including design, development, testing, deployment, and support.
• Follow test automation and test‑driven development practices.
• Use CI/CD tools such as GitHub for version control and deployment support.
• Document code, data flows, process designs, and technical solutions clearly.
• Review deliverables with business users to ensure accuracy and usability.
• Provide data analysis support and technical guidance to business users and team members.

Required Skills

• Strong experience as a Data Engineer.
• Hands‑on experience with ETL design and development.
• Strong experience with Python and PySpark.
• Expertise in Spark data processing applications.
• Strong SQL development experience.
• Experience with AWS cloud data services, including S3, Glue, Redshift, Lambda, IAM, CloudWatch, CloudFormation, Step Functions, Secrets Manager, and related services.
• Experience with Tableau reporting.
• Good understanding of data quality, data integrity, and data troubleshooting.
• Experience with CI/CD tools such as GitHub.
• Experience with test automation or test‑driven development.
• Strong documentation and communication skills.

Preferred Skills

• Experience with SageMaker or cloud‑based analytics platforms.
• Experience working with large‑scale enterprise data environments.
• Experience supporting both real‑time and batch analytics solutions.
• Ability to explain technical concepts clearly to business stakeholders.

Preferred Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
• Experience working in Agile development environments.
• Ability to work independently and collaborate with cross‑functional teams.