Data Engineer – ETL, Snowflake & Spark (Onsite NYC)

Ampcus Inc; New York (NY); On-site; USD 80,000 - 110,000; Full time

Job summary

Ampcus Inc. in New York is seeking an Intermediate Data Engineer to design and manage scalable ETL pipelines for analytics. The role involves working with AWS services and optimizing data processes within a centralized data lake and Snowflake environment. Candidates should have strong experience with data lakes, ETL pipelines, and proficiency in PySpark and Apache Spark. This position will require onsite work in Manhattan West, NY.

Qualifications

• Strong experience with data lake architectures and large-scale data processing.
• Hands-on experience with AWS services for data management.
• Proven expertise in building ETL pipelines for analytics.

Responsibilities

• Design, develop, and maintain robust ETL pipelines.
• Automate data processing and analytical workflows.
• Implement orchestration of data pipelines using Control‑M and Apache Airflow.
• Develop data transformation logic using PySpark and Spark.

Skills

Data lake architectures

AWS services (S3, EC2, EMR, Glue)

ETL pipelines

Snowflake

Control-M and Apache Airflow

PySpark

Apache Spark using Java

Data modeling and performance tuning

Job description

Ampcus Inc. in New York is seeking an Intermediate Data Engineer to design and manage scalable ETL pipelines for analytics. The role involves working with AWS services and optimizing data processes within a centralized data lake and Snowflake environment. Candidates should have strong experience with data lakes, ETL pipelines, and proficiency in PySpark and Apache Spark. This position will require onsite work in Manhattan West, NY.