Remote Data Engineer II — SQL & Data Warehousing

Ocient

United States

Remote

USD 110,000 - 185,000

Full time

6 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ocient is seeking a Data Engineer II to contribute to data engineering workstreams, onboarding customer workloads, and designing schemas within a growing analytics platform. This role collaborates with Solutions Architects and Senior Data Engineers to deliver pre-pilot engineering outputs and customer solutions.

You will load data, build workloads, translate queries to Ocient syntax, and document artifacts while expanding expertise in SQL-driven analytics and metadata analysis in a remote

Qualifications

  • 2+ years of data engineering or related role with SQL proficiency and data pipeline experience.
  • Experience contributing to schema design, data loading, and workload testing in data warehousing/analytics.
  • Strong SQL proficiency to write, convert, and optimize queries in large-scale analytics DBs.
  • Knowledge of ETL/ELT processes and data loading in relational or columnar systems.
  • Familiarity with metadata analysis, query bulk analysis, and workload performance testing.
  • Ability to produce accurate technical documentation and artifacts.

Responsibilities

  • Understand customer workloads with Solutions Architects and gather sample queries/workshops.
  • Convert queries to Ocient syntax and perform metadata analysis to understand fields and schemas.
  • Analyze queries to refine indexing and define initial schemas for pre-pilot workloads.
  • Load data, create workload test suites, and deploy end-to-end pre-pilot tests.
  • Build test cases and artifacts in GitHub and other repositories.
  • Assist with system sizing, timeline development, and GDPR/data rolloff procedures.
  • Report performance results and status to management and document workloads.

Skills

SQL proficiency
Data pipeline experience
Data warehousing
ETL/ELT processes
Metadata analysis
Documentation
Cross-functional collaboration

Education

Bachelor’s degree in Computer Science, Data Engineering, Information Systems

Tools

GitHub

Job description

Ocient is seeking a Data Engineer II to contribute to data engineering workstreams, onboarding customer workloads, and designing schemas within a growing analytics platform. This role collaborates with Solutions Architects and Senior Data Engineers to deliver pre-pilot engineering outputs and customer solutions.

You will load data, build workloads, translate queries to Ocient syntax, and document artifacts while expanding expertise in SQL-driven analytics and metadata analysis in a remote

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 Software Engineer II - Query Processing Performance
Remote Software Engineer II - Query Processing Performance

Ocient • United States

Remote
USD 145,000 - 165,000
Remote Software Engineer II — Query Processing & Performance
Remote Software Engineer II — Query Processing & Performance

Ocient • Chicago (IL)

Remote
USD 145,000 - 165,000
Remote-First Software Engineer II - High-Performance SQL DB
Remote-First Software Engineer II - High-Performance SQL DB

Feedinkoo: Remote Jobs • United States

Remote
USD 80,000 - 120,000
Remote Data Engineer II: Build & Optimize Data Pipelines
Remote Data Engineer II: Build & Optimize Data Pipelines

horacemannservicecorporation • United States

Remote
USD 77,000 - 106,000
Software Engineer II - High-Performance Query Processing (Remote)
Software Engineer II - High-Performance Query Processing (Remote)

Ocient • United States

Remote
USD 145,000 - 165,000
Remote Data Engineer II - Build Reliable Data Solutions
Remote Data Engineer II - Build Reliable Data Solutions

Remote • San Francisco (CA)

Remote
USD 77,000 - 106,000
Software Engineer II - Query Processing (Remote)
Software Engineer II - Query Processing (Remote)

Ocient Inc. • United States

Remote
USD 145,000 - 165,000
Data Warehouse Architect II - Remote Role
Data Warehouse Architect II - Remote Role

CareOregon, Inc. • Salem (OR)

Remote
USD 114,000 - 139,000
Remote Data Engineer II: Scalable Pipelines & Warehousing
Remote Data Engineer II: Scalable Pipelines & Warehousing

First Citizens Bank • Raleigh (NC)

Remote
USD 95,000 - 140,000