Business Data Analyst

AIG Insurance•Jeffersonville, IN

4d•Onsite

About The Position

At AIG, we are reimagining the way we help customers to manage risk. Join us as a Business Data Analyst 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 AIG Warranty AIG Warranty delivers a full range of service solutions including warranty management administration, extended service programs, customer service support, service network management, claims processing services, and service contract underwriting. Our specialized functions are delivering on AIG's promise to our customers, our clients, our shareholders, and each other. Thanks to our global network of highly skilled professionals, we can mobilize experts from around the world to provide reliable, responsive claims service wherever and whenever our clients need it. The Business Data Analyst position is aligned with our internal business teams to support the data set-up, mappings, data migration and reporting for new client launches. This will involve gathering user requirements, data process flows, mappings and user story construction for Reporting needs. Understanding of the underlying data, how to move the data into reportable data structures, and building reporting / dashboards for business users is a key part of the role. The position will work in a collaborative team environment, with independent duties. The Business Data Analyst role will be the business owner for the data integrity and implementation on our new system the Warranty Information Servicer Hub (WISH). This role will support the data needs for onboarding new clients and migration of existing clients. Responsibilities include, but not limited to data analysis, documenting processes, leading business review session to review data structure, consolidation, mappings, address any data anomalies. Work with business owners on the migration, design and set up of reporting needs. This role will work closely with IT and data stewards on the data set up and clean up of data exceptions.

Requirements

Bachelor’s Degree with business, technology, math, statistics or related field preferred
Expert knowledge of SQL and PowerBI
Experience with AWS, Containers, Glue, Lambda, S3 technologies
Experience with handling large volumes of data, data ingestion and transformation
Experience with auditing data and identifying data anomalies and root cause
Analytical, decision making and problem-solving abilities
Ability to manage multiple deliverables
Experience in Agile methodologies
Demonstrated strategic thinking and ability to collaborate with diverse stakeholders
Strong communication skills, including facilitation/event storming experience
High sense of ownership and responsibility to all stakeholders to ensure work quality

Nice To Haves

Knowledge of Python and Snowflake is desirable

Responsibilities

Work with business stakeholders and IT to analyze, define and document data requirement and reporting requirements
Provide the data oversight for our business, by establishing needed checks/balances, identifying business owners for data and establishing SLA’s to address issue
Manage reporting request from business owners and document requirements.
Manage the review with key stakeholders on data structure, mappings and data consolidation
Work with IT System Analyst on design/development of templates and/or applications to support data administration and input
Document data flows
Business contact to address data and/or mapping questions
Participate in project development and implementation to ensure business requirements are delivered
Develop plans and participate in user acceptance testing of data requirements and coordinate sign-off from the business stakeholders
Performs other duties as assigned or requested