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

Coretek Services • Cincinnati, OH

1d

About The Position

Coretek is seeking a Data Consultant Co-Op for the 2027 spring semester to help build pipelines and datasets supporting reporting, business operations, and AI solutions. Coretek’s AI & Data Co-Op Program assigns students to a team working on internal initiatives and client projects. With guidance from experienced Consultants, the co-op will connect data sources, prepare datasets, and test their work. The co-op will own defined tasks, incorporate feedback, and submit changes for review and approval.

The role provides practical experience with SQL, Python, and Microsoft data platforms such as Azure and Microsoft Fabric. Depending on project needs, work may also involve Power BI, Elastic, and Tines. Successful co-ops produce dependable data, check results against source records, follow through on commitments, and provide documentation that enables the team to maintain their work after the co-op ends.

Requirements

• Currently pursuing a degree in Computer Science, Data Science, Information Systems, Computer Consulting, or a related field, and eligible to participate in a university co-op program.
• Foundational SQL skills, including filtering, joins, grouping, and aggregations, and an understanding of relational tables, keys, and basic database concepts.
• Basic Python programming experience through coursework, personal projects, or previous work, including reading files, manipulating data, and troubleshooting code.
• Familiarity with how data moves between systems and an interest in data pipelines, transformation, and storage.
• Careful attention to data accuracy and the ability to investigate unexpected results, explain findings, and ask for help when requirements or source data are unclear.
• Clear written and verbal communication, willingness to act on feedback, and ability to complete agreed tasks while keeping teammates informed of progress and blockers.

Nice To Haves

• Experience working with CSV or JSON data.
• Exposure to Git, APIs, Microsoft Azure, Microsoft Fabric, or Power BI; coursework and personal projects count as relevant experience.
• Exposure to Elastic for search and data analysis or Tines for workflow automation.
• Experience using AI coding tools, willingness to test generated code and understand its behavior, and ability to follow company rules for data and tool use.

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, and 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 discrepancies with the team.
• Monitor scheduled data jobs, help troubleshoot failures, communicate delivery impacts early, and 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Intern
• Education Level: No Education Listed