Data Engineer, Data & AI Platforms

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

Benefits offered by this job

Health, dental, and vision insurance

401(k) plan

Generous vacation and paid holidays

Mental health support through Headspace

Job summary

ZN001 Zeno US is looking for a Data Engineer to join their AI & Innovation team in Chicago. In this role, you will help transition data infrastructure to a modern architecture using AWS, improve existing data pipelines, and support Snowflake migration.

The ideal candidate should have over 6 years of hands-on experience in data engineering, proficiency in SQL, and familiarity with cloud data warehouses. Zeno offers a competitive salary between $150,000 and $200,000.

Qualifications

• 6+ years of hands-on data engineering experience.
• Built pipelines, debugged data issues, and written clean SQL in a production environment.
• Experience with one of Redshift, Snowflake, or BigQuery.

Responsibilities

• Transition data infrastructure to a modern architecture built around AWS.
• Improve and scale existing client data pipelines.
• Support the Snowflake migration.

Skills

Data engineering

SQL

AWS

Python

ETL/ELT patterns

Tools

Snowflake

Fivetran

Tableau

Alteryx

Excel

Job description

Job Overview

Zeno Group is hiring a data engineer to join our team. This role reports into Zeno's AI & Innovation practice and works closely with the Data & Intelligence team. As the first dedicated data engineer at Zeno, you will shape the tools, architecture, and practices that define how the organization works with data going forward.

Responsibilities

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.

Configure Fivetran connectors for paid media data, build pipelines for sources Fivetran doesn't cover, and write 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.

Qualifications

6+ years of hands‑on data engineering experience. You have 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. Understanding of ETL/ELT patterns. Proficient in Python for data work. AWS experience preferred. You can hold your own in architecture conversations and work well with analytically strong teammates. Familiarity with LLM tooling, vector databases, or document processing pipelines is a plus. 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 Technologies

• 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

Location

Chicago

Reporting

Head of AI & Innovation

Compensation

$150,000 - $200,000 USD/yr.

Benefits

Healthy, happy employees make Zeno better, so we have programs that support physical, mental and financial wellness. Our culture and benefits are designed to promote flexibility, celebrate diversity and support work/life balance. We offer a variety of medical, dental and vision insurance with prescription plans, as well as short and long-term disability. Our Be Kind to Your Mind program focuses on mental health, providing a paid subscription to Headspace and access to mental health providers and other services through a best-in-class employee assistance program. Employees are encouraged to bring their authentic self to Zeno and participate in our employee resource groups which build communities for sharing and support. And while we love our work, we believe in the restorative power of time off with generous vacation, paid holidays and self‑care time. Employees are supported in their pursuit of financial wellness with a 401(k) plan, pretax flexible spending accounts, tuition assistance, life insurance and free access to a certified financial coach. And our unique ZenoFit program provides a monthly allowance to fund activities in your personal life that bring you joy and keep you healthy. These and other benefits are available to non‑temporary employees in the US.

Equal Employment Opportunity Statement

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.