Data Engineering Senior Associate

AIG Insurance•Jersey City, NJ

40d•$96,000 - $120,000•Onsite

About The Position

At AIG, we are reimagining the way we help customers to manage risk. Join us as a Data Engineering, Senior Associate to play your part in that transformation. It’s an opportunity to grow your skills and experience as a valued member of the team. Make your mark in Information Technology At AIG, technology is at the heart of everything we do, from underwriting risks to processing claims. The Information Technology team equips our colleagues with the latest tools to complete their work efficiently and with the highest standards of excellence. The team is responsible for shielding the company’s systems from security risks, while designing technology strategies that enable AIG’s businesses to achieve their goals. AIG’s Information Technology functions include enterprise architecture, software and systems engineering, cybersecurity, and technology risk and compliance. How you will create an impact We are seeking a Data Engineer with 5 years of experience in building robust data solutions. The candidate will collaborate with various project teams on multiple ongoing activities, including tasks that may extend beyond standard service level agreements. Work closely with business teams to understand requirements and support data needs Perform data analysis, manage ad-hoc data requests, and ensure high-quality data availability to drive data-driven decision making Develop and maintain data pipelines across diverse environments (Snowflake, Oracle Exadata, SSIS, etc.) Collaborate with multiple teams to deliver data solutions for Artificial Intelligence, Machine Learning, and business intelligence initiatives Collaborate with cross-functional teams to deliver high-quality, scalable, and secure data products. Conduct data and system analysis to identify and resolve defects, ensuring smooth data flow. Write and fine tune advanced SQL scripts, stored procedures, and queries for large scale datasets. Develop Python-based data processing to streamline data workflows. Perform data quality assessments, cleansing, and transformation to ensure data integrity. Conduct data and system analysis to identify and resolve defects, ensuring smooth data flow.

Requirements

Proficiency in Snowflake and advanced SQL
Experience with Oracle and Python ETL processes
Strong data analysis skills.
Cloud technology experience (AWS preferred)
Ability to design, build, and deploy data solutions.
Passion for working with data and solving complex problems
Familiarity with SSIS and other data environments.
Understanding of data governance, security, and quality management principles.
Working knowledge of data visualization tools such as Tableau or Power BI.
Experience working in an agile development environment.

Nice To Haves

Insurance or financial services domain knowledge is highly desirable.

Responsibilities

Work closely with business teams to understand requirements and support data needs
Perform data analysis, manage ad-hoc data requests, and ensure high-quality data availability to drive data-driven decision making
Develop and maintain data pipelines across diverse environments (Snowflake, Oracle Exadata, SSIS, etc.)
Collaborate with multiple teams to deliver data solutions for Artificial Intelligence, Machine Learning, and business intelligence initiatives
Collaborate with cross-functional teams to deliver high-quality, scalable, and secure data products.
Conduct data and system analysis to identify and resolve defects, ensuring smooth data flow.
Write and fine tune advanced SQL scripts, stored procedures, and queries for large scale datasets.
Develop Python-based data processing to streamline data workflows.
Perform data quality assessments, cleansing, and transformation to ensure data integrity.
Conduct data and system analysis to identify and resolve defects, ensuring smooth data flow.

Benefits

positions based in Jersey City, NJ, the base salary range is $120,000-$96,000 and the position is eligible for a bonus in accordance with the terms of the applicable incentive plan.
proud to offer a range of competitive benefits, a summary of which can be viewed here: 2025 Benefits Summary
Total Rewards Program, a comprehensive benefits package that extends beyond time spent at work to offer benefits focused on your health, wellbeing and financial security—as well as your professional development—to bring peace of mind to you and your family.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume