Analytics Engineer II
Core
Build and maintain foundational data models, SQL transformations, and automated workflows to support reporting, data science, and self-serve analytics for a pet food company.
Role type
mid-level analytics engineer (data platform)
Builds
production-grade data models, tested transformation suites, and automated data pipelines
Domain
pet food / consumer goods / data engineering
Required skills
dbt, SQL, Python, Git, data modeling, query optimization
Preferred skills
ETL/ELT pipelines, AWS, Looker/BI tools, generative AI
Technologies
Snowflake, dbt, Looker, Python, AWS, GitHub
Responsibilities
Build and maintain SQL transformations and tests in dbt; Develop Python code to automate data workflows; Collaborate with engineering teams to ensure source data quality; Work with stakeholders to deliver clean datasets via Looker and AI tools; Advise on data modeling best practices; Optimize data quality and performance.
Seniority
Mid-level, hands-on IC