Please mention DailyRemote when applying
AI Summary
The role involves managing large-scale Oracle to Snowflake migrations, including dbt development, data transformation, and pipeline validation. Responsibilities also include designing Snowflake architecture, defining CI/CD standards, and leading offshore delivery teams for production cutovers.
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.
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
