Senior Data Warehouse Developer - Tewksbury, MA << Back to Careers

Our IT Team, based in Tewksbury, Massachusetts, is comprised of dedicated, passionate, smart individuals working in application and web development, system integration, business intelligence and network engineering. We maintain a high energy, collaborative work environment.  Core to our philosophy is that to achieve success, we must partner effectively with the other business stakeholders within the enterprise.  Our IT organization provides leadership in a broad range of challenging, strategic initiatives which combine technology and process expertise with business acumen.



We are currently seeking a hands-on Data Warehouse Developer who has both detailed code-level expertise and broader strategic perspective to strengthen the BI capabilities of WellPet.  In this position you will report to the Director of IT and have specific responsibility for the evaluation, design,  implementation and on-going support of the enterprise data warehouse and business intelligence platform.  Working from our Tewksbury office, you will have an opportunity to partner across the business to leverage your expertise and drive the business forward.


Position Description (Responsibilities):

  • Interact with functional business units to analyze, gather and prioritize business and reporting requirements
  • Assume leadership role in design, implementation, testing, and roll-out of enterprise data warehouse and data marts including development of proof-of-concepts
  • Formulate and provide status updates on project plans and schedules to meet  goals/objectives
  • Create and enforce corporate standards for data warehouse design and data integrity
  • Ensure data architecture supports existing and future requirements of evolving business model
  • Evaluate and analyze existing OLTP databases and develop/maintain integrations to data warehouse.
  • Lead development and maintenance of operational, analytic, dashboard and executive-level reporting  using Business Objects Crystal Reports, Microsoft Reporting Services, Microsoft Sharepoint and other BI tools
  • Evaluate, test and assist in selection of Reporting and BI tools.
  • Monitor and stay abreast of key developments in BI industry
  • Live the WellPet values and culture and doing whatever it takes for the pets who depend on us



Position Requirements:

The position requires 10+ years of data warehousing experience. The ideal candidate is local to the Greater Boston or Southern New Hampshire area, and must possess deep expertise in data warehousing methodologies (Kimball, Inmon), dimensional modeling, and the ability to bring best practices with regard to master data management, ETL, and data governance.   The candidate should have a demonstrable record of being able to interact effectively with business stakeholders at all levels in all functional areas to gather and understand business requirements and reporting needs. In addition, we are seeking an individual with:


  • A BA or BS in Information Systems, Information Technology, or Computer Science
  • A deep expertise with  OLTP design,  data warehousing, dimensional modeling,  BI, ETL, and data governance
  • At least 5 years’ experience in manufacturing and distribution and working with ERP Systems (IFS, Oracle, SAP, Microsoft Dynamics etc.) and CRM (Salesforce, Pivotal, Sales Logix, Microsoft CRM)
  • At least 5 years’ experience using Microsoft SSRS, SSAS and SSIS  (2005 and/or 2008)
  • Equally adept working in Oracle and SQL Server environments using PL-SQL and/or T-SQL
  • Experience with BI and Reporting Platforms such as Business Objects, Cognos, Microstrategy, MS SharePoint
  • Passion for data warehousing and business intelligence
  • The ability to communicate and interact effectively at both technical and business level
  • A strong work ethic and ability to self-start
  • A strong team player mentality with proven ability to work effectively cross-functionally
  • Excellent verbal and written communication skills
  • Excellent customer service skills
  • Strong organizational and multi-tasking skills
  • Ability to evaluate and learn new technologies quickly
  • Strong attention to detail and accuracy



To apply, please send your resume to and include “Senior Data Warehouse Developer” in the subject line.

<< Back to Careers