Senior Data Engineer

EITAcies, Inc.

Los Angeles, CA, United States

4 days ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Working hours

Regular working hours

Job source

www.wayup.com

Tech stack

Continuous Integration Data Validation Extract Transform Load (ETL) Data Transformation Oracle (Applications) SQL Databases Visual Studio Online Sql Optimization Snowflake Git Data Lakes Information Technology

+1 more

AWS Data Analytics

Job description

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., 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

Requirements

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