Technical Analyst
American International Group, Inc.
Makati City
6d ago

Functional Area :

IT - Information TechnologyEstimated Travel Percentage (%) : Relocation Provided : AIG Shared Services Corporation

Your future team

Our technology teams collaborate with their worldwide colleagues and partners every day to take on the challenges of providing IT support to one of the world’s leading financial services firm.

We’re people who believe that with the right values and hard work, anything is possible. We know that if we’re at our best, that enables our customers to be their best and realize their dreams and hoped for successes.

The Information Technology group provides enterprise-wide IT solutions for all of AIG’s specialized disciplines. Technology provides strategic and procedural support in all of AIG’s specialized disciplines, such as policy issuance, premium collection, claims handling, and administration.

It enables AIG to deliver business strategies through efficient world-class IT and operations services, while ensuring the necessary IT risk management and security measures are in place.

Your contribution at AIG

As an Influencer at AIG, people come to you as a go-to source for help and support because of your deep knowledge and expertise.

As a more experienced team member, you are capable of driving continual improvement and impacting the way that things get done.

Because of your influence, whether direct or indirect, we are able to deliver powerful outcomes for our clients.

  • Report analysis, design, develop and enhance processes that extract data from various data sources (GOALD, EDSAT, CLASS, EMMA, PMANAGER, etc.
  • and generate report in a format such as Excel, text file, HTML which is used for management reporting or as an upload to other application.

  • Coordinate with business / report owners to clarify / establish report requirements to develop report specifications
  • Create detailed report specification and source mapping.
  • Data analysis; investigation of issues / exceptions encountered in the data extracts processes (stored procedure / SQL Scripts / VBS / Excel Macro) or batch processes or application source code in VB6;
  • document analysis of the problem; provide solution and estimation of required effort.

  • Perform tuning and optimization of Stored Procedures and SQL scripts.
  • Perform quality assurance testing of the generated reports.
  • Provide support on missed reports.
  • Deliver manually generated daily / weekly / monthly / quarterly / yearly reports.
  • Serve as back-up to other application that will be assigned.
  • Provide business / technical assistance to other team member if needed or required.
  • What we are looking for

  • A proven track record in report analysis, design, and develop using Stored procedures (T-SQL, ETL et.al), SQL Scripts, VB6, and / or Excel Macro
  • A good level of experience in ETL and performance tuning and optimization
  • You will already have a solid background / experience in reports generation, presentation, data mining and are now looking to take the next step-up in your career
  • It has been and will continue to be the policy of American International Group, Inc., its subsidiaries and affiliates to be an Equal Opportunity Employer.

    We provide 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.

    At AIG, we believe that diversity and inclusion are critical to our future and our mission creating a foundation for a creative workplace that leads to innovation, growth, and profitability.

    Through a wide variety of programs and initiatives, we invest in each employee, seeking to ensure that our people are not only respected as individuals, but also truly valued for their unique perspectives.

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form