Analytics Engineer
Core
Design and build a production data layer in BigQuery, transforming raw data into clean, tested datasets and standardizing core business metrics for self-service analytics.
Role type
Analytics Engineer (Data Modeling & Transformation)
Builds
Production data models, transformation layers, and governed datasets in BigQuery
Domain
E-commerce / HVAC & Plumbing supplies
Required skills
SQL, data modeling (layered/dimensional), data transformation frameworks (dbt/Dataform), software engineering fundamentals (Git, CI/CD, testing), cloud data warehouse experience
Preferred skills
Google BigQuery, Google Cloud Dataform, building semantic layers from scratch, e-commerce/HVAC data domain knowledge
Responsibilities
Design and build a layered, version-controlled data model in BigQuery using Dataform; Migrate business logic from ad-hoc queries to governed, reusable models; Define and own canonical definitions of core business metrics; Implement automated data testing and CI; Document models, definitions, and data lineage; Partner with stakeholders to support self-serve reporting; Collaborate with IT on raw data ingestion; Evaluate and shape the go-forward BI layer.
Seniority
Mid-level, hands-on IC