Senior, Data Engineer

Publicis Groupe; Chicago (IL); Hybrid; USD 146,000 - 182,000; Full time

Benefits offered by this job

Comprehensive health coverage

401(k)

Tuition assistance

Commuter benefits

Professional development

Employee recognition

Charitable donation matching

Health coaching and counseling

Job summary

Publicis Groupe in Chicago is seeking a Senior Data Engineer to develop and optimize AI-enabled data pipelines on AWS, including PySpark ETL and SQL-driven transformations on Greenplum. You will build scalable data products, ensure data quality, and implement secure, auditable CI/CD workflows.

The role requires a Master’s degree with 2+ years experience and offers hybrid work with on-site days in Chicago. Compensation ranges from USD 145,870 to USD 182,000 annually.

Qualifications

• Master’s degree in Computer Science, Information Technology, Engineering or related field and two years of experience in the job offered or two years in any occupation with required experience.

Responsibilities

• Develop and execute software tests; write and optimize SQL scripts and Python scripts for large-scale transformations on Greenplum.
• Design and maintain AI-enabled PySpark data pipelines on AWS (EMR, Glue, Athena, DynamoDB, S3).
• Harden and tune jobs for performance, cost, and compliance; manage data partitioning, cataloging, and lineage.
• Automate deployments with CloudFormation; schedule batch workloads for timely pipelines.
• Build internal dashboards and data products; instrument monitoring and alerting to catch issues early.
• Translate client tickets into clear technical tasks; ensure data quality with tests and UAT evidence.
• Apply security and data-governance controls with encryption and IAM least privilege.

Skills

PySpark ETL on AWS EMR/Glue

SQL on Greenplum/Postgres

Python scripting

CloudFormation / IaC

CI/CD with AWS CodeCommit/CodeBuild/Ch

AWS Glue Data Catalog

Athena / S3 / DynamoDB

IAM & KMS security controls

GenAI with AWS Bedrock

AWS Amplify

Education

Master’s degree in CS/IT/Engineering or related field

Tools

AWS EMR

DynamoDB

Athena

S3

Job description

Company Description

See how Epsilon powers connected marketing by unlocking the full potential of data and identity.

Overview

Employer: Epsilon Data Management LLC

Job Title: Senior, Data Engineer

Job Requisition: 6630.7950.6

Job Location: 35 West Wacker Drive, Chicago, IL 60601. Required to work from Company Office in Chicago IL certain days per week. Telecommuting allowed for balance of week.

Job Type: Full Time

Responsibilities

Duties: Develop and execute software tests to identify software problems and their causes. Write and optimize complex SQL Scripts and build Python scripts to execute large-scale transformations on Greenplum. Create test plans, run rigorous unit/integration tests, and deliver reproducible, well-documented results. Design and maintain AI-enabled, PySpark data pipelines on AWS primarily EMR, Glue, Athena, DynamoDB, and S3 to process large datasets at scale. Harden and tune jobs for performance, cost, and compliance, and manage data partitioning, cataloging, and lineage. Automate deployments and infrastructure with CloudFormation and parameterized configurations, and schedule batch workloads to keep pipelines timely and reliable. Build internal dashboards and data products (e.g., Amplify apps) and instrument monitoring/alerting to catch issues early. client tickets, translating ambiguous requests into clear technical tasks.

Qualifications

Requirements: Employer will accept a Master’s degree in Computer Science, Information Technology, Engineering or related field and two years of experience in the job offered or two years in any occupation in which the required experience was gained.

Position requires two years in the following:

1. Build PySpark ETL on AWS EMR/Glue reading/writing S3 (partitioning, predicate pushdown, broadcast joins) to deliver analytics-ready fact/dimension tables on schedule.
2. Author and tune complex SQL on Greenplum/Postgres (window functions, ROW_NUMBER dedupe, distribution keys, AO/AOCO compression, VACUUM/ANALYZE) to process large datasets efficiently.
3. Manage AWS Glue Data Catalog and query curated layers with Athena; design S3 layouts (prefix/partition strategy, lifecycle policies) to cut query time and storage cost.
4. Implement CI/CD with CodeCommit, CodeBuild, and CodePipeline; parameterize environments and use CloudFormation for IaC to enable repeatable, auditable, and fast rollbacks.
5. Engineer observability with CloudWatch logs/metrics/alarms and job health checks, create SLA dashboards and alerting to detect failures early and reduce MTTR.
6. Enforce data quality via SQL/Python unit tests, reconciliation (row counts, sums, duplicates), referential-integrity checks, and documented UAT evidence for change control.
7. Apply security and data-governance controls: normalize and encrypt sensitive identifiers, use KMS-managed keys, and enforce IAM least privilege with audit logging.
8. Develop GenAI-assisted delivery integrates LLMs (AWS Bedrock) with PySpark/SQL to auto-suggest transformations, generate test cases, and summarize validation results.
9. Build lightweight internal data apps with AWS Amplify + DynamoDB/Athena to manage lookup keys/brand lists and enable stakeholder self-service with controlled access.

Required to work from Company Office in Chicago IL certain days per week. Telecommuting allowed for balance of week.

Additional Information

When you join Epsilon, we’ll create something EPIC together.We’re a global leader in data and identity, with deep expertise in digital media, clean rooms, customer data platforms, loyalty and marketing services. Positioned at the center of Publicis Groupe, Epsilon helps brands deliver personalized experiences at scale and build lasting customer relationships by unlocking the full potential of data and identity. Epsilon operates in 30+ countries across EMEA, the Americas and APAC, with more than 8,000 employees.

Check out a few of these resources to learn more about what makes Epsilon so EPIC:

Our Culture: https://www.epsilon.com/us/about-us/our-culture-epsilon

Life at Epsilon: https://www.epsilon.com/us/about-us/epic-blog

Epsilon has five values that define our culture and guide us as we create value for our clients, our people and consumers. We seek candidates who align with our company values, demonstrate them and make them meaningful in their day-to-day work:

• Act with integrity. We are transparent and have the courage to do the right thing.
• Work together to win together. We believe collaboration is the catalyst that unlocks our full potential.
• Innovate with purpose. We shape the market with big ideas that drive big outcomes.
• Respect all voices. We embrace differences and foster a culture of connection and belonging.
• Empower with accountability. We trust each other to own and deliver on common goals.

Because You Matter

As an Epsilon employee, you deserve perks and benefits that put you, your family and your finances first. Our benefits encompass a wide range of offerings, including but not limited to:

• Time to recharge: Flexible time off (FTO), 14 paid holidays, paid sick time
• Family well-being: Parental/new child leave, childcare & elder care assistance, adoption assistance
• Extra perks: Comprehensive health coverage, 401(k), tuition assistance, commuter benefits, professional development, employee recognition, charitable donation matching, health coaching and counseling

Epsilon benefits are subject to eligibility requirements and other terms.

Epsilon is an Equal Opportunity Employer. Epsilon’s policy is not to discriminate against any applicant or employee based on actual or perceived race, age, sex or gender (including pregnancy), marital status, national origin, ancestry, citizenship status, mental or physical disability, religion, creed, color, sexual orientation, gender identity or expression (including transgender status), veteran status, genetic information or any other characteristic protected by applicable federal, state or local law. Epsilon also prohibits harassment of applicants and employees based on any of these protected categories. Epsilon will provide accommodations to applicants who need accommodations to complete the application process. Please reach out to [e-mail] to request an accommodation.

For San Francisco Bay and Los Angeles Areas: Epsilon will consider qualified applicants with criminal histories for employment in a manner consistent with the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance and San Francisco Police Code Sections 4901-4919, commonly referred to as the San Francisco Fair Chance Ordinance. Applicants with criminal histories are welcome to apply.

Compensation Range: USD $145,870.00 - USD $182,000.00/Annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 1/9/2027.