**Company description** At Saatchi we believe in creating ideas that can live anywhere. And we believe that when we work as a team, nothing is impossible. We strive to bring out the best in each other and in ourselves and expect applicants to understand the value of close collaboration. We also believe that creating transformational work requires initiative, an entrepreneurial spirit and a bold commitment to achieving measurable results and business success for the Clients we service. Saatchi & Saatchi currently maintains a hybrid work policy to work in-office three days per week and remotely the other two days each week. **Overview** As a Freelance Data Engineer, you will be responsible for building the infrastructure to leverage key data sources. Success for this position is measured by the ability to automate data processes and ensure flawless execution, maintain the accuracy and consistency of data, innovate processes and teams via industry changes and new tools, deliver high-quality reporting in a timely fashion and with little to no supervision, and present the material both internally and externally. An ideal candidate will have hands-on experience working with ETL technologies, data visualization and reporting technologies (Tableau), and be proficient in driving insights from large complex data sets. **Project Scope:** + Initial setup: Estimated 3-4 months + Potential ongoing maintenance and consultation **Responsibilities** **Roles and Responsibilities include:** + Design and implement scalable data architecture for both clickstream and survey data + Create efficient ETL/ELT pipelines with proper monitoring and error handling + Build aggregated tables from raw clickstream data optimized for specific use cases + Implement survey data standardization logic while maintaining flexibility for survey-specific variations + Set up proper data governance and access controls for cross-department usage + Provide thorough documentation and knowledge transfer **Qualifications** **Ideal candidate experience should include:** + Strong experience with data warehouse design and implementation + Expertise in building ETL/ELT pipelines for large-scale data + Experience with clickstream data processing and optimization + Proficiency with SQL and at least one programming language (Python preferred) + Experience with data modeling and schema design + Ability to translate between technical and business requirements + Experience working with marketing/advertising data + Strong communication skills and ability to surface technical decisions that impact business outcomes + Experience working with survey data and understanding of its nuances + Proactive approach to gathering business context and requirements **Additional information** Our Publicis Groupe motto “Viva La Différence” means we’re better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent. Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off. 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: $75 - $85/hourly rate. 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 February 28, 2025.