Analytics Engineer; Remote

Responsibilities

• Modeling & ELT: Design staged → mart layers in Big Query 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 post‑mortems.

• 3–5+ years in analytics/data engineering with production SQL modeling.
• Expert SQL on columnar warehouses (Big Query 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.

Hourly Rate Range - $40-$60/ hr

Health, Dental, Vision Insurance

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

Department:
Preferred Vendors

This is a contract position

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.

• First name
• Last name
• Email
• Address
• City
• State
• Zip code
• Phone number

• Attach your Resume
• Attach Dropbox Paste
• Attach a Cover letter
• Attach Dropbox

• How did you hear about this position?
• Your Legal Work Authorization in the US?
• Are you currently employed?
• Will you be able to join us on our W‑2?
• What is your desired salary / hourly rate?
• If on a Visa, will you be able to transfer your Work Visa to us?
• What is your motivation for Change/New Job Opportunity?
• If Currently working, what is your Notice period?
• What is your current location?
• Are you ready to relocate?
• Can you provide proof of legal right to work in the United States?
• if Hired when will you be able to start?