Our Opportunity:
At Chewy, Financial Intelligence is building trusted, scalable, and well-governed data solutions that enable Finance and Accounting teams to make faster, more informed decisions. We are seeking an experienced Data Engineer II to design, develop, and maintain the data models and pipelines that support financial reporting, analytics, planning, and operational decision-making across the enterprise.
In this role, you will focus on transforming complex financial and operational data into reliable, well-structured, and reusable data models using dbt Cloud and Snowflake. You will work closely with Finance, Accounting, Analytics, and other business partners to understand business processes, define requirements, and translate those needs into scalable technical solutions and trusted data products.
The ideal candidate brings strong SQL, dbt, Snowflake, and data modeling expertise, along with the ability to work directly with business users and explain technical concepts in clear business terms. This is an opportunity to strengthen Chewy's Financial Intelligence data foundation, improve the consistency and usability of financial data, and help Finance and Accounting teams access trusted information more efficiently.
What You'll Do:
- Design, develop, and maintain scalable data models in dbt Cloud and Snowflake that support Finance, Accounting, reporting, planning, and analytical use cases.
- Partner directly with Finance, Accounting, and business stakeholders to understand business processes, reporting requirements, data definitions, and analytical needs.
- Translate business requirements into well-designed, reusable, and maintainable dimensional, fact, aggregation, and analytical data models.
- Build and support ETL/ELT processes that transform source data into trusted analytical datasets, with a primary emphasis on transformation and modeling.
- Implement data quality controls and validation to ensure the accuracy, completeness, consistency, and reliability of financial data.
- Investigate and resolve data discrepancies, reporting issues, transformation failures, and differences between source systems and downstream financial reporting.
- Optimize SQL and dbt models for performance, maintainability, scalability, and cost efficiency while documenting model dependencies, transformations, and metric definitions.
- Identify opportunities to simplify data transformations, reduce manual Finance processes, improve self-service access to trusted data, and apply practical automation where it adds value.
What You'll Need:
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Finance, or a related field, or equivalent practical experience.
- 5+ years of experience in data engineering, analytics engineering, business intelligence engineering, or a related data discipline.
- Strong proficiency in SQL, including experience developing complex transformations and analytical data models.
- Strong hands-on experience with dbt, including model development, testing, documentation, dependencies, reusable components, and development best practices.
- Experience working with Snowflake or a similar cloud data warehouse.
- Strong understanding of dimensional data modeling, including fact tables, dimensions, grain, relationships, slowly changing dimensions, and reusable analytical datasets.
- Demonstrated experience working directly with business users and analysts to gather requirements, validate solutions, troubleshoot data issues, and explain technical concepts in business terms.
- Experience supporting Finance, Accounting, FP&A, financial reporting, or other financial data domains preferred, with strong analytical, communication, documentation, and stakeholder partnership skills.
Chewy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, gender, citizenship, marital status, religion, age, disability, gender identity, results of genetic testing, veteran status, as well as any other legally-protected characteristic. 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].
To access Chewy's California CPRA Job Applicant Privacy Policy, please click here.
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Finance, or a related field, or equivalent practical experience.
- 5+ years of experience in data engineering, analytics engineering, business intelligence engineering, or a related data discipline.
- Strong proficiency in SQL, including complex transformations and analytical data models.
- Strong hands-on experience with dbt, including model development, testing, documentation, dependencies, reusable components, and development best practices.
- Experience working with Snowflake or a similar cloud data warehouse.
- Strong understanding of dimensional data modeling, including fact tables, dimensions, grain, relationships, slowly changing dimensions, and reusable analytical datasets.
- Experience working directly with business users and analysts to gather requirements, validate solutions, troubleshoot data issues, and explain technical concepts in business terms.
- Experience supporting Finance, Accounting, FP&A, financial reporting, or other financial data domains.
- Strong analytical, communication, documentation, and stakeholder partnership skills.
What the Team is Saying
Chewy Compensation & Benefits Highlights
How does Chewy ensure its pay and bonus plans are competitive?
Chewy approaches compensation through a total rewards strategy that combines salary, bonuses, equity opportunities, healthcare benefits, employee discounts, and career growth opportunities. The company emphasizes supporting employees across ecommerce, healthcare, pharmacy, customer service, technology, and fulfillment operations while competing for talent in both retail and tech markets.
Competitive compensation and bonus opportunities: Chewy offers market-based compensation packages that may include salary, performance bonuses, commissions, and equity depending on role and level. Built In also notes benefits such as relocation assistance, employee discounts, and bonus opportunities across multiple teams and functions.
- Healthcare and wellness support: Benefits include medical, dental, vision, prescription coverage, HSA/FSA options, life insurance, disability coverage, telemedicine, mental health resources, and wellbeing programs. Chewy also offers wellness-focused resources designed to support employees physically, mentally, and financially.
- Retirement and financial wellbeing: Employees receive 401(k) plans with company matching along with financial wellness resources and broader support programs. Benefits are designed to support both short-term needs and long-term financial planning.
- Pet-focused and family-oriented benefits: Chewy offers pet insurance discounts, employee discounts on Chewy products, parental leave, fertility support, family-focused benefits, and caregiving resources. The company’s benefits package is closely aligned with its pet-focused identity and customer mission.
- Flexibility and workplace support: Corporate employees may have access to hybrid work arrangements, flexible scheduling, commuter benefits, PTO, paid holidays, and wellbeing initiatives. Employees also cite supportive managers and collaborative teams as important parts of the broader employee value proposition.
- Long-term career investment: Compensation is reinforced through career growth opportunities, mentorship, leadership development, cross-functional learning, and exposure to large-scale ecommerce, automation, healthcare, and logistics initiatives. Employees often describe growth opportunities as an important part of the overall company experience.
- External signals: Comparably reports that 70% of employee reviews are positive overall. Employees frequently highlight healthcare benefits, employee discounts, coworkers, and growth opportunities as strengths of the company experience. (Glassdoor; Comparably)
Chewy Insights
What We Do
Who We Are Chewy is where pet parents find everything they need for life with pets, from food to fun to pharmacy. We make pet care easier, more informed, and more joyful through fast, reliable delivery and award-winning 24/7 Customer Care, including access to pet health support when it’s needed. Founded in 2011, Chewy combines the convenience of online shopping with a high-touch, personalized experience built around the real moments of pet parenthood. Our Mission Chewy’s mission is to be the most trusted and convenient destination for pet parents and partners, everywhere. What We Do We support pet parents through the highs, lows, and everyday moments of the pet parenting journey with: • Pet food, treats, and daily essentials • Supplies for dogs, cats, fish, birds, reptiles, equine, and small pets • Pharmacy and veterinary services, including prescriptions and medications • Pet wellness and health products • Autoship for convenient recurring deliveries • Chewy+, our premium membership offering exclusive savings, faster delivery, and personalized pet care benefits • 24/7/365 customer support from knowledgeable, pet-loving experts What Makes Chewy Different Chewy is known for industry-leading service, deep personalization, and our customer-obsessed culture. We combine trust, convenience, and care, and pet parents come to us for: • Exceptional customer care • Human- and pet-centered product and experience design • Fast, dependable fulfillment across a nationwide operations network • A mission-driven culture built on empathy, trust, and passion for pets Our Culture Chewy’s culture is built for people who thrive on ownership, innovation, and impact. We value curiosity, creativity, and continuous improvement across all our teams. We empower Team Members—our Chewtopians—to learn, grow, and unleash their full potential in a collaborative, supportive, mission-driven environment. How We Work Chewy’s Operating Principles guide how we think, innovate, collaborate, and execute. These principles shape our character, decision-making, and approach to delivering results while connecting our people and culture in support of our mission. Where We Work Chewy headquarters: Plantation, FL, and Boston, MA Additional hubs: Bellevue, WA, and Minneapolis, MN
Why Work With Us
Why You Should Work at Chewy Chewy is a unique, fast-growing e-commerce and tech leader where builders, creators, and problem-solvers shape the future of pet care. Our teams drive innovation in a mission-driven culture that creates real impact for pets and the people who love them.
Gallery
Chewy Teams
Chewy Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
