SQL Server Data Warehouse Developer – Emmaus, PA and 50% Remote

September 4th, 2013
Title: Senior SQL Server Data Warehouse Developer
Location: Emmaus, PA and 50% Remote
Skills: SQL Server Data Warehousing
Type: Contract
Pay Rate: Will discuss
Post Date: 9/4/2013

Senior SQL Server Data Warehouse Developer

Work will focus on software development of data warehousing solutions, including dimensional modeling, ETL design & development, OLAP cube technologies and data presentation tools.


  • Create documentation of current data warehouse solutions.
  • Develop logical data models following a Kimball dimensional modeling approach.
  • Develop ETL technical design patterns.
  • Develop physical ETL packages and data mart structures using SSIS.
  • Develop OLAP cube structures using SSAS.
  • Team up with Business Analysts to meet with business users to define new enhancement requirements and/or for new requirements gathering.
  • Define technology based best practices/procedures.


  • 5+ years of relevant experience
  • Five or more years of software development experience utilizing Microsoft database technologies. SSAS, SSIS, and SSRS stack a must.
  • Software development experience should include technical design, coding, unit testing and user acceptance testing.  End to end responsibilities.
  • Excellent team skills and a proven track record in a systems analyst position.
  • Experience in Dimensional Modeling and Kimball’s Enterprise Data Warehouse design and development methodologies, a must
  • Excellent customer care and people care skills
  • Previous IT consulting experience highly desirable
  • Adept at using office productivity tools (i.e., MS Word, Excel, PowerPoint, Access, Visio and Project)
  • Tableau Server and Desktop experience a plus.

Contract/Perm: Contract
Start Date:
Can start ASAP
Duration: 3 months with possible extension
Location: Near Emmaus, PA (50% can be done remotely)
Compensation: Will discuss


To apply, please email resume, including position title in subject line, to Resumes@proactivestaff.com

Comments are closed.