Ampcus inc

Data Engineer - Intermediate

Ampcus inc$90K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience with data processing and pipeline management.
  • Proven experience in data lake architectures and large-scale data processing environments.
  • Hands-on with AWS services like S3, EC2, EMR, and Glue.
  • Expertise in building ETL pipelines tailored for analytics and reporting.
  • Solid understanding of Snowflake data warehousing, including optimization techniques.
  • Proficient in using Control-M and Apache Airflow for workflow automation.
  • Strong programming skills in PySpark and Apache Spark using Java.

Responsibilities

  • Design and develop scalable ETL pipelines for data ingestion into a centralized data lake.
  • Automate data processing and aggregation workflows to enhance availability and performance.
  • Manage orchestration and scheduling of data pipelines using Control-M and Apache Airflow.
  • Create data transformation logic leveraging PySpark and Apache Spark (Java).
  • Handle large datasets on AWS infrastructure, ensuring data quality and consistency.
  • Optimize existing data pipelines for cost-effectiveness and performance.
  • Collaborate with cross-functional teams to gather data requirements and insights.

Benefits

  • Comprehensive health benefits including medical, dental, and vision.
  • 401(k) retirement plan with company matching contributions.
  • Generous paid time off and holidays.
  • Professional development opportunities including training and certifications.
  • Work in a collaborative environment with a focus on innovation.
Full Job Description
Job Title: Data Engineer - Intermediate
Location: Manhattan West, NY - Onsite


Job Description:

We are seeking a skilled Data Engineer to design, build, and manage scalable ETL pipelines supporting a centralized data lake and Snowflake data warehouse. The role focuses on automating data ingestion, transformation, and aggregation workflows to enable reliable analytics and data-driven decision-making.

Key Responsibilities
  • Design, develop, and maintain robust ETL pipelines for ingesting data into the enterprise data lake and Snowflake environment.
  • Automate data processing, aggregation, and analytical workflows to improve data availability and performance.
  • Implement and manage orchestration and scheduling of data pipelines using Control-M and Apache Airflow.
  • Develop scalable data transformation logic using PySpark and Apache Spark (Java).
  • Work with large, structured and semi-structured datasets on AWS infrastructure.
  • Ensure data quality, integrity, and reliability across data pipelines.
  • Optimize data pipelines for performance, cost, and scalability.
  • Collaborate with analytics, data science, and business teams to understand data requirements.
  • Monitor, troubleshoot, and resolve pipeline failures and performance bottlenecks.
  • Follow best practices for data engineering, security, and documentation.

Required Skills & Qualifications
  • Strong experience with data lake architectures and large-scale data processing.
  • Hands-on experience with AWS services (e.g., S3, EC2, EMR, Glue, or related).
  • Proven expertise in building ETL pipelines for analytics and reporting use cases.
  • Solid working knowledge of Snowflake, including data loading, transformations, and performance optimization.
  • Experience with workflow automation and scheduling tools such as Control-M and Apache Airflow.
  • Proficiency in PySpark for distributed data processing.
  • Strong programming experience with Apache Spark using Java.
  • Good understanding of data modeling, partitioning, and performance tuning concepts.

Preferred Qualifications (Nice to Have)
  • Exposure to CI/CD practices for data pipelines.
  • Experience working in Agile or DevOps environments.

Similar Jobs

More Jobs at Ampcus inc

More Information Technology Jobs

Find similar Data Engineer - Intermediate jobs: