Data Engineer (AI) - Cincinnati

Medpace; Cincinnati (OH); On-site; USD 75,000 - 90,000; Full time

Benefits offered by this job

Flexible work environment

Competitive compensation and benefits package

Competitive PTO packages

Structured career paths

Company-sponsored employee appreciation events

Employee health and wellness initiatives

Job summary

Medpace is seeking a full-time, office-based Data Engineer to join its AI team in Cincinnati, Ohio. This role involves utilizing skills in data handling, working on projects critical to the company’s success, and developing software applications to visualize data.

The ideal candidate will have a Bachelor's Degree, relevant experience in data engineering, and strong knowledge of Python, SQL, and AI tools. Medpace offers a flexible work environment and a competitive benefits package.

Qualifications

• 1-3+ years of experience in Data Engineering.
• Background with AI tools supporting data extraction.
• Excellent analytical, written, and oral communication skills.

Responsibilities

• Utilize skills in handling unconventional data and transform it into data lakes.
• Create software applications to support data understanding and visualization.
• Collaborate with AI engineers to align data sources.

Skills

Data Engineering

Python programming

SQL Server

ETL development

NLP expertise

Education

Bachelor's Degree in Computer Science, Data Science, or a related field

Tools

Snowflake

Azure

REST APIs

Job description

Our corporate activities are growing rapidly, and we are currently seeking a full-time, office-based Data Engineer to join our AI team. This position will work on a team to accomplish tasks and projects that are instrumental to the company’s success. If you want an exciting career where you use your previous expertise and can develop and grow your career even further, then this is the opportunity for you.

Responsibilities

• Utilize skills in handling unconventional data such as unstructured content from web-based sites and varying content (documents, images, etc.) into different data lakes using software solutions such as Snowflake, Azure, SQL, and Python.
• Provide the handling of (and where needed training of) Large Language Models (LLMs) in the Extract, Transform, and Load (ETL) of large corpora of data into a data lake.
• Participate in NLP extraction of unstructured data into structured meta‑data using tools such as semantic understanding and meaning with Python and REST APIs.
• Support ensuring the data flow of any external content conforms to the latest US and EU AI Acts concerning AI, including security, confidentiality, and privacy of PHI.
• Collect, analyze, and document user requirements while working with AI engineers to align data sources to downstream integration within systems.
• Create software applications that support the understanding and visualization of data flows from inception to derivation, maintaining version control by following the software development lifecycle process (requirements gathering, design, development, testing, release, and maintenance).
• Participate in software validation through development, review, and/or execution of test plans, cases, or scripts.
• Communicate with team members regarding projects, development, tools, and procedures.
• Provide end‑user support, including setup, installation, and maintenance for applications.

Qualifications

• Bachelor's Degree in Computer Science, Data Science, or a related field.
• 1‑3+ years of experience in Data Engineering.
• Background with AI tools that support data extraction and natural language processing, handling varied unstructured content into structured meta‑data.
• Knowledge of developing dimensional data models from unstructured content and awareness of the advantages and limitations of Star Schema and Snowflake schema designs.
• Solid ETL development and reporting knowledge based on a deep understanding of business processes and measures.
• Knowledge of Snowflake cloud data warehouse and Azure cloud is preferred.
• Knowledge of REST APIs.
• Good knowledge of SQL Server databases and Python programming language is required.
• Knowledge of C# is a bonus, as is experience with Azure Data Fabric.
• Excellent analytical, written, and oral communication skills.

Medpace Perks

• Flexible work environment
• Competitive compensation and benefits package
• Competitive PTO packages
• Structured career paths with opportunities for professional growth
• Company‑sponsored employee appreciation events
• Employee health and wellness initiatives