DataOps Analyst: Elevate Data Quality & Automation

Publicis Groupe; Chicago (IL); On-site; USD 55,765 - 82,208; Full time

Job summary

Publicis Groupe in Chicago is seeking a data-focused professional to design and implement business rules for data processing. You will set up dataflows, maintain SQL scripts, and collaborate with data engineers to ensure accurate specifications and high data quality.

The role emphasizes governance, reporting, and ongoing improvement in a fast-paced digital marketing environment, with exposure to SQL, BI tools, and cloud platforms.

Qualifications

• 1-2 years of applicable experience.
• A four-year college degree; advanced degree is a plus.
• Strong attention to detail.
• Excellent oral and written communication skills.
• Passion for problem solving, data automation and finding efficiencies in current processes.
• Passion for digital marketing, eagerness to learn in a constantly changing space, and a natural curiosity.
• Proficient with SQL and data visualization tools (e.g. Tableau, PowerBI, Google Data Studio).
• Knowledge and experience with Python and/or R a plus.
• Experience with tools like Alteryx a plus.
• Experience working with Google Cloud and AWS a plus.
• Comfortable in a fast-paced and deadline-driven environment.
• Familiarity with prompt-based interaction and generative AI tools (e.g., ChatGPT, Google Gemini, DALL·E, Midjourney) is a plus.

Responsibilities

• Analyzing data and consulting with subject matter experts to design and develop business rules for data processing.
• Setting up and maintaining dataflows in Alteryx or Google Dataprep.
• Creating and maintaining SQL scripts.
• Collaborating with data engineers to ensure specifications are understood and followed.
• Monitoring, troubleshooting, and remediating data quality across marketing data systems.
• Designing and executing data quality checks.
• Keeping up to date on digital media operations and partner/buy changes.
• Managing data governance, processing, and reporting.
• Governing taxonomy additions, application, and use.
• Serving as a knowledge expert for operational processes and identifying areas for improvement.
• Evaluating opportunities for simplification and automation for reporting and processes.

Skills

SQL

Data visualization

Python/R

Alteryx

Cloud (GCP/AWS)

Communication

Attention to detail

Problem solving

Data automation

AI tools familiarity

Education

Bachelor's degree

Advanced degree helpful

Tools

Alteryx

Tableau/Power BI/Data Studio

Google Data Studio

Google Cloud

AWS

Job description

Publicis Groupe in Chicago is seeking a data-focused professional to design and implement business rules for data processing. You will set up dataflows, maintain SQL scripts, and collaborate with data engineers to ensure accurate specifications and high data quality.

The role emphasizes governance, reporting, and ongoing improvement in a fast-paced digital marketing environment, with exposure to SQL, BI tools, and cloud platforms.