Data Integration Engineer
Core
Develop, implement, and support secure data integrations, migrations, and ETL/ELT pipelines across ERP, student information systems, and data warehouses to enable campus-wide data interoperability.
Role type
Data Integration Engineer
Builds
Data pipelines, migration solutions, and system-to-system integration components for the Workday ecosystem and data warehouse.
Domain
Higher Education / Enterprise Data Integration
Required skills
ETL/ELT tool development, API integration design, data migration strategy, relational database management, SQL coding, workflow automation, structured/unstructured data handling, on-prem and SaaS system integration, cloud platform experience (AWS/Azure), iPaaS utilization.
Preferred skills
Higher education domain knowledge, BI tool usage (Tableau/Power BI), web service technologies (SOAP/REST), cloud data warehouse solutions, object-oriented scripting languages.
Technologies
SQL Server Integration Services, Azure Data Factory, Oracle Data Integrator, Dell Boomi, Mulesoft, Informatica, Workday, Ellucian Banner, AWS, Azure, JSON, XML, SFTP, REST, SOAP.
Responsibilities
Analyze new systems to develop functional and technical requirements for integration; develop and execute data migration solutions ensuring historical data continuity; build and maintain ETL/ELT tools and batch upload scripts; design changes to existing integrations to improve performance; monitor data movement and maintain integrity; establish alerting and metrics for integrations; partner with security teams to ensure compliant data access.
Seniority
Mid-level, hands-on IC