Wayfair: Software Engineer 3
4 Copley Place - Floor 7
Boston, MA 02116


Employer: Wayfair LLC

Title: Software Engineer 3

Location: 100 Huntington Avenue, 4 Copley Place, Boston, MA 02116 /

500 Boylston Street, Suite 202, Boston, MA 02116

Duties: Develop the database infrastructure that supports large-scale internet e-commerce platform and big data analytics environment within new Vertica cluster. Implement trickle/near real time analytics architecture. Integrate Vertica with Hadoop environment in order to support the ever-growing analytical needs of the business. Horizontally scale database infrastructure to support dynamic company growth and provide increased redundancy. Develop a disaster recovery and infrastructure level business continuity plan. Assist in opening data center in Europe. Serve as technical expert in Vertica technologies. Provide day-to-day support of Vertica infrastructure including: cluster monitoring and troubleshooting; providing SQL or Workload Manager query tuning and optimizations; analytical and big data application design; cluster expansion and support; and installing Vertica version updates and patches. Work with BI teams to develop business initiatives and algorithms as they relate to Vertica. Provide second level on-call support on rotation standby basis for 1 week per month from 6 PM 9 AM.

Requirements: Masters degree in Computer Science, Engineering, Information Systems, or a related field plus two (2) years of experience in automation and database maintenance using Vertica and SQL. Experience must include:

Two (2) years in each of the following (experience may be gained concurrently):

  • Building, installing, upgrading, and backing up Vertica clusters
  • Working with large-scale analytics environments including HDFS and MapReduce
  • Working with analytic databases including Vertica
  • Scripting with Shell and Python
  • Integrating Vertica with technologies including Hadoop, Kafka, SQL Server, or Spark

One (1) year in each of the following (experience may be gained concurrently):

  • Creating monitoring alerts using Airflow and Datadog
  • Interfacing with business product leaders and engineers to gather requirements and translate requirements into database design
  • Designing, building, implementing, and patching upgrades for Tableau and MemSQL Clusters
  • Monitoring SQL servers using Solarwinds, DPA, and SSAS analysis services utilizing SQLSentry
  • Hive, Git/SVN, Zabbix, Microsoft SQL, MySQL
  • Automated system deployment experience using Puppet or Chef

Will accept a Bachelors degree plus five (5) years of described experience.

Experience may be gained, before, during, or after issuance of advanced degree.

Multiple positions. Please submit resumes to Wayfair LLC, 100 Huntington Avenue, 4 Copley Place, Boston, MA 02116 or via https://www.wayfair.com/careers, Job Code: 29141.

About Us

Wayfair is one of the worlds largest online destinations for the home. Whether you work in our global headquarters in Boston or Berlin, or in our warehouses or offices throughout the world, were reinventing the way people shop for their homes. Through our commitment to industry-leading technology and creative problem-solving, we are confident that Wayfair will be home to the most rewarding work of your career. If youre looking for rapid growth, constant learning, and dynamic challenges, then youll find that amazing career opportunities are knocking. No matter who you are, Wayfair is a place you can call home. Were a community of innovators, risk-takers, and trailblazers who celebrate our differences, and know that our unique perspectives make us stronger, smarter, and well-positioned for success. We value and rely on the collective voices of our employees, customers, community, and suppliers to help guide us as we build a better Wayfair and world for all. Every voice, every perspective matters. Thats why were proud to be an equal opportunity employer. We do not discriminate on the basis of race, color, ethnicity, ancestry, religion, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, veteran status, or genetic information.