KAYAK is looking for a highly intelligent data warehouse architect who has data modeling experience. Good candidates will be enthusiastic about data warehousing, scalability, data efficiency, and reporting.
- Conduct analysis from various external and internal sources to target mappings; understand the data requirements and identify inefficiencies
- Works closely with the business organization to define and provide business critical data
- Works with the IT technical team to create, change or modify any required systems/application interfaces
- Responsible for all metadata relating to the KAYAK’s overall data warehouse architecture, descriptions of data objects, access methods and security requirements.
- Mentors more junior Data Modelers on best practices and standards for data modeling.
- Experience with large Operational Data Store, Data Warehouse, Business Intelligence databases
- Good verbal and written communication skills, ability to express complex data issues to team members
- 5+ years data warehouse experience
- Experience with databases such as MySQL, Sybase IQ, HP Vertica; Hive/Hadoop a plus
- Design and Develop ETL Jobs for Data Integration
- Programming experience with scripting languages such as Perl or Unix shell; Java a plus
- Experience with IBM Cognos or Tableau
What KAYAK can offer you
- 4 weeks paid vacation
- Day off on your birthday
- Generous 401(k) matching
- 3 year anniversary travel bonus
- Awesome health, dental and vision insurance plans
- Great deals on Hotels
- No stupid meetings
- Drinks, coffee, snacks, games etc.
- Flexible hours
- Free massages from professional masseuse
- Regular team events/excursions
Now hiring awesome software engineers, and product managers. Check www.kayak.com/careersKAYAK is the best place to plan, book, and manage your travels. We compare hundreds of travel sites at once. If you want to spend hours searching every airline, hotel and other travel site yourself, that’s one option. If you’d prefer an easier way to find a good deal, we can help.Once you find what you want, we give you choices where to book (most travel sites do not), including airline, hotel, car rental and online travel agency sites, and oftentimes even through KAYAK directly.We also offer travel management tools including an itinerary management tool, flight status updates, and price alerts.Our free mobile app is available on iPhone, iPad, Android, and Windows Phone, and is the #1 Mobile Travel App. We have local KAYAK sites in thirty countries.To find out more, visit KAYAK.com