Snowflake Data Engineer — Pipelines & Warehouse Expert

American IT Systems; Florham Park (NJ); On-site; USD 110,000 - 150,000; Full time

Job summary

American IT Systems in Florham Park, NJ, seeks a Data Engineer for a contract role. The candidate should have 5–7 years of data engineering experience with Snowflake, SQL, ETL, and cloud data services to design and maintain scalable data pipelines and data warehouses.

You will collaborate with analysts and stakeholders to translate requirements into robust data solutions, ensure data quality and governance, and optimize storage and performance while documenting architectures for maintainability.

Qualifications

• 5–7 years of data engineering or related experience.
• Snowflake data modeling, performance tuning, and query optimization.
• Proficient in SQL and data transformation tools.
• Experience with ETL tools/frameworks and data warehousing concepts.
• Familiar with cloud data services (AWS/Azure/GCP).

Responsibilities

• Design, develop, and maintain scalable data pipelines and ETL processes using Snowflake.
• Collaborate with data analysts and business stakeholders to understand data requirements.
• Optimize data storage and retrieval to enhance performance and reduce costs.
• Implement data governance and security best practices to ensure data integrity and compliance.
• Monitor and troubleshoot data pipeline performance and issues.
• Document data architecture, processes, and workflows for knowledge transfer.
• Stay updated with Snowflake and data engineering trends.

Skills

Snowflake expertise

SQL proficiency

Data transformation

Data warehousing concepts

Analytical problem-solving

Education

Bachelor's degree in Computer Science or IT

Tools

ETL tools

Airflow

Prefect

Cloud data services (AWS/Azure/GCP)

Tableau/Power BI

Job description

American IT Systems in Florham Park, NJ, seeks a Data Engineer for a contract role. The candidate should have 5–7 years of data engineering experience with Snowflake, SQL, ETL, and cloud data services to design and maintain scalable data pipelines and data warehouses.

You will collaborate with analysts and stakeholders to translate requirements into robust data solutions, ensure data quality and governance, and optimize storage and performance while documenting architectures for maintainability.