Institutional Data Engineer

The Institutional Data Engineer at the University of South Carolina designs, develops, maintains, and optimizes enterprise data infrastructure and integration processes to support dependable institutional analytics and reporting across the university ecosystem.

This position focuses on building and improving enterprise data pipelines (ETL/ELT), data integration workflows, and analytical data environments. The work includes data quality and governance support, system maintenance and modernization efforts, and ongoing monitoring to ensure reliability and availability of institutional reporting and analytics systems.

• Provide scalable and reliable access to institutional data.
• Improve data accuracy, completeness, and consistency.
• Modernize the institution’s analytics capabilities.
• Lead enterprise-wide data engineering and integration projects and initiatives as directed.
• Design, develop, and maintain enterprise data pipelines, ETL/ELT processes, system integrations, and automated workflows for institutional reporting and analytics.
• Partner with data architects to set technical standards and architect or optimize enterprise data models, data warehouses, curated datasets, and database objects to enable scalable, secure, and reliable access.
• Create and optimize database objects, including views and stored procedures, to improve performance and scalability.
• Monitor and enhance data architecture to ensure efficient, reliable access to institutional data.
• Support data integration across the Columbia campus and university system institutions to improve consistency and comparability of reporting.
• Implement data validation, reconciliation, and quality assurance processes, and resolve data discrepancies across source systems and analytical datasets.
• Develop automated monitoring and exception reporting to proactively detect data quality issues.
• Collaborate with data stewards and functional offices to recommend, establish, and maintain data standards and business rules.
• Support enterprise data governance and data stewardship practices.
• Maintain system documentation, process documentation, technical specifications, and metadata.
• Maintain and support enterprise data platforms, reporting databases, and data integration environments.
• Monitor system performance, troubleshoot issues, and implement corrective actions to ensure reliability and availability.
• Perform routine maintenance, upgrades, testing, and deployment activities for data infrastructure and integration processes.
• Respond to technical support requests related to institutional reporting and analytics systems.
• Assist with change management, backup procedures, disaster recovery, and business continuity planning for institutional data systems.
• Research, evaluate, and recommend emerging technologies, tools, and methodologies to enhance institutional analytics and data management capabilities.
• Identify opportunities to automate manual processes and improve operational efficiency.
• Participate in the development of reporting, dashboarding, and self-service analytics solutions.
• Support modernization initiatives involving cloud technologies, advanced analytics, and data platform enhancements.
• Contribute to continuous improvement efforts that increase the effectiveness of institutional data services.
• Partner with institutional research, information technology, academic units, administrative offices, and campus stakeholders to understand business needs and reporting requirements.
• Provide technical consultation and guidance regarding data availability, structure, and reporting capabilities.
• Support training and knowledge-sharing activities, including mentoring junior engineers and technicians across the USC system.
• Perform other duties assigned…