Senior Data Engineer: Snowflake Migrations & Cloud Analytics

RESOURCESOFT, INC.; Los Angeles (CA); On-site; USD 140,000 - 190,000; Full time

Job summary

Resourcesoft, Inc. seeks a senior data engineer to lead cloud data migrations and modern modeling efforts. The role focuses on migrating legacy Oracle workloads to Snowflake and building scalable dbt-based data pipelines for analytics.

You will collaborate with engineering teams to design robust ETL/ELT processes, optimize performance, and ensure security and reliability across environments. Excellent communication is required to coordinate stakeholders and drive successful migrations.

Qualifications

• 7+ years in data engineering, Oracle and enterprise data warehouses.
• Proficiency in dbt and Snowflake for cloud transformations and modeling.
• Experience migrating legacy Oracle databases to Snowflake using dbt.
• ETL/ELT development, data mappings, transformations, scheduling and pipeline troubleshooting.
• Database infrastructure, backup/recovery, security, performance tuning and cloud architecture.
• Excellent verbal and written communication skills.

Responsibilities

• Lead migration of legacy Oracle workloads and warehouse workloads to Snowflake.
• Build and optimize dbt models, transformations and data pipelines for scalable cloud analytics.
• Design, schedule and troubleshoot ETL/ELT processes and data mappings.
• Manage database performance, security, backup, recovery and reliability across environments.
• Coach engineering team members on cloud data architecture standards.
• Coordinate UAT activities and drive migration deliverables through validation and completion.

Skills

Data engineering

Oracle development

Enterprise data warehouses

dbt

Snowflake

Cloud data transformations

Modeling

Communication skills

Tools

Oracle

dbt

Snowflake

Job description

Resourcesoft, Inc. seeks a senior data engineer to lead cloud data migrations and modern modeling efforts. The role focuses on migrating legacy Oracle workloads to Snowflake and building scalable dbt-based data pipelines for analytics.

You will collaborate with engineering teams to design robust ETL/ELT processes, optimize performance, and ensure security and reliability across environments. Excellent communication is required to coordinate stakeholders and drive successful migrations.