Senior Data Engineer

EITACIES Inc.; Los Angeles (CA); Hybrid; USD 120,000 - 160,000; Full time

Job summary

EITACIES Inc. in California seeks a Senior Data Engineer (Level II) or (Level III) to support a large Oracle-to-Snowflake migration. You will develop dbt models, transform data, validate results, and optimize Snowflake performance while collaborating with onsite and offshore teams.

Level II is remote, Level III is onsite at Los Angeles, CA. The role requires strong SQL, Oracle experience, and proficiency with Git, VS Code, and CI/CD practices.

Qualifications

• 5+ years of data engineering experience (Level II).
• 10+ years of data engineering experience (Level III).
• Strong experience in dbt and Snowflake.
• Advanced SQL skills.
• Experience with Oracle to Snowflake migration.
• Data validation and testing expertise.
• Experience with Git, VS Code and CI/CD practices.

Responsibilities

• Develop and maintain dbt models.
• Transform data from Oracle to Snowflake.
• Validate data using row counts and checksum methods.
• Monitor ETL pipelines and ensure data accuracy.
• Optimize SQL for Snowflake performance.
• Design Snowflake architecture (Bronze/Silver/Gold).
• Define dbt standards, macros and CI/CD practices.
• Lead UAT and stakeholder coordination.
• Handle migration issues and production cutover.
• Manage offshore delivery teams.

Skills

dbt

Snowflake

SQL

Oracle migration

Data validation

Git

CI/CD

VS Code

Education

Bachelor’s degree in Computer Science / IT or related field

Tools

VS Code

AWS Glue

CI/CD pipelines

Job description

Senior Data Engineer (Level II & Level III)

Level II is Remote work. Level III is Onsite at Los Angeles, CA. We are looking for experienced Data Engineers to support a large-scale Oracle to Snowflake migration initiative. This role involves dbt development, data transformation, pipeline validation and Snowflake optimization, along with strong collaboration across onsite and offshore teams.

Key Responsibilities

Level II - Data Engineer (5+ years)

• Develop and maintain dbt models
• Perform Oracle to Snowflake data transformation
• Validate data using row count & checksum methods
• Monitor ETL pipelines and ensure data accuracy
• Optimize SQL for Snowflake performance

Level III - Onsite Lead / Architect (10+ years)

• Design Snowflake architecture (Bronze/Silver/Gold layers)
• Define dbt standards, macros and CI/CD practices
• Lead UAT and stakeholder coordination
• Handle critical migration issues and production cutover
• Manage offshore delivery teams

Required Skills

• Strong experience in dbt and Snowflake
• Advanced SQL skills
• Experience with Oracle to Snowflake migration
• Data validation and testing expertise
• Experience with Git, VS Code and CI/CD practices

Preferred Skills

• AWS Data Engineering (Glue, Lambda, Step Functions)
• Data Lake / ELT pipeline experience

Education

Bachelor’s degree in Computer Science / IT or related field

This is a remote position.