Senior Data Modeler - Hadoop Ecosystem

Farmington CT
February 22 2018
Insurance, Securities

Functional Area:

IT - Information Technology

Estimated Travel Percentage (%): Up to 25%

Relocation Provided: No

American General Life Insurance Company

Senior Data Modeler - Hadoop Ecosystem

AIG is seeking a Big Data Hadoop Senior Data Modeler to become a contributing team member in designing, developing, and deploying strategic solutions in a Big Data platform for the IT Life, Health, and Disability pillar of the organization.

The candidate will be part of the Information Management organization responsible for architecting and developing a Data Integration Hub enabling AIG to leverage data as an asset by providing a single authoritative view of the business, providing a layer of separation between our complex data sources and our data consumers; thereby, providing each data layer to evolve independently.


  • Architect, design, and conceptually, logically, and physically model data that exists in sourcing systems, data lakes, data warehouses, and data marts supporting the Big Data Hadoop ecosystem supported solutions.
  • Design complex insurance industry standard data models based on the ACORD principals.
  • Develop conceptual subject area data models and data flow diagrams.
  • Develop and maintain metadata definitions for sourcing data stores and all evolutions of the Data Lake from ingested sources to consumers.
  • Communicate, present, and apply data modeling best practices to support application performance, application storage efficiency, and system extensibility.
  • Work closely with administrators, architects, and application teams to insure applications are performing well based on modeling designs deployed.
  • Facilitate data requirements meetings with stakeholders to drive modeling solutions.
  • Develop and maintain comprehensive data model documentation and metadata repositories.
  • Assist developers with query development and performance optimization.
  • Work closely with Management and Data Analyst teams to achieve company business objectives.
  • Collaborate with other technology teams and architects to define and develop solutions.
  • This is a hands-on role.

    Required Skills:

  • Strong working knowledge of ACORD.
  • Experience within the Life Insurance industry space preferred.
  • Excellent technical and organizational skills.
  • Strong communication and team skills.
  • Proficiencies with Agile development practices.
  • Experience with and strong understanding of Data Warehousing and Big Data Hadoop ecosystems.
  • Experience with relational and dimensional data modeling.
  • Experience with canonical modeling for enterprise integration solutions.
  • Strong knowledge of reporting modeling concepts, including dimensional, snowflakes, slowly changing dimensions, and surrogate, compound and intelligent keys.
  • Experience in designing Big Data tables, column families, Hive and HBase database designs within HDFS a strong plus.
  • Project experience in Hortonworks Hadoop distribution a plus.
  • Experience in using data modeling tools like Erwin.

Background and experience desired:

  • The position calls for a seasoned IT professional with senior leadership qualities and background with a minimum of 10 years' experience in IT.
  • 8+ years of experience building and managing complex data model solutions.
  • 4+ years of experience with distributed, highly-scalable, multi-node environments utilizing Big Data ecosystems highly preferred.


  • Bachelor's degree in Information Technology or related field preferred, or equivalent work experience.
  • 10+ years of experience in the IT Industry.

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

Similar jobs

Similar jobs