Data engineer

Agama Solutions • Chicago, IL

4d • Onsite

About The Position

We are seeking a Data Engineer with 2 to 4 years of professional experience to join our team in Chicago, IL. This role requires strong technical skills in SAAS, SQL, Snowflake, and Airflow. You will be responsible for designing, building, and maintaining data pipelines and warehousing solutions.

Requirements

• 2 to 4 years of professional experience as a Data Engineer.
• Strong SQL Skills: Proficiency in writing complex queries, stored procedures, and optimizing SQL Server queries.
• Familiarity with SQL Server data migration processes, including handling large datasets, managing data consistency, and performing data validation.
• Hands-on experience with Snowflake writing SQL queries.
• Experience with native Snowflake ETL/ELT tools such as COPY INTO, Airflow, and Snowflake Tasks.
• Understanding of cloud platforms, particularly AWS.
• Experience integrating Snowflake with cloud storage solutions like S3.

Responsibilities

• Design, build, and maintain data pipelines.
• Develop and optimize SQL Server queries, stored procedures.
• Manage data migration processes, including handling large datasets, ensuring data consistency, and performing validation.
• Write SQL queries within Snowflake.
• Implement ETL/ELT processes for Snowflake using tools like COPY INTO, Airflow, and Snowflake Tasks.
• Integrate Snowflake with cloud platforms, particularly AWS, and cloud storage solutions like S3.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed