Data Engineer – Snowflake

AIG

Data Engineer working on Snowflake Data Platform to build data lakes and warehouses. Collaborating with cross-functional teams on AI/ML initiatives in the financial services sector.

Posted 4/28/2026full-timeHouston • California, New Jersey, Texas • 🇺🇸 United StatesMid-LevelSenior💰 $107,000 - $126,000 per yearWebsite

Tech Stack

Tools & technologies

AirflowAmazon RedshiftApacheAWSCloudETLHadoopInformaticaJavaKafkaPythonSparkSQL

About the role

Key responsibilities & impact

Snowflake Platform Engineering: Build and manage complex Snowflake Data Warehouse and Data Lake environments utilizing Open Data formats (Iceberg); design scalable data pipelines using Snowpark, Snowpipe, and OpenFlow, and develop native applications via Streamlit.
Drive platform excellence by implementing advanced virtual warehouse optimization, rigorous cost-management strategies, and automated governance frameworks to ensure high performance and scalability.
ETL/ELT Pipeline Development: Design and maintain automated ETL/ELT pipelines using Configurable ETL frameworks to ingest and transform data from diverse source systems into Snowflake Data Platform and Data Lakes.
Partner with stakeholders to translate business needs into scalable data solutions, ensuring high-quality batch and real-time processing for regulatory and financial reporting.
AI/ML Support: Collaborate with Data Scientists to build data foundations for machine learning models, including feature engineering and preparing datasets for training/inference for AWS based AI/ML Platform leveraging Amazon Bedrock and SageMaker.
Data Governance: Ensure data quality, integrity, and security, maintaining compliance with financial industry standards.

Requirements

What you’ll need

Bachelor’s degree in computer science, Engineering, Data science, or a related technical field.
5 + years of Data Engineering experience with at least 3 years of strong hands-on experience in Snowflake.
SnowPro Core or SnowPro Advanced Data Engineer Certification Preferred.
Strong SQL experience and proficiency in Python/Java for data manipulation and automation.
Proven experience using cloud technologies, with significant hands-on experience in Snowflake Data Platform (Warehouses, Horizon Catalog, Snowpark, Snowpipe, OpenFlow, Streamlit, Cortex) & AWS AI/ML Services.
Hands-on experience with ETL/ELT frameworks (e.g., Apache NiFi, Airflow, Talend, dbt, Informatica, DataStage, AWS Glue)
Expertise in big data technologies (e.g., Hadoop, Spark, Kafka, Databricks) and Cloud data warehouses (Snowflake, Redshift)
Strong problem-solving abilities and a passion for working with cutting-edge technologies.
Excellent communication and collaboration skills to effectively work within a cross-functional team.

Benefits

Comp & perks

Health and Wellness: We offer a range of medical, dental and vision insurance plans, as well as mental health support and wellness initiatives to promote overall well-being.
Retirement Savings: We offer retirement benefits options, which vary by location. In the U.S., our competitive 401(k) Plan offers a generous dollar-for-dollar Company matching contribution of up to 6% of eligible pay and a Company contribution equal to 3% of eligible pay (subject to annual IRS limits and Plan terms). These Company contributions vest immediately.
Employee Assistance Program: Confidential counseling services and resources are available to all employees.
Matching charitable donations: Corebridge matches donations to tax-exempt organizations 1:1, up to $5,000.
Volunteer Time Off: Employees may use up to 16 volunteer hours annually to support activities that enhance and serve communities where employees live and work.
Paid Time Off: Eligible employees start off with at least 24 Paid Time Off (PTO) days so they can take time off for themselves and their families when they need it.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SnowflakeSQLPythonJavaETLELTApache NiFiAirflowTalendAWS Glue

Soft Skills

problem-solvingcommunicationcollaboration

Certifications

SnowPro CoreSnowPro Advanced Data Engineer