Learn more about this opportunity.


Principal BI Developer (SASS/ Power BI)

Function: Technology
Location: Staples Corporate Center, Framingham, MA US
Date posted: 2/22/2018 4:59:07 PM
Type: Full-time
Permanent / Contract: Regular
Job number: 1041257

The BI team is seeking top notch talent in the Microsoft SSIS, SQL Server, dimensional modeling, SSAS, SSRS, and Power BI technologies to create data marts and OLAP meta-data layers that will enable self-service for our business partners. If you have a passion for data, are interested in using your expertise and innovative skills to build something brand new, in an agile environment where you are empowered to make decisions, then we want to talk to you! A great opportunity awaits you!


Essential Responsibilities

  • Designs, documents, administers and maintains SSAS cubes (both DAX and MDX) from dimensional models Implementation of data governance through the use of SSAS meta-data layers in cubes (both DAX and MDX)
  • Extract complex data from multiple sources into usable and meaningful reports and analyses
  • Mentor and support other Developers and business partners
  • Create and maintain detailed documentation for development team
  • Support user community on data analytics
  • Perform training and knowledge transfer of technology
  • Provides ongoing performance monitoring and tuning, and automation of production activities related the BI environment
  • Works in conjunction with business analysts and other users acting as a liaison between technical and business departments in developing dashboards and other BI related solutions.
  • Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their related interfaces
  • Perform Unit testing and resolve defects



  • At least 5 years of SSAS design, development, maintenance and performance tuning on Microsoft SQL Server 2012 and above (2016 preferable)
  • At least 2 years of Power BI experience
  • At least 5 years of SSRS 2012 and above (2016 preferable)
  • Expert T-SQL Programming skills
  • Experience with UX Design / Data Visualization strongly preferred
  • Experience with dimensional data modeling
  • Experience or knowledge of SSIS and ETL processing
  • Excellent verbal and written communication skills
  • Experience with Microsoft Azure DB and Azure DW a big plus
  • Ability to manage multiple efforts concurrently
  • Strong problem-solving skills
  • Strong knowledge of emerging technologies and tools
  • Strong organizational and time management skills
  • Effective collaboration of tasks across the business and technical teams
  • Able to work quickly and under tight delivery deadlines with focus on details Interface with key customers from all functional areas - Analytic skills are needed
  • Proven and recent experience of implementing solutions from requirements gathering and process design to functional production deployment
  • Demonstrated ability to produce high quality deliverables
  • Possesses strong business acumen, with ability to assist in development of business requirements definitions
  • Ability to establish and maintain positive and effective work relationships with management, coworkers, and business users
  • Bachelor’s Degree in Computer Science (or related field), Master’s degree preferred

Link for schema

There's more to explore