US_East | DATA ARCHITECT / DATA OFFICER_L3

Ampcus - Los Angeles, CA

Full-time - Senior

Los Angeles, CA

Professional, Scientific, and Technical Services

About the position

The Data Architect/Data Officer role is focused on designing and implementing semantic data layers for self-service analytics and AI, particularly within the insurance business domain. The position requires extensive experience with data virtualization tools and cloud data platforms, specifically AWS and Snowflake. The role is hybrid, requiring some onsite presence for onboarding and collaboration with the Capgemini team.

Responsibilities

• Design semantic data layers on ODS, Data Warehouse, Data Lake, and Lakehouse for self-service analytics and AI.
• Utilize data virtualization tools such as Dremio, Denodo, AtScale, and TIBCO.
• Optimize SQL performance and tuning for analytical systems.
• Manage data cataloging and metadata management processes.
• Collaborate with project teams to ensure alignment with business requirements.

Requirements

• 15+ years of experience in data architecture or related fields.
• Solid experience with the insurance business domain and core business systems.
• Excellent SQL skills, including performance tuning and optimization.
• Experience with Lakehouse solutions, particularly with AWS and/or Snowflake.
• Familiarity with data virtualization tools like Dremio, Denodo, AtScale, and TIBCO.
• Experience with cloud data platforms, preferably AWS.

Benefits

• Travel costs covered by Capgemini if relocation is necessary for onboarding.