Analytics Engineer: Build Scalable, AI-Ready Data Pipelines

Publicis Group; Chicago, Northern (IL, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Publicis Sapient is seeking an Analytics Engineer to design, build, and maintain scalable data pipelines that transform data from marketing platforms, Salesforce, and APIs into reliable datasets for analytics, reporting, and AI-ready use cases.

The role focuses on creating well-structured data assets, ensuring data quality, and enabling downstream analytics with modern cloud platforms and AI tooling, while collaborating across enterprise data environments.

Qualifications

• 5+ years of analytics engineering or similar data-focused role.
• Strong SQL and Python; production-grade pipelines.
• Experience with Snowflake, Databricks, or BigQuery.
• Experience integrating data through REST APIs and Salesforce.

Responsibilities

• Design, build, and maintain scalable data pipelines from marketing platforms, Salesforce, and APIs.
• Develop data transformations and models for downstream analytics and dashboards.
• Create API-based integrations and Python solutions for automated ingestion.
• Ensure data quality, validation, monitoring, and troubleshooting of pipelines.
• Document data definitions, metadata, and data lineage for governance.
• Prepare datasets and docs to support AI/LLM use cases.

Skills

SQL

Python

Data pipelines

REST APIs

Salesforce data

Tools

Snowflake

Databricks

BigQuery

Job description

Publicis Sapient is seeking an Analytics Engineer to design, build, and maintain scalable data pipelines that transform data from marketing platforms, Salesforce, and APIs into reliable datasets for analytics, reporting, and AI-ready use cases.

The role focuses on creating well-structured data assets, ensuring data quality, and enabling downstream analytics with modern cloud platforms and AI tooling, while collaborating across enterprise data environments.