Irvine Data Integration Engineer - ETL/ML Pipelines

RSM Solutions, Inc; Irvine (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

RSM Solutions, Inc is seeking a Data Integration Specialist to work onsite in Irvine, California. In this role, you will design, build, and operate data pipelines using MS SQL, SSIS, and Spark. You will collaborate with a team of data-centric professionals to ensure data accuracy and readiness for analytics.

The ideal candidate has 4+ years of experience in data integration, particularly in MS SQL and SSIS, with strong practical knowledge of machine learning clusters and Data Vault methodologies. This is an excellent opportunity for those who thrive in team environments and possess great problem-solving skills.

Qualifications

• 4+ years building data integration with MS SQL, SSIS, and Spark.
• At least 2 years of ML Cluster build experience.
• At least 2 years of experience with Data Vault.

Responsibilities

• Design and deploy pipelines using SSIS, Spark, Azure Data Factory.
• Create CI/CD pipelines for versioning ETL code.
• Benchmark and tune Spark and SQL performance.

Skills

Data integration

MS SQL

SSIS

Spark

PowerShell

Communication

Problem-solving

T SQL

Tools

Azure Data Factory

Git

MongoDB

Grafana

Job description

RSM Solutions, Inc is seeking a Data Integration Specialist to work onsite in Irvine, California. In this role, you will design, build, and operate data pipelines using MS SQL, SSIS, and Spark. You will collaborate with a team of data-centric professionals to ensure data accuracy and readiness for analytics.

The ideal candidate has 4+ years of experience in data integration, particularly in MS SQL and SSIS, with strong practical knowledge of machine learning clusters and Data Vault methodologies. This is an excellent opportunity for those who thrive in team environments and possess great problem-solving skills.