[BBLISA-jobs] Data Warehouse Guru - Cambridge, MA

[Don Harpin]

Our company is a leader is the online dating and social networking
industry for gay men around the world. Our company and suite of websites
serve over 4 million users around the globe. For more information about
our company, our websites, positions available, and our benefits
package, visit our corporate website at www.online-buddies.com. We offer
very competitive salaries and a comprehensive benefits package. 

The Data Warehousing Guru is responsible for providing data for business
intelligence to internal management by mining/transforming mountains of
data into a flexible, understandable and manageable reporting framework.


Essential duties include... 

* Meet with business leaders to gather data needs and then design
data-gathering infrastructure to satisfy those needs. 
* Identify options for potential data solutions and assess them for both
technical and business suitability 
* Create logical and physical design of the data warehouse and all
associated schemas (hands-on DB work) 
* Strategize data aggregation and consolidation techniques 
* Research, evaluate, prototype, and learn tools to assist in the above 
* Design reports to represent the data gathered. Make the mountains of
data *useful* for business leaders. 
* Other duties as assigned 

Education and Training... 

* BS or BA degree preferred 
* Experience with OLAP and multi-dimensional data analytics products and
technologies (e.g. Cognos, Business Objects, Hyperion, Pentaho etc).
Identify best solution for current and ongoing business needs 
* Strong relational database technologies experience, including schema
modeling and design 
* Write advanced SQL queries, preferably in complex MySQL environments 
* Create data-transformation and data-aggregation functionality (bash
scripts, MySQL events, triggers etc) 
* Ability to translate business concepts into data and vice versa 
* Contribute to improvements in technical and business processes 
* Handle multiple tasks, switching priorities and focuses as needed 
* Experience with Data Warehousing concept like *fact tables*,
*dimension tables*, *rollups*, *data cubes* 
* Experience with manipulating and *cubing* raw data within Excel is a
plus 

Skills and Competencies... 

* Solid working knowledge of Unix/Linux environments 
* MySQL experience a plus, but solid demonstrable experience with other
relations DBs is OK (MSSQL, Oracle, PostgreSQL etc) 
* Previous hands-on experience installing/configuring a data analytics
product (Cognos, Pentaho, Business Objects etc) 
* Experience using Non-relational and/or *NoSQL* database technologies
to supplement MySQL 

For more information about our company, our websites, positions
available, and our benefits package, visit our corporate website at
www.online-buddies.com. 

No phone inquiries please!

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.bblisa.org/pipermail/bblisa-jobs/attachments/20100513/17deb86c/attachment.htm