Remote Analytics Engineer - BigQuery & Dataform

SupplyHouse.com; United States; Remote; USD 72,000 - 91,000; Full time

Benefits offered by this job

Medical, dental, vision, and voluntary

401(k) with company match

Paid vacation, sick time, holidays

Company-paid life insurance & long‑int

Discounts on auto/home/pet insurance

FSA

EAP

Equipment + $250 WFH stipend

Professional development budget

Grubhub credit

Rewards program

Job summary

SupplyHouse.com is seeking an Analytics Engineer to build and own the production data layer in BigQuery. You will transform raw data into clean, documented datasets and standardize core metrics while enabling self-serve analytics across the finance team.

You’ll work with engineers, analysts, and stakeholders, with a remote role open to multiple states and occasional travel to Melville, NY for meetings. This is a full-time exempt position with flexible on-site options beyond travel.

Qualifications

• Bachelor's degree in a quantitative, technical or related field.
• 2+ years of data modeling experience.
• Strong SQL skills with production-ready data models in a cloud DW.
• Hands-on with a data transformation framework such as dbt or Dataform.
• Software engineering fundamentals: version control (Git), testing, CI.

Responsibilities

• Design and build a layered, version-controlled data model in BigQuery using a modern transformation framework (Dataform).
• Migrate business logic out of ad hoc queries into governed, reusable, tested models.
• Define and own canonical definitions of core metrics.
• Implement automated data testing and CI to enforce data quality before changes ship.
• Document models, definitions, and data lineage for knowledge retention.
• Partner with analysts and business stakeholders to enable reliable self-serve reporting.
• Partner with IT to ensure accurate and timely raw data ingestion.
• Evaluate and shape the go-forward BI layer as Power BI is under consideration.

Skills

Data Modeling

SQL

Git

CI

Data Transformation Frameworks

Education

Bachelor's degree in a quantitative, technical, or related field

Tools

BigQuery

dbt

Dataform

Power BI

Job description

SupplyHouse.com is seeking an Analytics Engineer to build and own the production data layer in BigQuery. You will transform raw data into clean, documented datasets and standardize core metrics while enabling self-serve analytics across the finance team.

You’ll work with engineers, analysts, and stakeholders, with a remote role open to multiple states and occasional travel to Melville, NY for meetings. This is a full-time exempt position with flexible on-site options beyond travel.