Data Engineer II

Ocient

United States

Remote

USD 110,000 - 185,000

Full time

46 hours 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 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

  • We cannot sponsor or transfer any visas, of any kind, at this time*
Job Title

Data Engineer II

  • We cannot sponsor or transfer any visas, of any kind, at this time*
Location

100% Remote (US Based Only)

Hiring Manager

Senior Director of Data Engineering

Estimated salary range

$110,000 to $185,000

  • The salary offered for this position will be based on a candidate’s experience and skill demonstrated during interviews and other evaluations
Position Overview

The Data Engineer II 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, metadata analysis tooling, and workload performance analysis. The Data Engineer II is technically rigorous, collaborative, and developing the deep engineering skills that define Ocient’s customer-facing data engineering excellence.

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.
Ideal Qualifications
  • 2+ years of experience in data engineering, database engineering, or a related technical role with demonstrated SQL proficiency and data pipeline experience.
  • Demonstrated experience contributing to schema design, data loading, and workload testing in a data warehousing or analytics environment.
  • Strong SQL proficiency with the ability to write, convert, and optimize queries in large-scale analytical database environments.
  • Working knowledge of schema design, indexing strategy, ETL/ELT processes, and data loading in relational or columnar database systems.
  • Familiarity with metadata analysis, query bulk analysis, and workload performance testing.
  • Strong attention to detail with the ability to independently produce accurate technical documentation and engineering artifacts.
  • Good written and verbal communication skills with the ability to collaborate cross-functionally with Solutions Architects, Delivery, and Engineering teams.
An Exceptional Candidate Will Have
  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
  • Experience with Big Data platforms, distributed database systems, or cloud data warehousing (AWS Redshift, Google BigQuery, Snowflake, or comparable).
  • Familiarity with GDPR data compliance, HA/DR requirements, or data governance processes.
  • Experience with GitHub or comparable version control and artifact repository tools.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Engineer II - Query Processing
Software Engineer II - Query Processing

Ocient • United States

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

Ocient • Chicago (IL)

Remote
USD 145,000 - 165,000
Remote Data Engineer II: SQL Pipelines & Analytics
Remote Data Engineer II: SQL Pipelines & Analytics

Ocient • United States

Remote
USD 110,000 - 185,000
Data Engineer 2
Data Engineer 2

Korn Ferry Group • Lakewood (OH)

Remote
USD 90,000 - 120,000
Data Engineer II
Data Engineer II

Gravity IT Resources • Mountain View (CA)

Hybrid
USD 96,000 - 165,000
Software Engineer II – I/O at Ocient
Software Engineer II – I/O at Ocient

Feedinkoo: Remote Jobs • United States

Remote
USD 80,000 - 120,000
Data Engineer (USI8) (2400)
Data Engineer (USI8) (2400)

Kellstrom Aerospace • Augusta (KS)

On-site
USD 120,000 - 160,000
Data Engineer | Octagon IT | Remote (PST Zone)
Data Engineer | Octagon IT | Remote (PST Zone)

Octagon IT • United States

Remote
USD 110,000 - 160,000
Data Engineer
Data Engineer

Ethereum Technologies LLC • Houston (TX)

On-site
USD 120,000 - 180,000
Data Observability Engineer
Data Observability Engineer

The Sherwin-Williams Company • Cleveland (OH)

On-site
USD 90,000 - 140,000