Junior Data Engineer Job at Agility Partners, Cincinnati, OH

bm4rUjd5TlpLL3JDZjhZOXhKRmZBNEZw
  • Agility Partners
  • Cincinnati, OH

Job Description

Agility Partners is seeking a qualified Junior Data Engineer to fill an open position with one of our clients. This is an exciting opportunity for an early‑career professional to build real‑world data skills in a supportive, fast‑paced environment. You’ll work closely with senior engineers and analysts, primarily using SQL to query, clean, and prepare data that powers reporting and analytics.

Responsibilities

  • Assist with writing and optimizing SQL queries to support reporting and ad‑hoc data requests
  • Help create basic database objects (tables, views) and maintain data dictionaries and documentation
  • Support routine data quality checks (duplicates, nulls, referential integrity) and simple SQL‑based transformations
  • Participate in loading data into staging tables and preparing datasets for downstream use
  • Troubleshoot query issues (e.g., incorrect results, slow performance) with guidance from senior engineers
  • Collaborate with analytics teams to validate results and ensure datasets meet business needs

The Ideal Candidate

  • Foundational SQL proficiency: comfortable writing basic queries and joins; curiosity to learn window functions and indexing
  • Understanding of relational database concepts (keys, normalization vs. denormalization)
  • 0–2 years of professional experience (or internship/capstone/bootcamp projects); recent grads welcome
  • Detail‑oriented, coachable, and comfortable asking questions and working through feedback
  • Able to document work clearly and communicate findings to non‑technical stakeholders
  • Bonus (not required): exposure to Excel/Google Sheets or a BI tool (Power BI/Tableau), and interest in learning simple ETL concepts

Reasons to Love It

  • Learn directly from experienced data engineers while working on meaningful, production datasets
  • Clear growth path from SQL fundamentals to broader data engineering skills over time
  • Supportive team culture that values curiosity, reliability, and steady skill development

Job Tags

Internship,

Similar Jobs

CalOpps

Per Diem Police Dispatcher (20674738) Job at CalOpps

Location One Twin Pines Lane Belmont, 94002 Description Are you an experienced police dispatcher looking to expand your horizons and take on more hours?Join the Belmont Police Department team as a Per Diem Police DispatcherOur ideal candidate is an individual... 

Sterling Engineering

Environmental Health Safety Specialist Job at Sterling Engineering

 ...supporting a global electrical manufacturer looking for a highly experienced Environmental & Safety Specialist to step in and lead EHS initiatives at their Palatine facility. This is an ideal opportunity for a seasoned professional whos confident operating independently... 

Element Care

Van Driver - Mandarin Preferred Job at Element Care

Great Life work Balance position with excellent benefits! The Driver is responsible for driving and transporting participants around the community and to medical appointments as needed. The pay is $20 hourly. This is a full-time position, Monday- Friday 8-4 position;...

Ultimate Staffing

Medical Assistant Job at Ultimate Staffing

 ...Assists physicians and clinical staff by performing administrative and basic clinical tasks. Responsibilities include scheduling appointments...  ..., taking vital signs, preparing patients for exams, updating medical records, administering medications as directed, and supporting... 

Duane Morris LLP

Conflicts and Business Intake Compliance Counsel Job at Duane Morris LLP

JOB TITLE: Conflicts and Business Intake Compliance Counsel DEPARTMENT: Office of General Counsel OVERVIEW : Duane Morris LLP, a global law firm with 900+ attorneys in offices across the U.S. and around the world, offers innovative solutions to the legal and...