Senior Data Engineer, Supply Chain Systems
Our Opportunity:
Chewy is looking for a Senior Data Engineer - Supply Chain Systems to join our IT Team based in Boston, MA. 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 Senior Data Engineer should be keeping up with the latest developments and should be able to connect technical capability with business need.
What you'll do:
- Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business’s operational and analytics databases. The Data Engineer works with the business’s software engineers, data analytics teams, data scientists, and data warehouse engineers to understand and aid in the implementation of data requirements, analyze performance, and troubleshoot any existent issues.
- Responsible for designing and implementing data transformation and migrations across different databases (such as MS SQL Server and Postgres).
- Perform ad-hoc analyses of data and writes SQL scripts, stored procedures, functions, and views.
- Troubleshoot data issues within the business and across the business and present solutions to these issues.
- Design data models, staging tables to enable advanced analytics solutions for Supply Chains functions such as: forecasting, inventory management & optimization, key performance indicators (KPIs), simulations and what-if analysis.
- Work with Supply Chain business owners and users to recommend data and process enhancements to provide the data and analytics needed to improve the business operations.
- Support data warehousing/BI department in the implementation of the data warehouse for the new/future big data platforms.
What you'll need:
- BS in Computer Science, Mathematics, Engineering, or Information Technology
- 7+ years of experience working with database and data management tools and systems
- 7+ years of experience working with T-SQL, clover/SSIS/Informatica, and data warehouse concepts
- System management expertise with monitoring, disaster recovery, backup, automated testing, automated schema migration, and continuous deployment.
- Experience performing analytics to solve complex business problems
Bonus:
- Experience in eCommerce or large volume transactional systems
- Experience with Tableau, Qlik View, Power BI, Domo or other business intelligence tools
- Experience with statistical methods and data science
- Experience with supply chain business processes