Senior Data Engineer - Snowflake/dbt Migration (Remote)

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

Job summary

EITACIES Inc. is seeking Senior Data Engineers (Level II & Level III) to support a major Oracle to Snowflake migration.

The role involves dbt development, data transformation, pipeline validation, and Snowflake optimization, with collaboration across onsite and offshore teams. Level II offers remote work with responsibilities including model development and transformation, while Level III is onsite leadership in Los Angeles, guiding architecture, UAT, and production cutover.

Qualifications

• Level II requires 5+ years of data engineering experience.
• Level III requires 10+ years and onsite leadership responsibilities.

Responsibilities

• Develop and maintain dbt models.
• Perform Oracle to Snowflake data transformation.
• 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 to Snowflake migration

Data validation

Git

CI/CD

VS Code

Education

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

Tools

VS Code

Job description

EITACIES Inc. is seeking Senior Data Engineers (Level II & Level III) to support a major Oracle to Snowflake migration.

The role involves dbt development, data transformation, pipeline validation, and Snowflake optimization, with collaboration across onsite and offshore teams. Level II offers remote work with responsibilities including model development and transformation, while Level III is onsite leadership in Los Angeles, guiding architecture, UAT, and production cutover.