Data Consultant Co-Op (2027 Spring Semester) / University of Cincinnati

Coretek provides AI, cloud, security, and managed services. We are seeking a Data Consultant Co-Op to help build the pipelines and datasets that support reporting, business operations, and AI solutions. Coretek’s AI & Data Co-Op Program places you on a team supporting internal initiatives and client projects.

With guidance from experienced Consultants, you will connect data sources, prepare datasets, and test your work. You will own defined tasks and incorporate feedback before changes go through review and approval. You will gain practical experience with SQL, Python, and Microsoft data platforms such as Azure and Microsoft Fabric.

Depending on project needs, you may also work with Power BI, Elastic, and Tines

Responsibilities

• Work with Consultants, project managers, and business users to understand data sources, reporting needs, and acceptance criteria for assigned tasks.
• Build assigned data pipelines to extract, transform, and load data from databases, files, and APIs, following established designs and standards.
• Write SQL queries and Python scripts to clean and combine data.
• Prepare tables and datasets for reporting, analytics, and AI applications.
• Check for missing values, duplicates, and invalid formats.
• Reconcile outputs to source records and investigate data discrepancies with the team.
• Monitor scheduled data jobs, help troubleshoot failures, and communicate delivery impacts early.
• Test corrections before requesting review or release.
• Document source-to-target mappings, transformation rules, and operating steps.
• Use version control and participate in code reviews so others can support the work.
• Follow approved data access and handling practices.
• Protect client information and obtain review before changing shared datasets or production pipelines.
• Keep project tasks and time entries current, raise blockers promptly, and help measure improvements in data accuracy, refresh times, or manual effort