Remote Data Engineer II: SQL Pipelines & Analytics

Ocient

United States

Remote

USD 110,000 - 185,000

Full time

46 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Ocient is seeking a Data Engineer II who independently contributes to data engineering workstreams at Ocient, supporting customer workload onboarding, schema design, query conversion, data loading, and pre-pilot workload testing with growing technical depth and autonomy.

This role works closely with Solutions Architects and Senior Data Engineers to deliver high-quality pre-pilot engineering outputs and developing customer solutions, applying growing expertise in Ocient’s SQL data platform,

Qualifications

  • 2+ years of experience in data engineering, SQL, and data pipelines.
  • Experience in data warehousing or analytics environments.
  • Strong SQL proficiency and ability to optimize queries.
  • Familiarity with metadata analysis and workload performance testing.

Responsibilities

  • Work with Solutions Architects to understand customer workloads, capture requirements through questionnaires and workshops, and obtain sample queries and data where possible.
  • Convert customer queries to Ocient syntax using internal tools and perform metadata analysis to understand field types, relationships, multi-dimensional elements, and changing schemas.
  • Analyze queries in bulk to understand indexing schemes and refine schema; define initial schema designs for pre-pilot workload preparation.
  • Load data, create workload test suites, and deploy end-to-end sample workloads to run initial pre-pilot tests.
  • Build test cases and validation assets for Delivery and Development teams, and create artifacts in GitHub and other repositories.
  • Assist with system sizing, delivery timeline development, and GDPR and data rolloff procedure definition.
  • Report performance results and status to management and contribute to cross-functional workload documentation.

Skills

SQL proficiency
Data pipelines
Schema design
Data loading
Workload testing
Documentation
Collaboration

Education

Bachelor's degree in Computer Science

Tools

GitHub
AWS Redshift
Google BigQuery
Snowflake

Job description

Ocient is seeking a Data Engineer II who independently contributes to data engineering workstreams at Ocient, supporting customer workload onboarding, schema design, query conversion, data loading, and pre-pilot workload testing with growing technical depth and autonomy.

This role works closely with Solutions Architects and Senior Data Engineers to deliver high-quality pre-pilot engineering outputs and developing customer solutions, applying growing expertise in Ocient’s SQL data platform,

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer II
Data Engineer II

Ocient • United States

Remote
USD 110,000 - 185,000
Remote Data Engineer II: Pipelines & Analytics
Remote Data Engineer II: Pipelines & Analytics

Versant Media • Orlando (FL)

Remote
USD 100,000 - 150,000
Remote Data Engineer II — Build Reliable, Scalable Pipelines
Remote Data Engineer II — Build Reliable, Scalable Pipelines

Horace Mann - Agent Opportunities • United States

Remote
USD 77,000 - 106,000
Remote Analytics Engineer III - AI-Ready Data Pipelines
Remote Analytics Engineer III - AI-Ready Data Pipelines

Tracker-RMS • United States

Remote
USD 120,000 - 170,000
Medical plans
401(k) starting on day one
Voluntary benefits: life and/or other
+1
Data Engineer II: Cloud Pipelines & Data Quality
Data Engineer II: Cloud Pipelines & Data Quality

OSC EdgeTech • United States

Remote
USD 95,000 - 150,000
Paid holidays
401k with employer match
Health insurance
Remote Data Engineer II: Build Pipelines & Alerts
Remote Data Engineer II: Build Pipelines & Alerts

Crystal Equation • Menlo Park (CA)

Hybrid
USD 98,000 - 105,000
Full benefits
401K
Remote Data Engineer II: Scalable Pipelines & Warehousing
Remote Data Engineer II: Scalable Pipelines & Warehousing

First Citizens • Raleigh (NC)

Remote
USD 95,000 - 140,000
Remote Data Engineer II: Cloud Data Pipelines & Analytics
Remote Data Engineer II: Cloud Data Pipelines & Analytics

Mount Sinai • New York (NY)

Hybrid
USD 90,000 - 135,000
Remote Data Engineer II — Healthcare Analytics
Remote Data Engineer II — Healthcare Analytics

Ensemble • United States

Remote
USD 84,000 - 126,000
Remote-friendly
Travel to client sites
Remote Data Engineer II: Scalable Pipelines & Data Warehousing
Remote Data Engineer II: Scalable Pipelines & Data Warehousing

First Citizens Bank • Phoenix (AZ)

Remote
USD 95,000 - 150,000