Data Engineer II

Responsibilities

The Data Engineer II supports customer workload onboarding, schema design, and query conversion using Ocient's SQL platform. They collaborate with Solutions Architects to perform metadata analysis, load data, and execute pre-pilot workload testing.

Requirements

Candidates must have at least 2 years of experience in data engineering or database engineering with strong SQL proficiency. Experience with schema design, data loading, and workload testing in analytical environments is required.

Skills

• SQL
• Data Engineering
• Schema Design
• Data Loading
• Workload Testing
• Metadata Analysis
• ETL
• ELT
• Query Optimization
• Database Engineering
• Analytical Databases
• Performance Analysis
• GitHub
• Data Warehousing
• Technical Documentation

About this role

Job Title: Data Engineer II
Location: 100% Remote (US Based Only)
* We cannot sponsor or transfer any visas, of any kind, at this time*

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.

About Ocient Inc.

Software Development · 201-500 employees · headquartered in Chicago, Illinois · founded 2016