Job Description:
  • Modeling & ELT: Design staged → mart layers in BigQuery using Dataform (naming, conventions, macros).
  • Metrics & semantics: Define business-ready metrics (grain, SCD strategy, time zones, null handling) and deliver consistent calculations to downstream apps.
  • Quality & contracts: Implement tests (uniqueness, referential integrity, freshness), SLAs, and schema change policies; add lineage and documentation.
  • Performance & cost: Tune queries, partitions/clusters, and storage formats; track spend and p95/p99 latencies.
  • Collaboration: Partner with Data Eng, MLOps, and Internal Tools to align APIs, schemas, and release schedules; gather stakeholder feedback and iterate.
  • Governance: Apply RBAC, PII handling, and auditability; participate in reviews and incident postmortems.

Minimum qualifications:

  • 3–5+ years in analytics/data engineering with production SQL modeling.
  • Expert SQL on columnar warehouses (BigQuery preferred): partitioning, clustering, UDFs.
  • Hands-on with Dataform or dbt (tests, docs, macros, environments).
  • Strong documentation habits; comfort with Git-based development and CI/CD.
  • Proven track record delivering trusted datasets for BI/apps with SLAs.
Compensation
Hourly Rate Range - $40-$60/ hr

Benefits Offered:
Health, Dental, Vision Insurance

Deadline: Applications accepted
until 10/15/2025 at 11:59 PM CST

We are an Equal Pay Employer. All employment decisions, including compensation, benefits, hiring, training, and promotions, are made based on merit, qualifications, and business needs. We do not discriminate on the basis of gender, race, ethnicity, age, disability, sexual orientation, or any other protected characteristic. We are committed to ensuring equal pay for equal work and regularly review our compensation practices to promote fairness, equity, and transparency across our organization.
 

Department: Preferred Vendors
This is a contract position

Subscribe to be notified of new jobs

Personal Information









Attachments

Other Information