Database Engineer II
About The Position
At Chewy, it is our mission to become the most trusted and convenient online destination for pet parents and our partners vets and service providers alike. Our success is measured by the happiness of the people and pets we serve, not simply by the amount of pet supplies we deliver. That’s why we continue to think of outside-the-Chewy-box ways to delight, surprise, and thank pet lovers who are dedicated to us! Chewy is seeking a Database Engineer II to join the PREF Analytics team and serve as the technical owner of the team's cloud data platform and infrastructure. This role will be responsible for designing, deploying, and maintaining scalable AWS-based data solutions that support forecasting, replenishment, procurement, and planning initiatives across the PREF org. The ideal candidate will bring strong experience in cloud infrastructure, database engineering, workflow orchestration, and data platform automation. This role will lead the migration of analytical models to AWS while establishing reliable, production-ready engineering frameworks that enable scalable data processing and analytics.
Requirements
- Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field.
- 4+ years of experience in database engineering, cloud infrastructure, or data engineering.
- Strong experience with AWS services (S3, SageMaker, Airflow, Secrets Manager, and networking concepts).
- Experience developing and maintaining Apache Airflow DAGs and production scheduling environments.
- Hands-on experience with dbt, including model development, testing, documentation, and deployment.
- Advanced SQL and Python development skills.
- Experience supporting Snowflake and Oracle databases in production environments.
- Experience building ETL/ELT pipelines and production-grade data architectures.
- Familiarity with Git, CI/CD pipelines, infrastructure automation, and DevOps practices.
- Strong troubleshooting, performance tuning, and production support experience.
Nice To Haves
- Experience supporting supply chain, forecasting, replenishment, procurement, or planning systems.
- Experience with Infrastructure as Code (Terraform or CloudFormation).
- Experience supporting enterprise scheduling and orchestration platforms.
- Knowledge of Agile software development methodologies.
- Experience modernizing legacy applications into cloud-native architectures.
Responsibilities
- Design, deploy, and manage AWS infrastructure supporting analytical applications and data platforms.
- Build, maintain, and optimize scalable data pipelines using Python, SQL, dbt, and Snowflake.
- Develop, schedule, monitor, and troubleshoot Apache Airflow workflows for production data pipelines.
- Administer and support Snowflake, Oracle, AWS, and Gatekeeper environments, ensuring platform reliability and performance.
- Build and maintain dbt models, testing frameworks, and deployment processes to support trusted analytical datasets.
- Configure and manage production job scheduling, orchestration, monitoring, alerting, and recovery processes.
- Establish engineering best practices for data pipelines, workflow scheduling, and infrastructure management.
- Partner with analysts and program managers to productionize analytical models and automate manual business processes.
- Optimize database performance, troubleshoot production issues, and ensure high availability of critical data assets.
- Develop reusable engineering frameworks that improve scalability, maintainability, and operational efficiency.
Benefits
- 401k
- new hire and annual equity grant
- medical/Rx insurance
- vision insurance
- dental insurance
- life insurance
- disability insurance
- hospital indemnity insurance
- critical illness insurance
- accident insurance
- parental leave
- family services benefits
- backup dependent care
- flexible spending accounts
- telemedicine
- pet adoption reimbursement
- employee assistance program
- 10% off pet insurance
- 20% off at Chewy.com
- unlimited PTO (subject to manager approval)
- six paid holidays per year
- paid sick and family leave (in compliance with applicable state and local regulations)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
