Data Engineer II

This is a fully remote position, open to applicants in United States.

📋 Description

• Collaborate with Solutions Architects to gain insight into customer workloads and gather requirements via questionnaires and workshops

• Acquire sample queries and data whenever feasible

• Transform customer queries into Ocient syntax utilizing internal tools

• Conduct metadata analysis to comprehend field types, relationships, multi-dimensional elements, and evolving schemas

• Examine queries in bulk to identify indexing strategies and optimize schemas

• Establish initial schema designs for pre-pilot workload preparation

• Load data, develop workload test suites, and implement end-to-end sample workloads for preliminary pre-pilot testing

• Create test cases and validation materials for Delivery and Development teams

• Generate artifacts in GitHub and other repositories

• Support system sizing, delivery timeline creation, and the definition of GDPR and data rolloff procedures

• Report performance outcomes and progress to management

• Contribute to documentation for cross-functional workloads

• Engage in video interviews with the camera on for the entirety of each session

⛳️ Requirements

• A minimum of 2 years of experience in data engineering, database engineering, or a related technical position

• Proven SQL proficiency and experience with data pipelines

• Experience in schema design, data loading, and workload testing within a data warehousing or analytics setting

• Strong SQL skills, including the ability to write, convert, and optimize queries in large-scale analytical database environments

• Working knowledge of schema design, indexing strategies, ETL/ELT processes, and data loading in relational or columnar database systems

• Familiarity with metadata analysis, bulk query analysis, and workload performance testing

• Capability to independently produce precise technical documentation and engineering artifacts

• Ability to collaborate across different teams, including Solutions Architects, Delivery, and Engineering

• A Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related technical area is considered a strong qualification

• Experience with Big Data platforms, distributed database systems, or cloud data warehousing (such as AWS Redshift, Google BigQuery, Snowflake, or similar) is regarded as a strong qualification

• Familiarity with GDPR data compliance, HA/DR requirements, or data governance processes is considered a strong qualification

• Experience using GitHub or comparable version control and artifact repository tools is considered a strong qualification

• Only US-based candidates will be considered

• Must be eligible to work without visa sponsorship or transfer

🏝️ Benefits

• Remote-first work environment

• 100% remote work available for US-based candidates

• Video interviews conducted in a remote format