Sr Data Engineer at American International Group in Charlotte, NC

Who we are

American International Group, Inc. (AIG) is a leading global insurance organization. Building on 100 years of experience, today AIG member companies provide a wide range of property casualty insurance, life insurance, retirement solutions, and other financial services to customers in more than 80 countries and jurisdictions. These diverse offerings include products and services that help businesses and individuals protect their assets, manage risks and provide for retirement security.

Get to know the business

The Investments business is one of the key drivers of revenues and profitability at AIG. Our Investments professionals are responsible for investing the insurance premiums and deposits we collect to generate net investment income that is available to pay claims or benefits and provide returns to shareholders. AIG Investments provides advisory and asset management solutions to AIG, its business units and third-party clients, globally, maintaining an internal investment platform across multiple asset classes. These asset classes include investment grade and high yield corporate debt, sovereign and emerging market debt, municipal debt, securitized products, residential and commercial mortgage loans, private placements, real estate, public equities and private equity. The Investment team is comprised of portfolio managers, traders, research analysts, product owners, loan originators and underwriters and other professionals endeavoring to provide strong returns on our clients’ invested capital. At AIG Investments, we are thought leaders in the global asset management industry with expertise and capital spanning the globe.

About the role

What you need to know:

AIG is seeking experienced candidates to join our Investments+ IT Team. The ideal candidate will report directly to the Investments+ IT Data Architecture Lead.

The position is responsible for design, development and supporting business operations for the Investments+. The individual will work with our business users to develop, deliver and monitor the provision of Data Management and Integration services.

Key responsibilities for this role, include but are not limited to:

• Design and build end to end data flows using modern technologies and adhering to enterprise standards. This includes but not limited to data cleansing, data mapping, data transformation and data standardization techniques.
• Developing an ecosystem to support business teams in managing and using their data.
• Pursue a rigorous, disciplined approach to software development process and automation.
• Develop, test and maintain build and deployment scripts in CI/CD framework/tools to automate and streamline deployment processes.
• A keen eye for encryption and data security.
• Implement strong data governance and quality solutions.
• Research, suggest, and apply new promising technologies, strategies and ways to solve technical issues.

What we are looking for:

Ideally the successful candidate will have working knowledge and the ability to demonstrate hands on experience with the following technologies:

• Strong hands-on experience with SQL and Stored Procedure database development using leading databases like Snow Flake, Oracle, Postgres is required; Experience in handling large data warehouse is required
• Experience with Cloud technologies (e.g. AWS), Cloud data warehouses (Snowflake/ Redshift) and Big data technologies like spark/data Bricks would be highly preferable
• Amazon Web Services - S3, EMR, Athena, Glue, Kinesis etc., CI /CD – Jenkins, GitHub, JFrog etc.,
• Experience with one of the ETL technologies like Talend is highly preferable.
• Programming Languages like java Script , Python
• Data Modeling, Data Governance and Data Quality processes
• SQL, NoSQL and BI experience

Desirable skills include:

• Data Visualization (MicroStrategy, Power BI, Tableau)
• Financial domain experience
• Linux and Windows server concepts

Base Skills include:

• Bias for Action and Service Orientated.
• Strong strategic development and project execution skills, with proven ability to deliver key tasks on time and on budget.
• Exceptional communication skills, including ability to develop and present clear and concise analysis and recommendations to senior management.
• Strong analytical skills.
• Proven ability to dissect complex business issues, performs research and analysis, and synthesize conclusions into a value-maximizing strategy.
• Strong business acumen with a proven track record of making sound judgments backed by strong analytical skills.
• Comprehensive awareness of the business and regulatory environment.

Education and Experience:

• 6+ years of experience
• Bachelor's Degree
• Product leadership with scope of influence
• Ability to mentor others