[Remote] Data Engineer II

Note: The job is a remote job and is open to candidates in USA. Ocient is hiring a Data Engineer II to support customer workload onboarding and pre-pilot engineering. The role involves schema design, query conversion, data loading, workload testing, and collaboration with Solutions Architects and Senior Data Engineers.

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

• 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
• US Based Only
• We cannot sponsor or transfer any visas, of any kind, at this time
• 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

Benefits

• 100% remote (US based only)

Company Overview