Job Description:GEICO is looking for an IT Data Architect for the Decision Sciences and Business Transformation (DSaT) Data Consumption team where we work to make GEICO enterprise data usable and easily accessible for our internal customers. We are 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. Qualifications: * Minimum 4 years' experience as an IT 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) * 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 architecture and project discussions * Ability to thrive while working on ambiguous or challenging projects * 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 * Big Data experience Preferred Skills: * 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. Note: The safety of our associates, both current and future, is GEICO's highest priority. At this time, most of our associates are working remotely due to the current COVID-19 pandemic. Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area. Once GEICO determines it is safe for associates to return to the office, candidates may be required to work in our Chevy Chase, MD office. Benefits : As an IT Architect, you'll enjoy our Total Rewards Program* to help secure your financial future and preserve your health and well-being, including: · Premier Medical, Dental and Vision Insurance with no waiting period** · Paid Vacation, Sick and Parental Leave · 401(k) Plan with Profit Sharing · Tuition Reimbursement · Paid Training and Licensures *Benefits may be different by location. Benefit eligibility requirements vary and may include length of service. **Coverage begins with the pay period after hire date. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect. The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO hires and promotes individuals solely on the basis of their qualifications for the job to be filled. GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job, unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.