Data Warehouse Engineer II

Posted:
9/24/2024, 3:54:02 AM

Location(s):
Massachusetts, United States ⋅ Boston, Massachusetts, United States

Experience Level(s):
Junior ⋅ Mid Level

Field(s):
Software Engineering

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 [email protected].

 

If you have a question regarding your application, please contact [email protected].

 

To access Chewy's Customer Privacy Policy, please click here. To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.