Data Warehouse Engineer II
Our Opportunity:
We are looking for a Data Warehouse Engineer II at our facility in Boston, MA to develop and maintain the marketing data set at Chewy, including designing infrastructure for the team.
What You’ll Do:
- Work with business users to build data solutions to enable them to make better decisions.
- Develop marketing datasets that help businesses optimize marketing spend in dollars.
- Develop real-time transactional-email feedback data pipelines to populate the data lake (Snowflake).
- Develop a replication framework to move data between two data-warehouses.
- Develop ETLs using Clover-ETL to load the data in Snowflake Datawarehouse for reporting and analytics.
- Design, develop, and implement large-scale analytics solutions that process and serve large volumes of data.
- Building cloud-native data engineering solutions to enable Businesses with accurate and real-time data.
- Develop custom data replication tools from source databases to the Reporting/Analytical data-warehouse.
What You’ll Need:
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or related field, and 3 years of experience required.
- Will also accept Master’s degree and 1 year of experience.
- Experience must include 1 year in the following: AWS-RDS, MySQL, DynamoDB, Hive;
- Eclipse, Maven, IntelliJ Idea, Boto3, Spark;
- AWS (Glue, S3, EC2, EMR, Step-function, DynamoDB, Lambda, API gateway), Jenkins;
- Hadoop Map Reduce, Spark, EMR, Gooddata, and Clover ETL.
- Experience must also include: Java, Ruby, Python, SQL.
- The position is eligible for the Employee Referral Program.
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, 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.
To access Chewy's Customer Privacy Policy, please click here. To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.