The Data Consumption team of Decision Sciences and Transformation (DSaT) department is seeking several highly motivated Data Modelers for the Big Data project. You will work in an Agile environment to help build GEICO's Atomic Layer on the Big Data platform. You should have experience with Data Modeling, be intellectually curious, be a team player and have a solutions oriented attitude.
* Develop entity relationships (ER models) for normalized and dimensional models * Assist and guide existing Data Modelers and Data Architects * Technical evaluation for assignments involving existing models for legacy applications and creation of new models in support of application development * Work closely with the ETL, BI, DBA and other teams to develop appropriate data models * Participates in collaborative working environment using the agile methodology * Provide technical leadership and guidance to business partners, peers and vendor partners. * Performs related duties as assigned or requested.
* Knowledge of Data Warehousing, ETL and BI architectures, concepts and frameworks * Deep knowledge of Kimball and Inmon approaches and the core differences * Experience in data modeling principles/methods including conceptual, logical & physical Data Models. * Capable of facilitating data discovery sessions involving business subject matter experts. * Strong inter-personal skills and ability to work as part of a team * Knowledge and experience in the P&C insurance industry is a huge plus * Experience in translating/mapping relational data models into Data Base Schemas. * Experience with modeling tools (such as ERWin and ER/Studio) * Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL * Ability to create and maintain conceptual/business, logical and physical data models. * Ability to translate a logical model into a physical model, adding appropriate physical objects needed to create the database e.g. indexes. * Experience maintaining a model repository * Ability to synchronize models to ensure that database structures match models * Familiar with metadata ingestion and translation * Bachelor's degree preferred
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.
Let your dream job find you.
Sign up to start matching with top companies. It’s fast and free.