Staples Principal Data Engineer in Framingham, Massachusetts


About the Job:

There’s never been a more exciting time to be on the Enterprise Data & Analytics team at Staples! Staples is on an exciting journey to modernize the data landscape, consolidate data assets, and build a brand new Data Warehouse. The DW will support critical business process transformation, be in the cloud, integrate with Hadoop, and implement and enforce new data governance standards. The team is seeking top notch talent in the Microsoft Azure DW, SSIS, SQL Server, Big Data, and dimensional modeling areas. If you are interested in using your expertise and innovative skills to build something brand new, enjoy making architectural decisions, are a resourceful technologist who likes to wear many hats, consider yourself an ‘A’ player, have a passion for data, and like to mentor others, then we want to talk to you! A fantastic opportunity awaits you!

Essential Responsibilities:

  • Designs,documents, administers and maintains curated data sets from dimensional models

  • Extract complex data from multiple sources into usableand meaningful reports and analyses

  • Design, develop and test high-quality data blending(ETL) processes, programs and scripts

  • Troubleshoot data integration issues and bugs, analyzereasons for failure, implement optimal solutions, and revise proceduresand documentation as needed

  • Mentor and support other Developers and businesspartners

  • Create and maintain detailed documentation fordevelopment team

  • Support user community on data analytics

  • Perform training and knowledgetransfer of technology

  • Providesongoing performance monitoring and tuning, and automation of productionactivities related the BI environment

  • Worksin conjunction with business analysts and other users acting as a liaisonbetween technical and business departments in developing dashboards and otherBI related solutions.



  • At least 5-8 years of dimensional datamodeling experience

  • At least 4 years of ETL design,development, and performance tuning on Microsoft SSIS 2012 and above (2016preferable)

  • At least 2 years of Microsoft Azureexperience

  • Experience on Big Data toolsincluding Sqoop, Spark, and Hive SQL

  • Expert T-SQL Programming skills

  • Skilled on Microsoft SQL Server 2012and above (2016 preferable)

  • Excellent verbal and writtencommunication skills

  • Ability to manage multiple effortsconcurrently

  • Strong problem-solving skills

  • Strong knowledge of emergingtechnologies and tools

  • Strong organizational and timemanagement skills

  • Effective collaboration of tasksacross the business and technical teams

  • Able to work quickly and under tightdelivery deadlines with focus on details

  • Interface with key customers fromall functional areas - Analytic skills are needed

  • Proven and recent experience ofimplementing solutions from requirements gathering and process design tofunctional production deployment

  • Demonstrated ability to produce highquality deliverables

  • Possessesstrong business acumen, with ability to assist in development of businessrequirements definitions

  • Ability to establish and maintainpositive and effective work relationships with management, coworkers, andbusiness users

  • Bachelor’sDegree in Computer Science (or related field), Master’s degree preferred

Staples is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other basis protected by federal, state, or local law.