Junior Data Engineer

Agility Partners; Cincinnati (OH); On-site; USD 60,000 - 80,000; Full time

Job summary

A data solutions firm is hiring two Junior Data Engineers to join an Insights squad aimed at modernizing a core data ecosystem. The ideal candidates will use their strong SQL skills to validate and transform data while gaining hands-on experience with Snowflake and dbt. Responsibilities include running monthly data product refreshes and supporting pipeline modernization efforts. This role offers a chance to grow in data engineering and contribute to critical enterprise capabilities.

Qualifications

• Comfort with complex SQL queries.
• Experience cleaning, transforming, validating, and analyzing data.
• Basic understanding of data science workflows.

Responsibilities

• Run monthly Householding data product refreshes end-to-end using established playbooks and tooling.
• Build a strong understanding of the HH data domain and platform architecture.
• Support pipeline modernization efforts.

Skills

Strong SQL abilities

Data cleaning and transformation

Basic understanding of relational databases

Tools

Snowflake

dbt

Python

Job description

We’re hiring two Junior Data Engineers to join an Insights squad focused on modernizing and transforming a core Householding (HH) data ecosystem. This team is driving a multi‑year effort to retire legacy systems and deliver a modern, scalable, hybrid data product that supports evolving consumer needs. Householding is a foundational enterprise capability—critical for understanding customer relationships, improving segmentation, and accurately measuring growth. In this hands‑on role, you’ll gain high visibility and play a key part in delivering the next‑generation HH architecture.

Responsibilities

• Run monthly Householding data product refreshes end‑to‑end using established playbooks and tooling
• Build a strong understanding of the HH data domain, business rules, and platform architecture
• Support pipeline modernization efforts and contribute to remediation activities (e.g., orphaned customer accounts)
• Apply SQL skills to validate, transform, and reconcile source‑to‑target data
• Gain hands‑on experience with Snowflake and dbt during refresh cycles and ongoing enhancements
• Gradually take on more complex data engineering tasks as you ramp up

The Ideal Candidate

Required Skills

• Strong SQL abilities, including comfort with complex queries
• Basic understanding of relational database concepts
• Experience cleaning, transforming, validating, and analyzing data

Nice to Have

• Exposure to Snowflake
• Familiarity with dbt (data build tool)
• Experience with Python
• Basic understanding of data science workflows or concepts