**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. **Overview** This role is responsible for the development, monitoring, and maintenance of dbt and BigQuery SQL data pipelines and tests. They apply knowledge of internal processes, data best practices, and dashboard and reporting requirements to contribute to the organization's data products. In this role, you will learn how to drive, govern, and automate CRM marketing analytics capabilities with a modern data stack (dbt, Tableau, BigQuery, git). The successful candidate possesses a high level of attention to detail and a growth mindset and easily translates business inquiries into actionable technical solutions. **Responsibilities** + Use dbt and BigQuery to develop, document, govern, and maintain data pipelines supporting Tableau dashboards and reporting capabilities + Transform and aggregate raw data for data visualization and interpretation, troubleshooting inconsistencies or anomalies + Employ test driven development; utilize, develop, and maintain integration tests and CI/CD practices in both development and production environments + Thoroughly explore large data sets to identify major and minor trends as well as important distributions over time or by specific features + Test hypotheses based on exploratory data analyses; independently evaluate these hypotheses and surmise if they can be proven or disproved with available data + Independently problem solve, troubleshoot issues in dbt, SQL, Tableau, git, etc. + Collaborate effectively with cross-functional team members to understand data needs and develop meaningful solutions. + Contribute to team’s future capabilities by thoroughly documenting processes and building automations **Qualifications** + 1+ years of experience in analytics engineering, data analytics, data science, data engineering, computer science or a closely related field + Excellent communication and interpersonal skills with the ability to explain complex technical concepts to non-technical stakeholders + Extreme detail orientation without perfectionism + Growth mindset and high aptitude for learning + Strong desire to take ownership of business processes and pride in work **Extra Credit** + 1+ years of experience using dbt or another data governance tool (Great Expectations, Monte Carlo, etc.) in a business context a strong plus + Experience using SQL and/or BI software to explore, aggregate, clean, analyze, and/or audit data + Experience using Python or another coding language for analysis and/or to automate tasks + Experience using git to version control files and/or code + Obsession over documentation and futureproofing of work products **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 USMSTACompliance@publicis.com. All your information will be kept confidential according to EEO guidelines. Compensation Range: $54,910 to $72,300 per year. 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. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 8/1/2025.