Senior Data Engineer – Snowflake/dbt Migration Lead

Stand8 Technology Consulting; California; Presencial; USD 90 000 - 103 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical coverage

Dental/Vision coverage

401(k) retirement plan

Paid time-off

Employee Assistance Program

Resumo da oferta

Stand8 Technology Consulting seeks a Level 3 Sr. Data Engineer to migrate legacy Oracle data assets to Snowflake using dbt. You will build modular models, validate migrated data, and monitor ELT pipelines across Dev and QA, while optimizing SQL and Snowflake performance.

You will rewrite procedures, implement tests, and document schema, with leadership in cloud best practices and support for UAT approvals to completion. This is a contract role based in the United States.

Qualificações

• Must have strong experience with DBT, Snowflake, Oracle, etc.
• Experience with database infrastructure, backup/recovery, security and performance.
• ETL/ELT development, mappings, transformations, scheduling and troubleshooting

Responsabilidades

• Rewrite legacy Oracle stored procedures and views into modular dbt models.
• Implement dbt tests (schema, unique, not_null) and maintain schema.yml documentation for all migrated tables.
• Refactor and optimize Oracle SQL to leverage Snowflake features, including micro-partitioning and clustering keys, to improve performance and reduce costs.
• Monitor extraction jobs to verify that data is correctly loaded 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 to ensure consistency prior to onsite UAT.
• Develop, schedule, and troubleshoot ETL/ELT mappings, transformations, and pipelines.
• Coach and guide the team on cloud architecture best practices while managing UAT approvals to completion.

Conhecimentos

DBT

Snowflake

Oracle

ETL/ELT development

Formação académica

Technical Degree in Engineering or Equivalent

Ferramentas

DBT

Snowflake

Oracle

Descrição da oferta de emprego

Stand8 Technology Consulting seeks a Level 3 Sr. Data Engineer to migrate legacy Oracle data assets to Snowflake using dbt. You will build modular models, validate migrated data, and monitor ELT pipelines across Dev and QA, while optimizing SQL and Snowflake performance.

You will rewrite procedures, implement tests, and document schema, with leadership in cloud best practices and support for UAT approvals to completion. This is a contract role based in the United States.