Data Architect

Annapolis, MD
Mar 01, 2021
Mar 03, 2021
IT, IT Architect
Full Time
Job Description GEICO is looking for a Data Architect for the Data Security and Infrastructure (DSI) 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. Requirements: * 5+ years' experience as a Data Architect * 5+ years' Data Warehouse experience. Candidate must have experience with designing Data Warehouse schemas (3NF model) as well as Data Mart schemas (Dimensional model) * 5+ years' experience integrating data from disparate sources * 5+ years' experience in Agile development methodologies * 3+ years' expert knowledge of Azure Data & Storage, Azure Data Bricks * 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) * 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 multitask under tight deadlines * Able to work independently as well as be a strong team player * Experience with population of metadata repositories and publication of metadata * Experience creating and documenting classifications of Private and sensitive data * Understanding of data security and data access controls and design aspects * Proficient with Erwin Data Modeler and MS Office Suite Preferred Skills: * P&C Insurance Subject Area Model experience (ie Policy, Sales, Service, Claims, and Billing systems) * 3+ years' experience with Database Platforms (DBaaS): Snowflake, Azure SQL DB * 3+ years' exposure to SnowSQL, advanced concepts (query performance tuning, time travel etc.) and features/tools (data sharing, events, SnowPipe etc.) * 3+ years' experience with the Azure suite (Azure Data Lake, Azure Data Factory, Azure DevOps) * 5+ years' exposure to Traditional RDBMS: SQL Server, Oracle, DB2, Cosmos DB, Hive * 5+ years' experience with Big Data Experience. Hadoop, Hive, Linux. * Very good knowledge of RDBMS topics, ability to write complex SQL, PL/SQL * Experience with Data Vault 2.0 Methodology * Expert knowledge developing data models for deployment on Snowflake Platform * Willingness to learn and experiment with technologies outside of his/her comfort area 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. #LI-MW1 #DI-MW

Similar jobs