Source description
About the role
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 04/15/2026 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 Visit Careers at CEDENT Subscribe to be notified of new jobs If we don't have an open position that fits you, feel free to subscribe to our Talent Team email! Enter your name, email address and position(s) you're interested in, and whenever we open a new position matching your criteria we'll notify you immediately. * First name: * Last name: * Email address: * Send me openings in these areas: Vendor Managed Systems Direct Clients Preferred Vendors Scout I'm interested in: Management Non-mgt Subscribe Apply Now
More at Cedent
Related open roles
Sr Data Analyst (Remote)
Location not specified
Qlik Sense Consultant (Tallahassee, FL)
Location not specified
Sr Data Analyst :: Richmond, VA (Onsite hybrid) (Richmond, VA)
Richmond, VA (Onsite hybrid)
Power BI Developer (SQL/Adobe/Data Bricks And Adobe Analytics) :: Remote (Boise, ID)
Location not specified
Sr. Data Scientist (Bentonville, AR; Hoboken, NJ; ...)
Location not specified
Sr. Data Scientist (Chicago, IL; Los Angeles, CA)
Location not specified