Chewy

Data Engineer II, Financial Intelligence

Chewy$95K — $115K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in relevant field or equivalent experience
  • 5+ years in data engineering, analytics, or business intelligence
  • Strong SQL proficiency for complex data transformations
  • Hands-on experience with dbt for model development and testing
  • Experience with Snowflake or similar cloud data warehouses
  • Understanding of dimensional data modeling principles
  • Experience collaborating with business users and analysts

Responsibilities

  • Design, develop, and maintain scalable data models in dbt Cloud and Snowflake
  • Partner with Finance and Accounting to gather reporting requirements
  • Translate business needs into reusable dimensional and analytical data models
  • Build and support ETL/ELT processes for trusted analytical datasets
  • Implement data quality controls to ensure financial data reliability
  • Investigate and resolve discrepancies and reporting issues
  • Optimize SQL and dbt models for performance and cost efficiency
  • Identify opportunities to simplify processes and enhance data access

Benefits

  • Flexible working environment
  • Opportunities for professional development
  • Collaborative team culture
  • Access to cutting-edge data tools and technologies
Full Job Description
Job Description:

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.


About Chewy

At Chewy, we view pets (and pet parents) as family and are obsessed with meeting their needs and exceeding customer expectations through every interaction. Customers love shopping our wide selection of products including more than 65,000 items (including our Private brands and Healthcare products), which we offer at competitive prices and fast 1-2 day shipping. Chewy’s commitment to customer service is the core of our brand, and our customers love us for it. We “WOW” pet parents through 24/7 assistance, advice and encouragement every day of the year. We make pet parenting easy with our convenient Autoship subscription program—which allows our customers to schedule their orders, so they never run out of their pet food, supplies and medication they need. Chewy is an experience company built on the back of product and technology. Innovation drives our operations and our team is constantly striving to find new and better ways to improve. From an easy-to-navigate website and highly-rated mobile apps, to detailed order tracking and personalized “Pet Profile” features, we are transforming the way pet parents shop.

Chewy Careers

Join the vibrant team at Chewy, where we offer exceptional job opportunities to advance your career in the dynamic world of e-commerce. As a leading company in the pet industry, Chewy is dedicated to making pet care easier and more enjoyable for pet parents everywhere. Work You’ll Do At Chewy, we are constantly on the lookout for passionate, driven professionals to join our diverse team. Whether you're seeking a position in IT, customer service, marketing, or logistics, Chewy provides a platform for professional growth and innovation in every career path. Our commitment to leadership and diversity training ensures that every team member is equipped with the skills to lead and innovate. By joining Chewy, you will work alongside a team of dedicated professionals who are always pushing the boundaries of what's possible in e-commerce and customer service. Internship and Employment Opportunities Chewy offers a variety of internship and employment opportunities that cater to a wide range of skills and interests. Our internships provide invaluable hands-on experience, helping you to enhance your resume and prepare for a full-time position within our company. Chewy is not just about hiring employees; it's about nurturing future leaders. Benefits and Culture At Chewy, we believe that the well-being of our team is paramount. We offer a comprehensive benefits package that supports the health, financial security, and work-life balance of our employees. Our culture is centered on open communication, respect, and a shared passion for our mission. We celebrate diversity and are committed to creating an inclusive environment for all team members. Innovation and Growth Chewy is at the forefront of innovation in the pet industry. We are constantly exploring new technologies and strategies to enhance our services and expand our market reach. This focus on innovation drives our company's growth and offers our team members numerous opportunities to get involved in exciting projects and advance their careers. Networking and Professional Development We encourage our employees to engage in networking and professional development activities that can enhance their career prospects. Chewy supports various initiatives, including workshops, seminars, and training sessions, to help our team members grow their professional network and develop new skills. Join Our Team Explore the job opportunities at Chewy by searching open positions that match your skills and interests. We are looking for curious, creative, and solution-driven team players who are ready to take their career to the next level. Stay Connected Keep up to date with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who work here at Chewy. Job Alert Emails Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await you at Chewy. Chewy is more than a company; it's a community where you can grow your career and make a difference. Join us in our mission to be the most trusted and convenient online destination for pet parents (and partners) everywhere.
Learn more about Chewy
Size
21,300 employees
Market Cap
$15.9 billion
Industry
Net Income
-$174.4 million
Founded
2011
5 Year Trend
+136.6%
Revenue
$6.4 billion
NASDAQ

Similar Jobs

More Jobs at Chewy

More Finance & Insurance Jobs

Find similar Data Engineer II, Financial Intelligence jobs: