Lead Warehouse Engineer - Hot Web 2.0 Company (Newton, MA)

If you are interested in joining a super-hot Web 2.0 company with great people in an exciting industry, please send a resume and cover letter to dennis@wirelessjobs.com.

Extra bonus: If you've worked at either Google, VistaPrint, Lycos, or Monster, you've got a leg up on the competition.

The Lead Warehouse Engineer is part of a small Warehouse team at this company in South Boston (MA). The Data Warehouse is a critical component of the overall technology architecture. He/She will have an opportunity to make an impact and should be excited about being part of the team that makes a difference to the daily lives of our consumers in other parts of the organization, such as Sales, Marketing, Content and Engineering.

This engineer will act as the technical lead/architect of the 12 terabyte data warehouse system. This position requires that the engineer roll up their sleeves and write code. This is NOT a design and blue sky only role.
The qualified individual will have a proven track record delivering high quality results, while thriving in a quickly paced environment.

Responsibilities:
- Techincal direction for the following warehouse systems
- Core relational warehouse database
- Microsoft Analysis Services
- Microsoft Reporting Services
- ETL system currently used to populate core warehouse
- Ensuring warehouse systems are in place to deal with our explosive growth
- Leading and mentoring other members of the team
- Work with the team on items such as DBA related work, cube creation, and maintenance, ongoing optimization of the existing data structures, creating user friendly reporting systems
- Help in developing SSIS Packages, scripts, programs, and schemas to facilitate data movement and cleansing for both internal systems and external data feeds
- Maintain and monitor all the warehouse systems to ensure their proper operation, performance, and availability
- Responsible for writing reports for different business constituents within the company

Requirements:
- BS in Computer Science or equivalent (MS a plus)
- 3+ years of experience on SQL Server 2000/2005. Experience with other relational databases is a plus.
- Warehousing concepts, dimensional modeling, star schema
- 2+ years of experience with very large data warehouses including design and tuning
- SQL Server Analysis Services - 2005 OLAP experience including design and deployment of complex cubes
- Proficiency in Transact-SQL (SQL Server 2005 specific), complex queries, stored procedures, fu nctions and other related system objects
- Proficiency in SQL tuning, understanding optimization (index types, search arguments, covered indexes, etc.)
- SQL Server Integration Services (SSIS)
- Organized, self-motivator, great communicator and detail oriented
- Strong analytical and problem-solving skills
- Sense of humor and good people rapport
- Ability to deal with the pressure of juggling lots of tasks
- Ability to prioritize or learn how to shift projects quickly
- Experience as a programmer in a JAVA/.NET technologies (C#, VB) environment is a definite plus
- Exposure to SharePoint
- Exposure to Performance Point Server 2007
- Exposure to Ominiture / Visual Sciences