AWS Lambda, Acceptance Testing, Amazon Web Services (AWS), Architectural Design, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Lake, Data Quality, Database Extract Transform and Load (ETL), Delivery Management, Git, Offshoring, Oracle, Performance Tuning/Optimization, SQL (Structured Query Language), Snowflake Schema, Standards Development, Team Lead/Manager, Validation Testing, Work From Home
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.