Data Consultant Co-Op, Spring 2027

This is a fully remote position, open to applicants in Ohio.

📋 Description

• Collaborate with consultants, project managers, and business users to gain insights into data sources, reporting requirements, and acceptance criteria for assigned tasks.

• Develop designated data pipelines to extract, transform, and load data from databases, files, and APIs, adhering to established designs and standards.

• Create SQL queries and Python scripts for data cleansing and integration. Prepare tables and datasets for reporting, analytics, and AI applications.

• Identify missing values, duplicates, and invalid formats. Reconcile outputs with source records and investigate data discrepancies alongside the team.

• Oversee scheduled data jobs, assist in troubleshooting failures, and communicate delivery impacts promptly. Test corrections prior to requesting review or release.

• Document source-to-target mappings, transformation rules, and operational steps. Utilize version control and engage in code reviews to enable others to support the work.

• Adhere to approved data access and handling protocols. Safeguard client information and seek review before modifying shared datasets or production pipelines.

• Maintain current project tasks and time entries, promptly raise blockers, and assist in measuring improvements in data accuracy, refresh times, or manual effort.

⛳️ Requirements

• Currently enrolled in a degree program in Computer Science, Data Science, Information Systems, Computer Consulting, or a related field, with eligibility for a university co-op program.

• Basic SQL skills, including filtering, joins, grouping, and aggregations, coupled with an understanding of relational tables, keys, and fundamental database concepts.

• Introductory Python programming experience gained through coursework, personal projects, or prior work, including file reading, data manipulation, and code troubleshooting.

• Understanding of data movement between systems and a keen interest in data pipelines, transformation, and storage. Experience with CSV or JSON data is advantageous.

• Strong attention to data accuracy and the ability to probe unexpected results, articulate findings, and seek assistance when requirements or source data are ambiguous.

• Effective written and verbal communication skills, a readiness to act on feedback, and the capability to complete assigned tasks while keeping teammates informed of progress and obstacles.

• Familiarity with Git, APIs, Microsoft Azure, Microsoft Fabric, or Power BI is a bonus. Relevant experience includes coursework and personal projects.

• Experience with Elastic for search and data analysis or Tines for workflow automation is a plus. Project assignments will dictate which tools you will utilize.

• Familiarity with AI coding tools is beneficial, along with a willingness to test generated code, comprehend its behavior, and adhere to company policies regarding data and tool usage.

🏝️ Benefits

• Opportunity to gain hands-on experience in the field of data science and analytics.

• Work collaboratively with a team of experienced professionals and gain mentorship.

• Flexible work hours to accommodate academic schedules.

• Potential for future employment opportunities upon successful completion of the co-op program.