We're on a quest to help people connect through pets.
Boston, MA

Staff Data Warehouse Engineer

| Greater Boston Area
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Our Opportunity:

At Chewy, data drives all of our decision making, so Chewy is looking for a Staff Data Warehouse Engineer to join our IT Enterprise Data Services Team based in Boston, MA. The ideal candidate will be a well rounded technologist with a passion for building innovative business solutions with big data and Java technologies. Experience delivering big data solutions – from system setup to development to business solution delivery – is critical. Programming experience is also paramount. Big data technologies are constantly evolving. The Enterprise Data Services should be keeping up with the latest developments and should be able to connect technical capability with business need.

What you'll do:

  • Define and shape the overall data strategies/Roadmap and their impact on applications and system architecture.
  • Hiring, training, mentoring and growing new talent will be a major part of your job as Chewy is growing all teams at a record pace
  • Drive innovation through rapid prototyping and iterative development
  • Conduct design & code reviews and raise the bar on engineering rigor and standards
  • Set standards and guidelines for evolving development practices. Drive the focus on scalability, resiliency, high availability and performance of application
  • Evangelize tools, stack and the use of data to drive decision making across the company and at different levels
  • Partner with engineering teams to optimize data architecture and technical implementations
  • Work in an agile development environment, collaborating with application development, architecture teams, engineering and product managers
  • Effectively communicate with and influence key stakeholder across the enterprise, at all levels of the organization
  • Contribute to intellectual property through patents

What you'll need:

  • 10+ years of experience in data warehousing/Big data design, data integration, data engineering, architecture, analytics engineering or related field
  • 10+ years of experience leading and developing large scale projects and initiatives
  • Strong working knowledge of modern data stack:
    • Cloud Data Warehouse such as Snowflake, Redshift or BigQuery
    • SQL expertise and the ability to work with many different database types. Vertica, Snowflake, Postgres, SQL Server, and others as required
    • ETL/ELT
    • Data replication and data streaming
  • Fluent in SQL and strong knowledge/proven expertise with at least one modern programming language such as Python, Java or object oriented programming
  • Ability to collaborate effectively with a diverse, talented team
  • Ability to balance your time between being a hands-on engineer writing code, creating Framework structure for team or debugging tricky issues and define and execute the company’s data strategy
  • Knowledge of professional software and engineering practices for the full software development life cycle including coding standards, code reviews, source control management, build processes, testing, and operations
  • Experience with designing, building and deploying scalable, high performing, fault-tolerant, highly available systems for large enterprises
  • Strong background with modern tools and environments (e.g., JSON 3.0 API spec, web services, version control systems, bug/issue tracking tools)
  • Strong expert experience in cloud native AWS technology stack (EMR, Kinesis, Lambda, API Gateways, etc..) and service-oriented architecture
  • Experience with cloud & orchestration technologies (AWS Services, Terraform, Ansible, etc.)
  • Experience in communicating software product features, technical designs & product strategy with users, other technical teams, and senior management
  • Excellent interpersonal and communication skills, strong analytical skills, and ability to deal with ambiguity in a rapidly evolving business environment
  • Have deep domain knowledge in the area of retail e-commerce
  • Masters in Computer Science, Mathematics, Engineering, Information Technology, or equivalent experience
  • Position may require travel


    • Experience building platform (like SageMaker) that can host ML applications, Data Science, etc…
    • Experience in realtime or near-realtime analytics
    • Experience with Scrum or other agile methodologies
    • Experience taking a project from inception through launch. Includes influencing the vision, communicating with leadership, stakeholders, and technical teams to disambiguate requirements, describe software product features, and produce technical design documents
    • Deep experience in one or more public cloud offerings (AWS, Azure, GCP)
    • Experience with business intelligence platforms (e.g. Tableau, etc.)
Chewy is committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members.
If you have a disability under the Americans with Disabilities Act or similar law, or you require a religious accommodation, and you wish to discuss potential accommodations related to applying for employment at Chewy, please contact [email protected] 
To access Chewy’s Privacy Policy, which contains information regarding information collected from job applicants and how we use it, please click here:
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

Located in the Fort Point neighborhood, home to many of Boston's hip and upcoming restaurants along with emerging technology companies.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • KotlinLanguages
    • PHPLanguages
    • RLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • jQueryLibraries
    • VueJSLibraries
    • AngularJSFrameworks
    • DjangoFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SpringFrameworks
    • GRPCFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • OracleDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • VerticaDatabases
    • AerospikeDatabases
    • Google AnalyticsAnalytics
    • BalsamiqDesign
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • UXPinDesign
    • ConfluenceManagement
    • JIRAManagement
    • dotCMSCMS

What are Chewy Perks + Benefits

Chewy Benefits Overview

We offer competitive salaries and 401k, unlimited time off, comprehensive medical, dental, and vision benefits, in addition to wellness programs, online communities, and resources for improved physical and mental health... enabling you to be your best self - in and outside of work. With mentorship programs, employee resource groups, cross-functional job trainings, events, and customized development tracks for advancement, we're proud to help develop and promote our team members from within.

True to our business, we're pet-friendly and have fun pet-related perks like Paw-ternity leave for new pup parents and Chewy employee discounts. We offer countless volunteer opportunities, recreational club teams, company outings, happy hours, and team events to enable you to bond with fellow Chewtopians and have some fun!

Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity manifesto
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
We offer a commuter transit, parking, and dependent care FSA.
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K) Matching
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Remote Work Program
We're currently 100% remote due to caution and care for the health & well-being of our team. Post-pandemic, we plan to operate in a combination of onsite and remote, with logistics still being defined
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Holidays
Paid Sick Days
Perks & Discounts
Beer on Tap
Casual Dress
Commuter Benefits
Company Outings
Game Room
Stocked Kitchen
Some Meals Provided
Happy Hours
Pet Friendly
Recreational Clubs
Chewy sponsors office sports leagues year-round.
Relocation Assistance
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross-functional lunch and learns.
Cross functional training encouraged
Promote from within
Mentorship program
Time allotted for learning
Online course subscriptions available
Customized development tracks

An Insider's view of Chewy

What’s the vibe like in the office?

Fast paced! We work in "doggy-years" here. It's a place where talent and hard work is valued and where team members can think big and can bring their dreams to life.


Senior Technical Recruiter

What kinds of technical challenges do you and your team face?

At Chewy, one of our operating principles is Accelerate Time. We release new features weekly, fail fast, and iterate often to bring incremental progress quickly to our Pet Parents. Our success is driven by a customer first mentality, a culture of collaboration, and empowering individuals and teams.


Associate Director, Product Management

How does the company support your career growth?

Chewy gives a significant amount of freedom and autonomy to do your best work. I am able to pursue the most important objectives, and work that I really enjoy. It’s an amazing feeling to see your hard work pay off immediately and have a positive impact on the team—and something that makes life at Chewy really unique!


Human Resources Business Partner

How do you make yourself accessible to the rest of the team?

Aside from the standard 1x1s and team meetings: 24/7 via text, email, chat, voice and during business hours by walking around the office engaging in conversation, listening to current challenges and proposed solutions.


VP, Software Engineering

What projects are you most excited about?

Collaborating with so many different teams on a daily basis and seeing how we all come together to help pet parents find the products that they need for their pets.


Senior Integrated Marketing Manager

More Jobs at Chewy