MarTech Data Engineer – Marketing 360 Data Layer

Key Skills

Apache Cassandra, Apache Hive, Database, DynamoDB, Effective communication skills, GraphQL, MongoDB, NoSQL, Presto, SPARK Programming, SQL

Job Description

The MarTech Platforms group is an enterprise team that empowers Vanguard’s marketing divisions to reach their audiences in more meaningful and relevant ways, driving incremental business value with personalized, data-driven, contextually relevant experiences. The Data Engineer, MarTech Data Layer is a key role responsible for leveraging marketing data across the enterprise to enable better experiences and outcomes for our investors via personalization, segmentation, targeting and measurement. You will use your knowledge of this data to inform data sets and schema designs for raw data collection, semantic data layer/product design, and Identity Resolution (IDR) and Customer Data Platform (CDP) schema design to power marketing activation, personalization and analytics use cases. You will transform large and disparate data sets into rocket fuel for marketers to create highly targeted customer audiences for personalized customer experiences. 

In this role, you will:

• Work with marketers and product owners to elicit, understand and develop a comprehensive understanding of customer and marketing data requirements and use cases, including how data is created, collected, and consumed across various Vanguard’s digital marketing channels.
• Design and develop semantic data models and enrich the analytical data sources for further usability and availability that aligns with marketing activation and analytical use cases by adopting advanced & cutting-edge technology in the cloud.
• Document data structures, including metadata within Collibra
• Collaborate with PO and MarTech Data engineering teams to design and build standardized marketing data products that align with marketing requirements and use cases. 
• Collaborate with IDR and CDP developers to define data sets for identity resolution and activation from the CDP, to ingest and extract data into the IDR & CDP to support data collection in the marketing data lake
• Ensure data quality and optimizes data availability. Monitor data pipelines for accuracy, missing data, enhancements, changes, and billing volumes to ensure all data is captured and processed accurately and when needed.
• Enable greater reliability, adaptability, and speed by leveraging techniques from SRE and DevSecOps practices in your data and analytics work.
• Create clear and concise documents that helps readers understand how the code works, the technical procedures, and can be leveraged as training material.

What it takes:

• 5+ years’ experience data modeling, building data warehouses, marts and lakes in the cloud
• Exposure to Modern Marketing or MarTech platforms (Adobe, Salesforce Marketing Cloud, Unica/Interact) and related data preferred
• 2+ years of experience working with various data sets and designing semantic data layers to meet marketing use cases
• Understanding of how to utilize customer interaction data for activation, personalization and analytics would be a plus
• Experience in cloud technologies and patterns (AWS, Azure, GCP)
• Worked on cloud Big Data technologies (AWS EMR, S3, Glue ETL, Athena, AWS Step Functions, AWS Lambda, Cloud Formation templates, Cloud Watch Logs, Splunk, Ansible, etc.)
• Experience with scripting languages and platforms such as Spark, Python, R, SQL, JSON, XML, etc.
• Product mindset to understand business needs and come up with scalable engineering solutions. You have a strong background in building distributed data pipelines.
• The ability to work collaboratively in a creative and Agile environment including full application lifecycle from technical design to development, testing, and deployment
• The ability to manage multiple concurrent projects and able to be flexible and adapt to changes
• Strong process knowledge and orientation to deliver business outcomes
• Strong written and verbal communication skills. The ability to present to technical and non-technical CDP and IDR platform users and stakeholders
• Demonstrated ability to achieve results while working in a cross-functional environment

What Sets You Apart: (nice to have)

• Prior experience in marketing or MarTech
• 5+ years of experience data modeling, building data warehouses, data marts and data lakes
• 5+ years working with relational (SQL) and NoSQL databases (DynamoDB, Casandra, CouchDB/Couchbase, MongoDB)

• 3+ years working with big data (Hive, Presto DB, Spark SQL, EMR, Cloudera) data management platforms
• Experience with audience management or campaign management platforms such as Unica/Interact, Adobe Audience Manager, Salesforce Audience Builder
• Experience with email platforms, Salesforce Marketing Cloud preferred
• Experience with web analytics platforms, Adobe Analytics ideally
• Conceptual and physical database modeling
• Familiarity with graphQL
• Familiarity working with Collibra or similar data cataloging solutions
• Strong written and verbal communication skills. The ability to present to technical and non-technical CDP and IDR platform users and stakeholders.
• 10+ years related work experience

Special Factor

Vanguard is not offering visa sponsorship for this position.

About Vanguard

We are Vanguard. Together, we’re changing the way the world invests.

For us, investing doesn’t just end in value. It starts with values. Because when you invest with courage, when you invest with clarity, and when you invest with care, you can get so much more in return. We invest with purpose – and that’s how we’ve become a global market leader. Here, we grow by doing the right thing for the people we serve. And so can you.

We want to make success accessible to everyone. This is our opportunity. Let’s make it count.

Inclusion Statement

Vanguard’s continued commitment to diversity and inclusion is firmly rooted in our culture. Every decision we make to best serve our clients, crew (internally employees are referred to as crew), and communities is guided by one simple statement: “Do the right thing.”

We believe that a critical aspect of doing the right thing requires building diverse, inclusive, and highly effective teams of individuals who are as unique as the clients they serve. We empower our crew to contribute their distinct strengths to achieving Vanguard’s core purpose through our values.

When all crew members feel valued and included, our ability to collaborate and innovate is amplified, and we are united in delivering on Vanguard's core purpose.

Our core purpose: To take a stand for all investors, to treat them fairly, and to give them the best chance for investment success.