Data Engineer II - Financial Intelligence (SQL, dbt)

Chewy; Plantation (FL); On-site; USD 100,000 - 140,000; Full time

Job summary

Chewy’s Financial Intelligence team is seeking an experienced Data Engineer II to design, build, and maintain data models and pipelines that support financial reporting, analytics, planning, and operational decision-making across the enterprise.

You will work with Finance, Accounting, Analytics, and business partners to transform complex data into trusted, scalable data products using dbt Cloud and Snowflake, focusing on performance, quality, and self-service access.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Finance, or related field, or equivalent practical experience.

Responsibilities

• 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.

Skills

SQL

dbt

Snowflake

Data modeling

Stakeholder communication

ETL/ELT

Education

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, Finance, or related field

Tools

dbt Cloud

Job description

Chewy’s Financial Intelligence team is seeking an experienced Data Engineer II to design, build, and maintain data models and pipelines that support financial reporting, analytics, planning, and operational decision-making across the enterprise.

You will work with Finance, Accounting, Analytics, and business partners to transform complex data into trusted, scalable data products using dbt Cloud and Snowflake, focusing on performance, quality, and self-service access.