Data Migration Engineer

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

Data Migration Engineer (Contract for Hire)

Our client is seeking a hands-on Data Engineer to lead critical system-to-system data migrations and expand its Snowflake data environment. This is an opportunity to take ownership of complex data initiatives, transform legacy data into reliable business insights, and build scalable solutions that support long-term operations. If you enjoy solving challenging data problems and seeing projects through from migration to production, this role is for you.

As part of our process after applying, you may receive an invitation from our AI Recruiter Avery for a short conversation that lets you share more about your background beyond your resume. For questions, contact [e-mail].

• Location: Onsite, Newport Beach, CA
• Compensation: This job is expected to pay about 70-80/HR W2
• No Visa Sponsorship Available for this role

What You’ll Do:

Key Responsibilities

• Lead end-to-end data migrations for a rental management system and CRM, including extraction, cleansing, transformation, loading, and validation.
• Develop data quality processes, including deduplication, matching, and reconciliation, to ensure accurate and reliable data.
• Own and enhance the Snowflake environment, building ELT pipelines, data models, and integrations with operational systems.
• Collaborate with internal stakeholders, technical teams, and vendors to translate business requirements into effective migration solutions.
• Maintain and optimize data pipelines after go-live, troubleshooting issues and ensuring ongoing data integrity and performance.

What Gets You the Job:

Qualifications

• 5+ years of data engineering experience, including hands-on ownership of large-scale system-to-system migrations, ideally involving POS, ERP, or CRM platforms.
• Strong Snowflake development experience, including data loading, transformation, modeling, and pipeline development.
• Advanced SQL skills with expertise in data profiling, cleansing, deduplication, reconciliation, and query optimization.
• Experience with relational databases, Python or similar programming languages, and ETL/ELT tools such as dbt, Airflow, Fivetran, or SSIS.
• Experience with relational and dimensional data modeling, strong problem-solving skills, and a bachelor’s degree in a related field or equivalent practical experience.

Irvine Technology Corporation (ITC)connects top talent with exceptional opportunities in IT, Security, Engineering, and Design. From startups to Fortune 500s, we partner with leading companies nationwide. Our AI recruiter, Avery helps streamline the first step of your journey—so we can focus on what matters most: helping you grow. Join us. Let us ELEVATE your career!

Irvine Technology Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Irvine Technology Corporation complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.