Data Engineer, Data & AI Platforms

Zeno Group; Chicago (IL); On-site; USD 150,000 - 200,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

Headspace subscription

401(k) plan

Paid time off

Flexible holidays

Job summary

Zeno Group is hiring its first dedicated data engineer to lead the migration of our data platform to an AWS-centered architecture. You will design the data layer for AI products, build ingestion pipelines, and enable analysts to access clean data for client work.

You will collaborate daily with D&I analysts, participate in architecture and migration decisions, and help scale data workloads while maintaining ongoing client deliverables. This role reports to the Head of AI & Innovation.

Qualifications

• 6+ years of hands-on data engineering experience in production environments.
• Experience with cloud data warehouses (Redshift, Snowflake, or BigQuery) and Python.
• Ability to participate in architecture discussions on schema design and data modeling.
• Familiarity with LLM tooling, vector databases, or document processing Pipelines is a plus.

Responsibilities

• Transition data infrastructure to a modern architecture built around AWS.
• Improve and scale existing client data pipelines while keeping client deliverables running.
• Support Snowflake migration by documenting current schemas and validating the new architecture.
• Build the data layer for AI products, including ingestion pipelines and APIs.
• Create views and clean tables for analysts to query directly without complex SQL.
• Collaborate with analysts and DevOps on migration decisions and client work.

Skills

Data engineering

SQL

Python

AWS

Data modeling

Snowflake

ETL/ELT

Tools

Snowflake

Fivetran

Tableau

Alteryx

Excel

PowerBI

Looker

Job description

Job Description

Data Engineer, Data & AI Platforms

Zeno Group is hiring its first dedicated data engineer. You'll set the technical direction as we rebuild our data platform around AWS, design the data layer our AI products run on, and shape how a global communications agency works with data long after the migration ships.

Half the job is collaboration. You'll work daily alongside our Data & Intelligence (D&I) analysts on live, revenue‑generating client work and be in the room for every architecture and migration decision. The D&I team already runs strong operational data workflows; your job is to grow that foundation into a centralized, AI‑ready architecture without breaking the client work that runs on it today.

The role is full‑time and reports into Zeno's AI & Innovation practice.

The team you're joining

AI & Innovation is a small team building a new practice inside a large organization. We move fast, cover a lot of ground, and hold ourselves to a high standard. A few things define how we work.

Craft over speed. We optimize for doing things well. AI and automation save us real time, and we reinvest those hours into work that's more durable and more useful. A pipeline that's clean, well‑documented, and built to last is worth more than one that shipped yesterday and breaks next week.

Build what others can’t access. We license tools when they solve the problem. But the work that differentiates Zeno is built in‑house: proprietary data systems, AI products, and infrastructure that our clients and teams can’t get anywhere else. You're rebuilding Zeno's data layer for where it needs to go next, not maintaining someone else’s platform.

Makers who can hold a room. This role isn’t heads‑down‑only. You’ll be in architecture conversations, working through migration decisions with the DevOps team, and sitting across from analysts who need you to understand their client context before you build anything. We look for people who are strong technically and comfortable communicating what they know to people who don’t share their vocabulary.

Radical visibility. We’re a small team with outsized scope. There’s no room to go quiet. We surface our work as we go, share what we’re stuck on, flag when we have capacity, and keep each other in the loop without being asked. If you finish something and immediately share it with the team, you’ll thrive here. If you prefer to disappear into your work and surface only when it’s done, this isn’t the right fit.

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, 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

• Preferred location: Chicago
• Reports to: Head of AI & Innovation

Pay Range

$150,000 – $200,000 USD/yr. Pay position within this range is based on factors such as education, qualifications, experience, skills, seniority, location, performance, etc. The range is part of DJEH’s total compensation package, which may also include annual bonuses, Paid Time Off, and region‑specific benefits.

About Our Benefits

Zeno Group focuses on healthy, happy employees, offering programs that support physical, mental, and financial wellness. We provide medical, dental, and vision insurance with prescription plans, short- and long-term disability, mental health resources (including a paid subscription to Headspace and access to providers through an employee assistance program), and a 401(k) plan. Our Be Kind to Your Mind program and unique ZenoFit program offer resources for mental health and financial wellness. We celebrate diversity, promote flexibility, and encourage work/life balance. Employees are encouraged to bring their authentic self to Zeno and participate in employee resource groups and a variety of paid holidays, generous vacation, and self‑care time.

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. We invite all applicants to voluntarily self‑identify their race, ethnicity, and gender. Submission of the information on this form is strictly voluntary and refusal to provide it will not subject you to any adverse treatment. Information obtained will be retained in a confidential file and separate from personnel records. This information may only be used in accordance with the provision of applicable federal laws, executive orders, and regulations. If you want more information about any of the sections, please check with a company representative.