Internet / E-Commerce Company in search of a Lead Warehouse Engineer (MSAS) in the greater Boston area to act as the technical lead/architect of a 12 terabyte warehouse system. This position requires writing code; it is not a design and blue sky role.

Notes: The hiring company will not consider candidates with a consulting only background, or candidates that do not have experience with SQL Server 2000/2005, and cube design/development experience. The client is not currently providing visa transfers or sponsorship. An ideal candidate would have worked for Google, VistaPrint, Lycos, or Monster.

Relocation assistance is not provided but may be considered for an outstanding candidate. Travel costs, if any, that are incurred for interviews will be reimbursed.

Responsibilities

The successful candidate will have the following responsibilities, which requires experience with similar to identical responsibilities:
• Provide technical direction for the core relational warehouse database
• Microsoft Analysis Services
• Microsoft Reporting Services
• ETL to populate the core warehouse
• Ensure the company has warehouse systems in place to deal with explosive growth
• Lead and mentor other warehouse team members
• Work with the team on items such as
o DBA related work
o Cube creation
o Maintenance
o On-going optimization of the existing data structures
o Creating user friendly reporting systems
o Help in developing SSIS packages, scripts, programs, and schemas to facilitate data movement and cleansing for internal and external data feeds
o Maintain and monitor all warehouse systems to insure proper operation, performance, and availability
• Write reports for different business constituents within the company

Requirements
• BS in computer science or equivalent (MS preferred)
• 3+ years experience on SQL Server 2000/2005
• Experience with other relational databases a definite plus
• Warehousing concepts, dimensional modeling, star schema
• 2+ years 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, functions 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-motivated, great communicator and detail oriented
• Strong analytical and problem solving skills
• Sense of humor and good people rapport
• Able to deal with the pressure of juggling lots of tasks
• Able to prioritize and shift projects quickly
• Experience as a programmer in JAVA/.NET technologies (C#, VB) environments is a very huge plus and highly desirable
• Exposure to SharePoint, Performance Point Server 2007, and Ominiture/Visual Sciences desirable
• Willing to travel on occasion

Compensation package
• Highly competitive base salary plus bonus
• Benefits include
o Free catered lunches
o Generous rewards for a job well done
o Summer Fridays off
o Game room with Xbox and a football table
o 3 weeks of vacation
o Health
o Medical, dental, vision, disability, and life insurances
o Flexible spending accounts
o 401(k) savings plan with company match
o Equity opportunities
o Matching charitable gift program
o Paid holidays
o Sick and parental leave
o Adoption assistance
o Fitness subsidy
o Tuition assistance
o Free parking / transit subsidy
o No formal dress codes
o On-line learning and development classes
o On-site fitness center

Contact Raymond Bonczek, Niche Technologists, Inc. 610-847-2143 or rbonczek@nichetech.com