Analyst, Data Engineering

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, and the Publicis Commerce Exchange.

Job Description

As an Analyst, Data Engineering you will assist in the design, development, and maintenance of business intelligence capabilities with a focus on SQL and Python as tools to support automated pipelines. Your understanding of data structures and pipelines will be beneficial for contributing to the organization’s data-driven decision making. You will also assist in shaping the data architecture and contribute to insights that impact business outcomes.

Your Responsibilities:

• Assist in conceptualizing, developing and documenting data pipeline architecture to support reporting tools.

• Support in creating automated reporting backends with a high level of efficiency and accuracy in GCP and Teradata.

• Develop a functional understanding of the client data, its nature, and documentation.

• Assist in maintaining existing processes in production, optimizing its code and creating additional documentation.

• Collaborate effectively with team members to understand data needs and develop meaningful solutions.

• Help in automating quality assurance and data processes to ensure accuracy and efficiency.

Qualifications

• 0-1 Years of relevant experience or an understanding of Google Cloud services such as BigQuery, GCS, Cloud SQL, ML, DataStudio.

• Basic knowledge and experience in SQL and Python.

• Experience or familiarity with building and optimizing ‘big data’ data pipelines, architectures, and data sets in GCP is beneficial.

• Tableau Front-end and Backend development experience or knowledge is a plus.

• Ability to analyze data to identify issues and inconsistencies.

• Interest in understanding consumer behavior.

• Good communication and interpersonal skills, with the ability to explain technical concepts to peers.

• Familiarity with version control software (Git) and willingness to learn technical documentation.

• Knowledge of data testing in DBT and Google Cloud certifications are a plus but not required.

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:

• Paid Family Care for parents and caregivers for 12 weeks or more
• 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.

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 [email protected].

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

Compensation Range: $52,500 – $83,500 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. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.