Data Engineer - Marketing

Company Description

Publicis Sapient is a digital transformation partner helping established organisations get to their future, digitally-enabled state, both in the way they work and the way they serve their customers. We help unlock value through a start-up mindset and modern methods, fusing strategy, consulting and customer experience with agile engineering and problem-solving creativity. United by our core values and our purpose of helping people thrive in the brave pursuit of next, our 20,000+ people in 53 offices around the world combine experience across technology, data sciences, consulting and customer obsession to accelerate our clients’ businesses through designing the products and services their customers truly value.

Job Description

We are looking for a Data Engineer to join our Internal Global Marketing Data and Insights team. The Marketing Data Engineer will help the creation of descriptive and predictive analysis for the Marketing Analytics team. You will develop and maintain processes to move data from source systems into data marts, and ultimately data visualizations/analytics platforms. You will create data pipelines and processes to support Analytics Dashboards and Business Performance Analytics.

You will create new data marts, develop enhancements, and fix defects in existing data solutions to meet business requirements. Meet with stakeholders and gather business and user requirements and use this information to define and develop technical specifications and processes for design, coding, and testing of data products.

You will be a member of the Marketing Technology team and report directly to the Director of Marketing Technology.

Responsibilities:

• Design and build database solutions to aggregate data for identification and analysis, enabling the creation of interactive Dashboards within Business Intelligence tools to help the Marketing Analytics team have a comprehensive view of all marketing lead sources, campaigns and performance.
• Work with data sets from a variety of sources including but not limited to: Salesforce CRM, Marketing Automation Platform (Pardot), Adobe Analytics, Google Marketing Platform, Social Media partners and other AdTech partners.
• Facilitate data integration and transformation requirements for moving data between applications, ensuring interoperability of applications with data mart and CDP environments.
• Engineer scalable data solutions that analysts and stakeholders can use for data visibility needs.
• Support ad hoc requests to extract, transform, and load data sets from existing tools and systems.
• Design and implement automated processes that extract, transform, and load data sets where needed.
• Assist data quality initiatives by engineering solutions to enforce data accuracy and governance policies.
• Recommend additional data products which align with business objectives.
• Work with the privacy and legal teams to ensure the implementations are GDPR, and CCPA compliant.
   

Qualifications

• Bachelor's Degree in Informatics, Computer Science, Digital Marketing, or other relevant field of study.
• 3-5 years of experience in a Data Engineer or related role. A combination of relevant experience and education may be considered.
• Focus on Marketing Data Engineering preferred.
• 2-4 years of experience in scripting languages (like SQL, Python or R) used in extraction, transformation, and loading of large data sets.
• 2-4 years of experience working with modern data technologies stack such as Databricks, Google Big Query, Redshift, RDS, Snowflake or similar solutions.
• Working knowledge of public cloud providers (Google Cloud, Azure, or AWS).
• Exposure to data warehouse technical architectures, infrastructure components, ETL/ ELT, and reporting/analytic tools.
• Experience with ETL tools (Matillion) and dbt (data build tool).
• Experience with analytics and visualization tools such as Google Data Studio, Domo, Tableau, PowerBI, or Datorama.
• Experience with a CDP like Segment, Tealium Audience Stream, or Adobe Real-Time CDP is a plus.
• Experience with Salesforce CRM, and Salesforce Pardot(MAP) is a plus.
• Familiarity with Adobe Analytics and Google Analytics web data sets.
• Ability to manage multiple projects and communicate updates on progress and timelines.
• Ability to communicate complex technical terms in an easy to understand, non-technical manner.
• Ability to interact effectively with cross-functional teams in a results-driven culture.
• Performs all job responsibilities in alignment with the core values, mission, and purpose of the organisation.

Additional Information

What’s in it for you?

• We have got you and your family covered with 25 days paid annual leave (plus bank holidays), life assurance, dental insurance, income protection, critical illness cover, private healthcare for you AND your family (pre-existing conditions included), and a pension
• We know the importance of health and wellbeing so offer you extensive retail discount offers and further reimbursement towards activities that contribute to a healthier lifestyle
• Our beautiful Turnmill office is open
• You can meet over a complimentary barista-made coffee and our teams have been busy replicating face-to-face social activities through learning languages virtually, yoga sessions, having a laugh at our online summer fairs and so much more
• We are proud to actively invest in your learning through various learning platforms
• Diversity and inclusion aren't just buzzwords. We offer an inclusive environment through our inspirational business resource groups and work with you to give back to the local community through CSR efforts

As part of our dedication to the diversity of our workforce, Publicis Sapient is committed to Equal Employment Opportunity without regard for race, colour, national origin, ethnicity, gender, disability, sexual orientation, gender identity, or religion.