Data Engineer, Data & AI Platforms

About the role

Zeno Group is hiring its first dedicated data engineer. The role is full-time and reports into Zeno's AI & Innovation practice.

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.
• 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.

Requirements

• 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.

Qualifications

• 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.

Skills

• Hands-on data engineering experience.
• Experience with cloud data warehouses and modern tooling.
• Understanding of ETL/ELT patterns.
• Python for data work.
• AWS experience preferred.
• Ability to hold your own in architecture conversations.
• Strong communication skills, especially with analytically strong teammates.
• Familiarity with and curiosity about LLM tooling, vector databases, or document processing pipelines.

Benefits

• Healthy, happy employees make Zeno better, so we have programs that support physical, mental and financial wellness.
• We offer a variety of medical, dental and vision insurance with prescription plans, as well as short and long-term disability.
• The 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.
• We encourage employees to bring their authentic self to Zeno and participate in our employee resource groups which build communities for sharing and support.
• We support work/life balance with generous vacation, paid holidays and self-care time.
• We offer a 401(k) plan, pretax flexible spending accounts, tuition assistance, life insurance and free access to a certified financial coach.
• We provide a monthly allowance to fund activities in your personal life that bring you joy and keep you healthy.

Pay

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

Schedule

Full-time