Senior Data Engineer

Eitacies Inc

4d • Remote

About The Position

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. The position is offered at two levels: Level II for candidates with 5+ years of experience, focusing on dbt development, data transformation, validation, and pipeline monitoring; and Level III for Lead/Architect roles with 10+ years of experience, focusing on Snowflake architecture design, dbt standards, UAT leadership, critical migration issue handling, and managing offshore 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

Nice To Haves

• AWS Data Engineering (Glue, Lambda, Step Functions)
• Data Lake / ELT pipeline experience

Responsibilities

• 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
• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Number of Employees: 11-50 employees