Lead Data Migration Engineer | Snowflake ELT

Irvine Technology Corporation; Newport Beach (CA); On-site; USD 96,000 - 110,000; Full time

Job summary

Irvine Technology Corporation connects top talent with exceptional opportunities in IT, Security, Engineering, and Design. This Data Migration Engineer role onsite in Newport Beach, CA leads end-to-end migrations for a rental management system and CRM, builds Snowflake ELT pipelines, and ensures data integrity through go-live and beyond.

The ideal candidate has 5+ years of data engineering experience with large-scale migrations, strong Snowflake skills, and depth in SQL and ETL/ELT tools.

Qualifications

• 5+ years of data engineering experience with large-scale migrations.
• Snowflake development: loading, transforming, modeling, pipelines.
• Advanced SQL with data profiling, cleansing and deduplication.
• Experience with dbt, Airflow, Fivetran, or SSIS.
• Bachelor’s degree or equivalent practical experience.

Responsibilities

• Lead end-to-end data migrations for a rental management system and CRM.
• Develop data quality processes including deduplication and reconciliation.
• Own and enhance Snowflake environment and ELT pipelines.
• Collaborate with stakeholders to translate requirements into migration solutions.
• Maintain data pipelines post go-live and ensure data integrity.

Skills

Advanced SQL

Python

Data migrations

Data quality

Education

Bachelor's degree or equivalent

Tools

Snowflake

dbt

Airflow

Fivetran

SSIS

Job description

Irvine Technology Corporation connects top talent with exceptional opportunities in IT, Security, Engineering, and Design. This Data Migration Engineer role onsite in Newport Beach, CA leads end-to-end migrations for a rental management system and CRM, builds Snowflake ELT pipelines, and ensures data integrity through go-live and beyond.

The ideal candidate has 5+ years of data engineering experience with large-scale migrations, strong Snowflake skills, and depth in SQL and ETL/ELT tools.