Job Location: Boston, MA
Our Opportunity:
Chewy is looking for a Data Warehouse Engineer II to join our IT Data Engineering Team based in Boston, MA or Dania Beach, FL. The ideal candidate will be a well rounded technologist with a passion for building innovative business solutions with big data 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 Data Warehouse Engineer should be keeping up with the latest developments and should be able to connect technical capability with business need.
What you’ll do:
- Design analytic solutions for business users that provide the data needed to operate the business
- Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for analytics platform
- Implement data ingestion routines both real time and batch using best practices in data modeling, ETL/ELT processes
- Participate in technical decisions and collaborate with talented peers
- Review code, implementations and give meaningful feedback that helps others build better solutions
- Write documentation on design, architecture and solutions
What you’ll need:
- Experience in data warehouse design and data integration methodologies
- SQL expertise and the ability to work with many different database types. Vertica,Snowflake, Postgres, SQL Server, and others as required
- 5+ years of experience with detailed knowledge of data warehouse technical architectures, infrastructure components, ETL/ ELT and reporting/analytic tools
- Experience building on AWS using S3, EC2, ECS, Kenisis, DynamoDB, Lambda, etc
- 5+ years of experience integrating data between operational databases using data integration tools like Informatica, CloverDX, Datastage, Talend, Pentaho Data Integrator, or SSIS.
- 5+ years of experience with data modeling in large Data warehousing, data lake environment
- 5+ years of hands-on experience designing and developing scalable, high performing and fault-tolerant applications for large enterprises
- 5+ years of experience writing software in any of the following programming language (Python or Java)
- Expert level knowledge of data integration and familiarity with common data integration challenges like converting data types, handling errors, and translating between different technology stacks
- Able to work in a fast-paced environment and be comfortable being accountable for work products
- Hand on experience delivering high performance distributed systems in public cloud environments
- Experience performing analytics to solve complex business problems
- BS in Computer Science, Mathematics, Engineering, or Information Technology
- Position may require travel
Bonus:
- Experience with cloud based data warehouse platforms (e.g. Snowflake, etc.)
- Working experience with Amazon Web Services
- Experience with business intelligence platforms (e.g. Tableau, etc.)
- Background in e-commerce
- Agile experience is a plus
- Java experience is a plus
- Experience with statistical methods and data science
If you have a disability under the Americans with Disabilities Act or similar law, and you need an accommodation during the application process or to perform these job requirements, or if you need a religious accommodation, please contact CAAR@chewy.com.
If you have a question regarding your application, please contact HR@chewy.com.
Chewy is committed to equal opportunity. We value and embrace diversity and inclusion of all Team Members.
To access Chewy’s Privacy Policy, which contains information regarding information collected from job applicants and how we use it
Submit CV To All Data Science Job Consultants Across United States For Free