Analytics Engineer (Remote)

Responsibilities

• 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 post‑mortems.

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

Department: Preferred Vendors

This is a contract position

Equal Employment Opportunity Statement

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.

Personal Information

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

Attachments

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

Other Information

• 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?