Analytics Engineer (Remote)

Cedent; United States; Remote; USD 55,104 - 82,656; Part time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Job summary

A leading analytics firm in the United States is seeking a skilled data engineer to design and implement data models in BigQuery. The ideal candidate should have 3-5 years of experience in analytics or data engineering and be proficient in SQL, particularly with columnar warehouses. Key responsibilities include defining metrics and ensuring data quality through various testing methods. Competitive hourly compensation is offered, along with health benefits.

Qualifications

• 3–5+ years in analytics/data engineering with production SQL modeling.
• Proven track record delivering trusted datasets for BI/apps with SLAs.
• Comfort with Git‑based development and CI/CD.

Responsibilities

• Design staged mart layers in BigQuery using Dataform.
• Define business-ready metrics and deliver consistent calculations.
• Implement tests, SLAs, and schema change policies.

Skills

Expert SQL on columnar warehouses (BigQuery preferred)

Strong documentation habits

Hands-on with Dataform or dbt

Tools

BigQuery

Dataform

Job description

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?