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? #J-18808-Ljbffr Cedent