This job posting isn't available in all website languages

Data Architect - Big Data / EDW

Information Technology
R0006124 Requisition #

Ready to make an impact? If so, read on!


The Enterprise Data Warehouse is looking for a highly motivated, high energy, self-starter; a problem solver, with a positive attitude, a strong work ethic, and solid interpersonal and communication skills to join the team as a Senior Data Architect.



• Minimum 5 years’ experience as a Big Data or Enterprise Data Warehouse Data Architect
• Able to gather requirements from both IT and the Business partners
• Demonstrate the ability to create high quality technical artifacts such as Source to Target Mappings (STMs) and Record Level Specifications (RLS) that would be used by developers
• Data Warehouse experience. Candidate must have experience with designing Data Warehouse schemas (3NF model) as well as Data Mart schemas (Dimensional model)
• Familiarity with XML/JSON schemas
• Perform data profiling using SQL
• Prototype ETL transformation logic using Advanced SQL techniques
• Actively participate in Data Warehouse architecture and project discussions
• Able to multi-task under tight deadlines
• Able to work independently as well as be a strong team player
• Proficient with Erwin Data Modeler and MS Office Suite
• P&C Insurance Subject Area Model experience (i.e. Policy, Sales, Service, Claims, and Billing systems)

• UNIX command line and vi editor skills
• Databases: Preferably DB2 and/or Netezza
• Big Data Experience. Hadoop, Hive, Linux




For more than 75 years, GEICO has stood out from the rest of the insurance industry! We are one of the nation's largest and fastest-growing auto insurers thanks to our low rates, outstanding service and clever marketing. We're an industry leader employing thousands of dedicated and hard-working associates. As a wholly owned subsidiary of Berkshire Hathaway, we offer associates training and career advancement in a financially stable and rewarding workplace.

Our associates' quality of life is important to us. Full-time GEICO associates are offered a comprehensive Total Rewards Program*, including:

  • 401(k) and profit-sharing plans
  • Medical, dental, vision and life insurance
  • Paid vacation, holidays and leave programs
  • Tuition reimbursement
  • Associate assistance program
  • Flexible spending accounts
  • Business casual dress
  • Fitness and dining facilities (at most locations)
  • Associate clubs and sports teams
  • Volunteer opportunities
  • GEICO Federal Credit Union

* Benefit offerings for positions other than full-time may vary.

GEICO is an equal opportunity employer. GEICO conducts drug screens and background checks on applicants who accept employment offers.

How to Apply

Click "Apply for Job" to complete your application. You will need an active email address and phone number. Please upload your resume, preferably as Word .doc files or PDF. Once you begin your application you can save it and access it later. Your application should include any work and/or internship experience from at least the past five years.

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions