Data Engineer

AIG; London; On-site; GBP 60,000 - 100,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer and elevate your career while making a significant impact in the actuarial domain. You will manage critical data processes, support regulatory reporting, and collaborate with diverse teams to enhance actuarial functions. This role offers a unique opportunity to work with cutting-edge technologies, including transitioning systems to Snowflake and converting programs to Python/R. If you thrive in a collaborative environment and are passionate about data engineering, this position is perfect for you. Enjoy a comprehensive benefits package that supports your personal and professional growth.

Benefits

Comprehensive benefits package

Professional development opportunities

Flexible working arrangements

Employee Resource Groups (ERGs)

Collaborative work environment

Qualifications

• 5+ years of experience in Data Engineering and Application Management.
• Strong problem-solving skills with attention to detail and tight deadlines.

Responsibilities

• Manage data for UK/Europe processes and support actuarial reporting.
• Lead technical resources and collaborate with IT and actuarial partners.

Skills

Data Engineering

Data Application Management

Mainframe Technologies (COBOL, JCL, TSO)

SAS Programming

SQL

Oracle

PowerBI

Snowflake

JAVA

Python

R

Problem-Solving

Agile Methodologies

Education

Bachelor's Degree in Computer Science or related field

Tools

Snowflake

PowerBI

Agile Tools (Rally)

Job description

Join us as a Data Engineer to take your career to the next level with a global market leader.

How you will make an impact

You will be responsible for day-to-day applications management, functional enhancement, data stewardship and be a subject matter expert in support of AIG’s International Actuarial function.

This is a strategic role supporting mission critical actuarial AIG functions. This includes leading technical resources, partnering with AIG IT, and actuarial business partners. The senior associate is responsible for supporting deliverables in a highly outsourced model. The Actuarial Data Engineering Senior Associate will work collaboratively with Product owners and vendor partners to ensure the business changes are done on a priority basis. The ideal candidate ensures that roadmaps and product plans are in place to achieve the long-term objectives.

Key responsibilities:

• Analysis, design, technology development, and delivery accountability for mission critical actuarial processing initiatives across AIG.
• Manage the data used for UK/Europe process including segmentation into lines of business during Month/Quarter end close. Actuaries use this data in Loss reserving to create Gross and Net loss triangles.
• Provide the data used for Monthly Global AvE reporting (UK/Europe)
• Maintaining the Quarter end process providing data for international segmentation, IBNR calculation and international reserving processes.
• Delivery of all required reports to Reserving Actuaries on a monthly/quarterly basis.
• Provides International premiums and losses data for UK/EU regulatory reporting and statutory processes.
• Provides support to actuaries for ad hoc data requests.
• Supports audits across all actuarial system processes.
• Responsible for fostering and maintenance of relationships with business and IT partners.
• Ensure that all solutions adhere to AIG standards for security.
• Document enhancements and improve existing documentation of actuarial processes
• Involvement in transitioning data and systems from Mainframe to Snowflake
• Involvement in converting SAS programs to Python/R

What you'll need to succeed:

• 5+ years Data Engineering experience
• Good experience in Data Application management
• Experience in Mainframe technologies – COBOL, JCL, TSO, ISPF, ENDEVOR, SDSF, JMR, IBM File Manager
• SAS programming skills
• SQL experience
• Experience of Oracle, PowerBI, Snowflake, JAVA, Microsoft technologies desirable
• R and Python experience desirable
• Experience in developing and productionizing complex data engineering solutions.
• Strong problem-solving skills with attention to detail
• Ability to work under challenging production situations fulfilling tight deadlines and budget constraints.
• Ability to work with large vendor teams across multiple geographies.
• Experience in providing technical expertise and project leadership by conducting industry and market research and making recommendations regarding current and new domain knowledge and related technologies.
• Familiarity with Agile methodologies and ability to use Rally to track user stories.
• Ability to work independently and actively seek to improve the actuarial processes

#LI-AIG

At AIG, we value in-person collaboration as a vital part of our culture, which is why we ask our team members to be primarily in the office. This approach helps us work together effectively and create a supportive, connected environment for our team and clients alike.

Enjoy benefits that take care of what matters

At AIG, our people are our greatest asset. We know how important it is to protect and invest in what’s most important to you. That is why we created our 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.

Reimagining insurance to make a bigger difference to the world

American International Group, Inc. (AIG) is a global leader in commercial and personal insurance solutions; we are one of the world’s most far-reaching property casualty networks. It is an exciting time to join us — across our operations, we are thinking in new and innovative ways to deliver ever-better solutions to our customers. At AIG, you can go further to support individuals, businesses, and communities, helping them to manage risk, respond to times of uncertainty and discover new potential. We invest in our largest asset, our people, through continuous learning and development, in a culture that celebrates everyone for who they are and what they want to become.

Welcome to a culture of inclusion

We’re committed to creating a culture that truly respects and celebrates each other’s talents, backgrounds, cultures, opinions and goals. We foster a culture of inclusion and belonging through learning, cultural awareness activities and Employee Resource Groups (ERGs). With global chapters, ERGs are a cornerstone for our culture of inclusion. The talent of our people is one of AIG’s greatest assets, and we are honored that our drive for positive change has been recognized by numerous recent awards and accreditations.

AIG provides equal opportunity to all qualified individuals regardless of race, color, religion, age, gender, gender expression, national origin, veteran status, disability or any other legally protected categories.

AIG is committed to working with and providing reasonable accommodations to job applicants and employees with disabilities. If you believe you need a reasonable accommodation, please send an email to [e-mail].

Functional Area:

DT - Data AIG Europe S.A. (U.K. Service Branch) & American International Group UK Ltd