Senior Data Engineer

Eitacies Inc; Los Angeles (CA); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Eitacies Inc in Los Angeles is hiring a Senior Data Engineer for a large-scale Oracle to Snowflake migration initiative. This role offers Level II (Remote) and Level III (Onsite) positions, requiring 5+ to 10+ years of experience, respectively. Key responsibilities include dbt development, data transformation, and ensuring ETL pipeline data accuracy. Required skills include strong dbt and Snowflake expertise, advanced SQL, and CI/CD experience. A Bachelor's degree in Computer Science or a related field is necessary.

Qualifications

• 5+ years experience for Level II, including dbt model development.
• 10+ years experience for Level III, focusing on Snowflake architecture design.
• Strong collaboration skills for onsite and offshore teams.

Responsibilities

• Develop and maintain dbt models, perform Oracle to Snowflake transformations.
• Lead and architect Snowflake migration, manage offshore teams.
• Ensure data accuracy by monitoring ETL pipelines.

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

Education

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

Tools

AWS Data Engineering (Glue, Lambda, Step Functions)

Data Lake / ELT pipeline experience

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 experience: develop and maintain dbt models, perform Oracle to Snowflake data transformation, validate data using row count & checksum methods, monitor ETL pipelines to ensure data accuracy, optimize SQL for Snowflake performance.
• Level III Onsite - Lead / Architect, 10+ years experience: 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.