Hybrid IT Business Analyst, Actuarial Support

at AIG

• Job title: IT Business Analyst, Actuarial Support
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: $100,000 - $128,000 per year
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, SDLC, SQL
• Location requirements: Hybrid, Woodland Hills, United States

About the role

• IT Business Analyst providing end-to-end Project Management and Business Analysis support for the Actuarial Data Repository at Corebridge Financial. Collaborating with actuarial teams for data needs and automation.

Responsibilities

• Provide direct IT support for the Actuarial Business Units
• Coordinate the monthly data provisioning processes with the business and support teams
• Understand the monthly manual tasks/activities for the Actuarial processes
• Perform data analysis on the policy admin systems, databases, excel sheets, and other sources of data required for the various processes
• Conduct meetings/interviews with business users and SME`s to gather high level business requirements
• Analyze business workflows and create business process flow diagrams
• Work with the technical team to find the possibilities for automating the business processes
• Create future state process diagram and story boards and present to the business and propose ideas of automation in detail
• Outline the dataflow in, out and through all these sub systems and the data exports to the valuation systems
• Conduct meetings to plan phases of the project, prioritize activities, and build timelines
• Prepare contingency plans, resource assignments, checkpoints and milestones
• Create detailed project plans, manage and track by working closely with business users, stakeholders, developers, and testers.
• Build credibility, establish rapport, and maintain communication with stakeholders
• Create and maintain project documents - Business Requirement document, Functional Requirement Document, Data mapping sheets, Data Definition documents
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent
• Work on ad-hoc data requests necessary for controls, regulatory requests, filings, 10K reporting, etc.
• Trouble-shoot issues with data processes and/or data
• Create audit checklists based on SOX rules and regulations
• Present periodic dashboard reports on the current program, future opportunities and issues
• Perform quality assurance and coordinate with other testers during development, unit and QA testing to assure consistency with business requirements
• Create tasks (development, QA, ad-hoc, etc.) and assign them to respective teams/resources
• Work with business users to prepare and execute test cases
• Work to bridge gap between the actuarial business users and the policy admin system subject matter experts
• Coordinate with the developers (on and offshore) on implementation and unit testing
• Participate in internal and external quality audit sessions

Requirements

• 3+ years of IT experience, preferably within the financial services sector
• Actuarial support experience highly preferred
• Annuity knowledge preferred
• Familiarity with all phases of the software development life cycle
• Experience documenting requirements for large and complex data processing and analysis projects
• Strong attention to detail in both work performed and presentation of work products
• Experience communicating and interacting with all levels of management in the process of gathering requirements
• Experience working in controlled development, testing and production environments
• Experience with issue tracking/project planning applications such as JIRA.
• Demonstrated ability to work as part of a team
• Solid work ethic, self-driven with the ability to work with minimal supervision
• Experience with coding or writing complex SQL queries preferred
• Experience with AXIS, AON and/or other valuation systems a plus
• Experience with Project Management/Agile/Scrum a plus
• Experience in Data Modeling, Data Warehousing, PL/SQL, Snowflake or ETL processing is a plus

Benefits

• 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.