Data Engineer (Contract-to-Hire, Part-Time)

Data Engineer

Zeno Group is hiring a data engineer to join our team on a part-time, contract-to-hire basis (approximately 20 hours per week). This role reports into Zeno's AI & Innovation practice and works closely with our Data & Intelligence (D&I) team daily.

Zeno's D&I team performs both internal and client-facing data work and has built strong workflows to support it. We're investing in data engineering to take those workflows further: migrating to a new architecture, building reusable pipelines, and scaling what works across more clients.

You're joining active, revenue-generating client work with clear opportunities to improve how data moves through the organization.

This is also a role with influence. As the first dedicated data engineer at Zeno, you'll shape the tools, architecture, and practices that define how the organization works with data going forward.

We already have strong operational data workflows in place. This role focuses on scaling and modernizing that foundation into a more centralized, AI-ready architecture.

About the role:

• Transition data infrastructure to a modern architecture built around AWS.
• Improve and scale existing client data pipelines while keeping client deliverables running smoothly.
• Support the Snowflake migration by documenting current schemas, validating that the new architecture preserves existing functionality, and testing with real client data.
• Build the data layer for AI products, including ingestion pipelines, APIs, and programmatic access layers that connect data sources to LLM interfaces.
• Build and maintain data pipelines by configuring Fivetran connectors for paid media data, building pipelines for sources Fivetran doesn't cover, and writing validation and transformation steps.
• Connect data to BI tools by building views and clean tables that analysts can query directly without writing complex SQL.
• Support ongoing client work alongside client-facing analysts, from adjusting tables for new data cuts to standing up pipelines for new clients.

About you:

• 6+ years of hands-on data engineering experience. You've built pipelines, debugged data issues, and written clean SQL in a production environment.
• Comfortable with cloud data warehouses and modern tooling. Experience with at least one of Redshift, Snowflake, or BigQuery. You understand ETL/ELT patterns. Python for data work. AWS experience preferred.
• You hold your own in architecture conversations. You'd be in the room for decisions about schema design, warehouse selection, and data modeling, making sure what gets built serves the team's needs.
• You work well with analytically strong teammates. Our analysts have deep client and data experience from running operations at previous agencies. You need to understand their context and build things the team can maintain and use alongside you.
• Familiarity with and curiosity about LLM tooling, vector databases, or document processing pipelines matters here. Part of this role is identifying where LLMs plug into our data workflows.
• Consulting or agency experience is a plus.

Technical environment:

• Current: Snowflake, Fivetran, Tableau, Alteryx, Excel.
• Target: AWS (Redshift, S3, Lambda), Fivetran, Tray.ai, Tableau/PowerBI/Looker, and Hex.
• Adjacent: Claude/LLM integrations via MCP, custom dashboard development.
• Data types: paid media performance (Meta, Google, TikTok), earned media (Muckrack, Cision), employee engagement event data (Amplitude), creator/influencer campaign data.

Details:

• Part-time contract-to-hire, approximately 20 hours per week.
• Preferred location: Chicago.
• Reports to: Head of AI & Innovation

An employee's pay position within the salary range will be based on several factors including, but not limited to, relevant education, qualifications, certifications, experience, skills, seniority, geographic location, performance, travel requirements, revenue-based metrics, any contractual agreements, and business or organizational needs. The range listed is just one component of DJEH's total compensation package for employees. Other rewards may include annual bonuses, a Paid Time Off policy, and region-specific benefits.

Zeno Group, Inc. provides equal employment opportunities to applicants and employees. Employment decisions are made on the basis of job-related criteria without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, marital status, age, genetic information, national origin, disability, military, or veteran status, or any other classification protected by applicable law.