SQL Data Programmer

Publicis Groupe Holdings B.V; West Chicago (IL); On-site; USD 56,000 - 77,000; Full time

Benefits offered by this job

Flexible working arrangements

Paid time off

Medical and voluntary benefits

Job summary

Publicis Digital Experience in the United States is seeking a Data Programmer II to translate campaign requirements into data processes and write SQL for ETL workflows.

You will develop QC reports and ensure campaign accuracy, while collaborating with project managers and account teams to meet aggressive deadlines.

Qualifications

• 5+ years data programming experience with focus on SQL development and data processing
• Proficiency in Microsoft SQL Server and Transact-SQL
• Strong understanding of data modeling and ETL
• Ability to translate requirements to technical specs
• Knowledge of data security and compliance

Responsibilities

• Translate client marketing requirements into technical specs and executable processes with teams
• Write, modify, and implement SQL queries, stored procedures, and scripts for ETL
• Design and implement data streams with data hygiene and transforms
• Develop QC reports to confirm data accuracy and impact of changes
• Manage campaigns through completion with timelines and risk communication
• Understand database architecture and existing code to implement logic

Skills

SQL development

ETL

Data processing

Quality control

Communication

Tools

Microsoft SQL Server

Transact-SQL

Data orchestration tools

Databricks

Job description

Company description

A division of Publicis Groupe, Publicis Digital Experience is a network of top-tier agencies designed to develop capabilities and solutions to enable growth and provide scaled access to the digital capabilities of Publicis Groupe in service of our clients. Together, the Publicis Digital Experience portfolio endeavors to create value at the intersection of technology and experiences to connect brands and people.

Our model to transform every brand experience will help clients navigate, develop, and activate commerce in a way that will provide them with a future-proof model for modern marketing. With our unique expertise in consumer engagement, CRM, and commerce, Publicis Digital Experience powers brands and empowers people in a new era of creativity. An ever-changing landscape and the need for fluid thinking is just part of our problem-solving nature. Which means we're untethered from any specific medium or method—we go where ideas will work best.

We are an expanding network with more than 5,000 employees, with agency brands throughout our global offices. Publicis Digital Experience brands include Razorfish, Digitas, Arc Worldwide, Saatchi Saatchi X, Plowshare, 3Share, Epsilon Auto and the Publicis Commerce Exchange.

Overview

The Data Programmer II serves as a technical liaison between client business requirements and marketing campaign execution. This role focuses on translating campaign specifications into data processes, writing SQL code for ETL workflows, and developing quality control reports to ensure campaign accuracy and compliance. The Data Programmer will be able to translate marketing campaign requirements against technical best practices and will determine the solution that provides the best combination of functionality, performance, and ease of maintenance. The candidate must have the ability to self-direct, set goals, and meet aggressive deadlines. This is a key factor in the overall success of the Auto/Direct organization. This is a production-oriented marketing data processing role that combines SQL programming, campaign execution, and quality control.

Responsibilities

Duties/Responsibilities:

• Translate client marketing requirements into technical specifications and executable processes, collaborating with project managers and account teams to clarify requirements and communicate technical constraints or data availability
• Write, modify, and implement SQL queries, stored procedures, and scripts that interface with data orchestration tools for campaign extraction, transformation, loading (ETL), and processing
• Design and implement data streams that incorporate data hygiene, merge/purge, and transformations
• Develop quality control (QC) reports and validation processes to confirm data accuracy, expected output, and the impact of changes before campaign deliverables are released
• Manage assigned campaigns through completion by following documented processes and sequencing, meeting agreed timelines, and communicating risks, blockers, or potential delays promptly
• Understand database architecture, modeling, ETL, SQL, database access tools, and existing codebases to implement campaign-specific logic
• Support implementation of marketing automation, campaign orchestration, and operational data processing solutions
• Document data processes and QC findings, adhere to production standards, and help refine standards that improve quality and productivity
• Provide requirements to the technology delivery group to improve product integration, internally developed infrastructure components, and application templates based on project experience
• Participate in code review and acceptance process to improve methodology and delivery

Qualifications

Skills:

• Ability to read, understand, adapt, and document existing SQL queries, stored procedures, ETL processes, and database structures to meet campaign requirements
• Strong analytical, problem-solving, and quality control skills with the ability to identify relevant facts, troubleshoot issues, and prevent data quality problems
• Ability to effectively manage, prioritize, and execute multiple concurrent campaigns within tight project deadlines
• Strong listening and communication skills; ability to capture requirements from non-technical stakeholders and translate them into technical specifications
• Understanding of data quality best practices, including deduplication, data hygiene, validation, and clear QC reporting for technical and business audiences
• Flexible, self-directed, and able to independently learn and understand the business purpose, expected outputs, dependencies, and QC requirements of assigned campaigns and processes

Technical Requirements:

• 5+ years data programming experience with focus on SQL development and data processing
• Proficiency in Microsoft SQL Server and Transact-SQL, including the ability to write, understand, and modify queries, stored procedures, and existing production processes. Experience with CTEs, query optimization, and other advanced SQL techniques is beneficial
• Solid understanding of relational database concepts, SQL, and data modeling techniques
• Experience writing and maintaining SQL queries for data extraction, transformation, campaign processing, and quality control reporting
• Knowledge of data security, data transfers, and compliance best practices
• Experience with data hygiene and merge/purge applications
• Ability to leverage AI tools (MS Copilot, Cursor, Kiro) to enhance productivity in code development, debugging, and documentation

Preferred Qualifications:

• Experience in marketing or automotive industry
• Experience with or familiarity with Databricks is beneficial; familiarity with Oracle Database or Snowflake is also helpful
• Experience working with Azure cloud platform and Visual Studio Code
• Demonstrated experience working on teams in a matrix organization structure
• Familiarity with workflow management or marketing automation systems

Additional information

The Power of One starts with our people! To do powerful things, we offer powerful resources. Our best-in-class wellness and benefits offerings include:

Monetary assistance and support for Adoption, Surrogacy and Fertility

Monetary assistance and support for pet adoption

Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance

Tuition Assistance

Paid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more

Matching Gifts programs

Flexible working arrangements

Work Your World' Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)

Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to eligible U.S. Based employees, are reviewed on an annual basis, and are governed by the terms of the applicable plan documents.

We also offer medical and voluntary benefits to our freelancers and temporary employees. Voluntary benefit options include supplemental medical insurance, transportation, and parking benefits, legal benefits, pet insurance, and auto and home insurance.You must be actively employed for 90 consecutive calendar days in order to be eligible for Publicis medical and voluntary benefits.

You must be work authorized in the United States on a full-time basis without the need for employer sponsorship now or in the future. The Company cannot offer employment to F-1 (student) visa holders who require employer sponsorship in the future or cannot work now on a full-time basis.

Publicis Digital Experience is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race, color, ethnicity, religion, creed, sex, sexual orientation, gender, gender identity, gender expression, pregnancy, childbirth and related medical conditions, national origin, ancestry, citizenship status, age, disability, medical condition as defined by applicable state law, genetic information, marital status, military service and veteran status, or any other characteristic protected by applicable federal, state or local laws and ordinances.

If you require accommodation or assistance with the application or onboarding process specifically, please contact [e-mail].

All your information will be kept confidential according to EEO guidelines.

#LI-AB1

Compensation Range: USD $55,765.00 - USD $77,070.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 10/24/2026.