Senior Data Integration Lead

Iowa State University FoundationAmes, IA

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Schedule

Full-time

Career level

Senior-level

Job Description

As a member of the data engineering team, this role is responsible for the design, implementation, support, and modernization of the data ingestion and integration layer within the ISU Foundation Enterprise Data Platform. This includes ensuring reliable, secure, and efficient movement of data between internal systems and external SaaS applications using modern ELT tooling, Azure cloud services, and existing integration technologies that are being strategically retired.This position balances operational reliability with continuous platform improvement, helping transition legacy SSIS-based processes toward scalable, automated, and cloud-native approaches. This individual provides technical leadership and subject matter expertise for integration architecture, standards, and best practices while partnering closely with data services, analytics, governance, and IT teams.Core Responsibilities include but are not limited to:

Design, implement, and support the integration components of the ISU Foundation Enterprise Data Platform.Define and maintain integration standards aligned to the organization's Azure SQL Managed Instance and Medallion (Bronze/Silver/Gold) architecture.Serve as technical subject matter expert for data ingestion, movement, and transformation practices.Evaluate and recommend tools and approaches that improve reliability, scalability, and cost efficiency of the platform.Configure and manage Fivetran connectors and automated ingestion pipelines.Maintain, troubleshoot, and enhance existing SSIS packages while leading efforts to migrate legacy processes to modern cloud-native solutions.Design and implement API-based and file-based integrations with systems such as Salesforce and other third-party platforms.Build monitoring, alerting, and observability practices to ensure integration, reliability, and data quality.Leverage Azure platform services to support integration and automation use cases.Develop lightweight orchestration and automation solutions to reduce manual processes.Support production incidents, troubleshooting, and root cause analysis.

QualificationsEducation & Work Experience

Bachelor's degree in MIS, computer science, engineering, or related field required.6+ years of professional experience in data engineering, data integration, or enterprise data platform development including both legacy ETL and modern cloud-based approaches.

Desired Skills & Experience

Strong SQL development and performance tuning skills.Hands-on experience with enterprise data integration and ETL/ELT practices.Experience developing and supporting SSIS packages or comparable ETL tools.Experience working with Azure SQL, Azure cloud services, or similar platforms.Experience with SaaS-based integration tools such as Fivetran or similar technologies.Experience designing and supporting REST/API-based integrations.Familiarity with Azure services such as Logic Apps, Azure Functions, or related automation tools.Experience with dbt or similar transformation frameworks preferred.Experience integrating enterprise SaaS platforms such as Salesforce preferred.Python or scripting for automation preferred.Experience modernizing or mitigating legacy ETL environments to cloud-native platforms preferred.Familiarity with cost optimization and operational best practices in cloud environments preferred.Knowledge of Agile principles and SCRUM development framework preferred.Excellent verbal and written communication, interpersonal. and customer service skills.Ability to work independently and as part of a team. Must be adaptable, flexible, and self-directed.Proficiency with Microsoft Office Suite and ability to learn new software and technologies.Must be able to handle several activities simultaneously with attention to detail and adherence to deadlines and accuracy.Must adhere to strict confidentiality standards.Creativity, patience, a sense of humor and a belief in our organizational mission of: Aligning donor passion and generosity to advance Iowa State University's land grant ideals

Travel: NoneFLSA Status: ExemptLocation: Ames, IA; potentially hybridFor additional information, visit the following pages:

Iowa State University Foundation

Benefits Package Information

Iowa State University

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Senior Data Integration Lead Jobs at Iowa State University Foundation

What is the work location for this position at Iowa State University Foundation?

This job at Iowa State University Foundation is located in Ames, IA, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at Iowa State University Foundation?

Employer has not shared pay details for this role.

What employment applies to this position at Iowa State University Foundation?

Iowa State University Foundation lists this role as a Full-time position.

What experience level is required for this role at Iowa State University Foundation?

Iowa State University Foundation is looking for a candidate with "Senior-level" experience level.

What is the process to apply for this position at Iowa State University Foundation?

You can apply for this role at Iowa State University Foundation either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.