Snowflake Data Engineer — Oracle to dbt Migration Lead

Stand8 Technology Consulting; California; On-site; USD 90,000 - 103,000; Full time

Benefits offered by this job

Medical coverage

Health Savings Account (HSA)

Dental/Vision/Ancillary coverages

401(k) retirement plan

Paid time-off

Employee Assistance Program (EAP)

Discount programs

Job summary

Stand8 Technology Consulting seeks a Level 3 Sr. Data Engineer for a contract role to migrate legacy Oracle data to Snowflake using dbt. The engineer will rewrite procedures into modular models, implement tests, and optimize SQL for Snowflake performance while documenting schemas and validating migrations.

The role includes monitoring ELT pipelines, running dbt workflows across Dev/QA, and guiding cloud architecture practices while supporting UAT approvals to completion.

Qualifications

• DBT, Snowflake, and Oracle experience in a large enterprise/data warehouse.
• ETL/ELT development, mappings, scheduling, and troubleshooting.
• Capable of migrating legacy Oracle data to Snowflake and validating results.

Responsibilities

• Rewrite legacy Oracle stored procedures and views into modular dbt models.
• Implement dbt tests (schema, unique, not_null) and maintain schema.yml documentation for migrated tables.
• Refactor and optimize Oracle SQL for Snowflake with micro-partitioning and clustering keys.
• Monitor extraction jobs to verify data loads into staging before dbt processing.
• Perform row count and checksum comparisons between Oracle source data and Snowflake target data.
• Run dbt workflows (dbt run, dbt test) across Dev and QA environments before UAT.
• Develop, schedule, and troubleshoot ETL/ELT mappings, transformations, and pipelines.
• Coach and guide the team on cloud architecture best practices and lead UAT approvals.

Skills

DBT

Snowflake

Oracle

ETL/ELT

Data migration

Cloud architecture

dbt tests

Education

Engineering degree

Tools

dbt

Snowflake

Oracle

Job description

Stand8 Technology Consulting seeks a Level 3 Sr. Data Engineer for a contract role to migrate legacy Oracle data to Snowflake using dbt. The engineer will rewrite procedures into modular models, implement tests, and optimize SQL for Snowflake performance while documenting schemas and validating migrations.

The role includes monitoring ELT pipelines, running dbt workflows across Dev/QA, and guiding cloud architecture practices while supporting UAT approvals to completion.