Data Integration Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

RSM Solutions, Inc ยท 2 weeks ago

Data Integration Engineer

positionIrvine, CA
timeFull-time
remoteOnsite
seniorityMid, Senior Level
money$100K/yr - $120K/yr
date4+ years exp

RSM Solutions, Inc is a company focused on recruiting technical talent and is seeking a Data Integration Engineer. In this role, you will design, build, and operate data pipelines to ensure data is accurate and analytics-ready, working closely with a team of data-centric individuals.

Human ResourcesProfessional ServicesStaffing Agency
badNo H1BnoteU.S. Citizen Onlynote
Hiring Manager
Tom Welke
linkedin

Responsibilities

Design, develop, and deploy incremental and full load pipelines using SSIS, Spark, Runbooks and Azure Data Factory to ingest data into landing, raw, and curated layers of the Data Vault
Build CDC (change data capture) solutions to minimize latency for downstream reporting and ML features
Automate schema evolution and metadata population for hubs, links, and satellites
Implement validation rules, unit tests, and data quality frameworks to enforce referential integrity and conformance to business rules
Maintain a requirements traceability matrix and publish data lineage documentation Metadata Management / SSAS models. This includes partnering with this team's BA to translate user stories into technical interfaces and mapping specs
Create CI/CD pipelines (Azure DevOps, Git) to version ETL code, infrastructure as code, and automated tests
Develop PowerShell/.NET utilities to orchestrate jobs, manage secrets, and push metrics to Grafana or Azure Monitor
Benchmark and tune Spark, SQL, and SSIS performance; recommend index strategies, partitioning, and cluster sizing strategies for cost/performance balance
Stay current with emerging integration patterns (e.g., event driven architectures, Delta Lake) and propose pilots for adoption

Qualification

Data IntegrationMS SQLSSISSparkData VaultT SQLPython/ScalaPowerShell/.NETMongoDBStakeholder ManagementGit CI/CDData Vault 2.0 CertificationCommunicationProblem Solving

Required

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
Strong T SQL, Python/Scala for Spark, PowerShell/.NET scripting; working knowledge of MongoDB aggregation, SSAS tabular models, and Git CI/CD
Excellent problem solving, communication, and stakeholder management abilities

Preferred

Data Vault 2.0 certification a plus

Company

RSM Solutions, Inc

twittertwitter
company-logo
We are more focused on low failure rate than a high fill rate.
dateFounded in 2001
location
Naples, Florida, USA
people-size11-50 employees
web-link
https://rsmsolutionsinc.com/

Funding

Current Stage
Early Stage

Leadership Team

leader-logo
Tom Welke
Partner and Vice President
linkedin
Company data provided by crunchbase