Analytics Engineer: Data Pipelines for AI-Driven Insights

Publicis Groupe ANZ; Chicago, Northern (IL, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Publicis Sapient is seeking an Analytics Engineer to design, build, and maintain scalable data pipelines transforming data from marketing platforms, Salesforce, and APIs into reliable datasets for analytics, dashboards, and modelling.

You will develop transformations and models, integrate data via REST APIs, and ensure data quality and governance while leveraging AI tools to enhance workflows and documentation.

Qualifications

• 5+ years of experience in analytics engineering or a similar data-focused engineering role.
• Strong SQL and Python skills, with experience building and maintaining production-grade data pipelines.
• Hands-on experience with at least one modern cloud data platform such as Snowflake, Databricks, or BigQuery.
• Experience integrating data through REST APIs and other programmatic data sources, including authentication, pagination, error handling, schema changes, and monitoring.
• Experience working with Salesforce data and understanding its underlying data structures and relationships.
• Experience working with marketing data and marketing technology ecosystems, including integrating data across CRM, campaign, digital, media, or customer platforms.
• Strong experience designing pipelines and data models specifically for downstream analytics, dashboarding, reporting, and analytical modelling.
• Understanding of data modelling, warehousing, data quality, governance, and production data engineering best practices.
• Experience with data validation, testing, monitoring, troubleshooting, and maintaining reliable production pipelines.
• Experience creating and maintaining technical documentation, metadata, data definitions, and lineage so datasets are understandable and discoverable.
• Proficiency with modern AI tools and demonstrated ability to incorporate them into day-to-day engineering work, including development, debugging, testing, analysis, and documentation workflows.

Responsibilities

• Design, build, and maintain scalable, reliable data pipelines that ingest and integrate data from marketing platforms, Salesforce, APIs, and other enterprise data sources.
• Develop data transformations and models that provide trusted, well-structured datasets for downstream analytics, reporting, dashboarding, and advanced modelling.
• Build and maintain API-based integrations and custom Python solutions to support reliable and automated data ingestion.
• Ensure data quality, integrity, and availability through validation, testing, monitoring, and troubleshooting of data pipelines and integrations.
• Create and maintain technical documentation, metadata, data definitions, and lineage to improve the discoverability, usability, and governance of data assets.
• Build and structure datasets and documentation to support AI and LLM use cases, while leveraging AI tools throughout development, testing, troubleshooting, and documentation workflows.

Skills

SQL

Python

Data pipelines

REST APIs

Salesforce data

Marketing data

Data modeling

Data governance

AI tools

Tools

Snowflake

Databricks

BigQuery

Job description

Publicis Sapient is seeking an Analytics Engineer to design, build, and maintain scalable data pipelines transforming data from marketing platforms, Salesforce, and APIs into reliable datasets for analytics, dashboards, and modelling.

You will develop transformations and models, integrate data via REST APIs, and ensure data quality and governance while leveraging AI tools to enhance workflows and documentation.