Sr. Data Engineer

Stand8 Technology Consulting; California; Presencial; USD 90.000 - 103.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical coverage

Health Savings Account (HSA)

Dental/Vision/Ancillary coverages

401(k) retirement plan

Paid time-off

Employee Assistance Program (EAP)

Discount programs

Descripción de la vacante

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.

Formación

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

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

Conocimientos

DBT

Snowflake

Oracle

ETL/ELT

Data migration

Cloud architecture

dbt tests

Educación

Engineering degree

Herramientas

dbt

Snowflake

Oracle

Descripción del empleo

Stand8 provides end to end IT solutions to enterprise partners across the United States and with offices in Los Angeles, New York, New Jersey, Atlanta, and more including internationally in Mexico and India.

The Level 3 Sr. Data Engineer will execute the transformation and migration of legacy Oracle data assets into Snowflake using dbt. This contract role will build modular transformation models, validate migrated data, and continuously monitor ELT pipelines across development and quality assurance environments. The position will optimize SQL and Snowflake performance while maintaining testing and documentation standards for migrated tables. The engineer will also guide cloud architecture best practices and support UAT approvals through completion.

Location & Work Type

Key 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 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.

Qualifications

Required:

• 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

• Strong hands-on Oracle development in large enterprise/data warehouse environment
• Technical Degree in Engineering or Equivalent

• Data Stack Expertise: Hands-on experience with dbt and cloud data migration projects.
• Proven Migration Track Record: Real-world, hands-on implementation experience migrating legacy Oracle databases to Snowflake using dbt.
• Leadership & Best Practices: Ability to coach and guide the team on cloud architecture best practices while managing UAT approvals to completion.

Preferred (Optional):

• Medical coverage and Health Savings Account (HSA) through Anthem
• Dental/Vision/Various Ancillary coverages through Unum
• 401(k) retirement savings plan
• Paid-time-off options
• Company-paid Employee Assistance Program (EAP)
• Discount programs through ADP WorkforceNow

The base range for this contract position is $65 - $75 / per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Qualified applicants with arrest or conviction records will be considered.

About Us

Stand8 provides end-to-end IT solutions to enterprise partners across the United States and globally with offices in Los Angeles, Atlanta, New York, Mexico, Japan, India, and more. Stand8 focuses on the "bleeding edge" of technology and leverages automation, process, marketing, and over fifteen years of success and growth to provide a world-class experience for our customers, partners, and employees.

Our mission is to impact the world positively by creating success through PEOPLE, PROCESS, and TECHNOLOGY.

By applying to this position, your data will be processed in accordance with the Stand8 Privacy Policy.