SQL Data Programmer

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 were untethered from any specific medium or methodwe go where ideas will work best.

We are an expanding network with more than 5000 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.

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.

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

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

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

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

#LI-AB1