Chevy Chase, Maryland, United States at https://geico.referrals.selectminds.com/jobs/7863/other-jobs-matching/location-only
Information Technology at http://geico.referrals.selectminds.com/landingpages/information-technology-opportunities-at-geico-19
Apply for Job
Share this Job
Sign Up for Job Alerts
Want to be an IT Superhero, All-Star, Cheerleader, or Explorer? All of the above? Got it! Ok, we have the job for you as a Data Architect for the Enterprise Data Warehouse team.
Looking for a highly motivated, high energy, self-starter, problem solver, with a positive attitude, a strong work ethic, and solid interpersonal and communication skills. Must have intellectual curiosity and a desire to learn new skills and technologies.
7 year experience as a Data Warehouse Data Architect
Strong Project Management Experience
Demonstrate the ability to create high quality technical artifacts such as Source to Target Mappings (STMs) and Record Level Specifications (RLS)
Experience 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
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
Associate assistance program
Flexible spending accounts
Business casual dress
Fitness and dining facilities (at most locations)
Associate clubs and sports teams
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.