Iowa State University Foundation · 4 hours ago
Senior Data Integration Lead
Ames, IA
Part-time
Hybrid
Senior Level, Lead/Staff
6+ years expIowa State University Foundation is seeking a Senior Data Integration Lead to join their data engineering team. This role focuses on the design, implementation, and modernization of the data ingestion and integration layer within the ISU Foundation Enterprise Data Platform, ensuring reliable and efficient data movement between systems and applications.
Social MediaEducationCommunities
Hiring Manager
Emily Bingaman
Responsibilities
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
Qualification
Required
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
Preferred
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
Company
Iowa State University Foundation
The Iowa State University Foundation is a private non-profit organization dedicated to securing private grants for Iowa State University. It is a sub-organization of Iowa State University.
51-200 employees
H1B Sponsorship
Iowa State University Foundation has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
Funding
Current Stage
Growth StageLeadership Team
Emily Hager, CPA
Chief Financial Officer
Rosa U.
VP and CIO
Company data provided by crunchbase