This is an exciting opportunity to join a growing organization within UPS, leveraging new technologies to help make UPS's marketing efforts more data and analytics driven. The Digital Data Platform team partners with campaign owners, channel owners, media agencies, data scientists, and IT to develop new audiences and deliver them to the activation platforms that support the targeting and personalization of all channels, including ups.com, paid media, and email. In addition, the team ensures that quality performance data is captured and tools are developed to support digital performance reporting and audience insights mining.

The Digital Data Engineer is responsible for the continued development and optimization of the company’s Customer Data Platform (CDP) in support of Marketing business objectives. He/She leads the collection, cleaning, and transformation of data from multiple channels into the Customer Data Platform in support of the segmentation, analytics, reporting, and activation needs of marketers and agencies. This position leads development of new data engineering and data activation processes, and oversees the delivery of high quality data to agency media buying platforms, the ups.com personalization platform, and other programmatic activation platforms. He/She interacts regularly with IT on development of new ETL (Extract, Transform, and Load) jobs, maintenance, and troubleshooting. The Digital Data Engineer also provides key input in support of the overall digital marketing data architecture.

RESPONSIBILITIES AND DUTIES

• Designs and develops Extract, Transform, and Load (ETL) processes within Customer Data Platform in support of the segmentation, analytics, and reporting needs of the business
• Develops processes to clean and transform data into the processed data store within the Customer Data Platform and build aggregated views in the analytical data store in support of reporting and business intelligence needs of Marketing stakeholders
• Develops automated quality assurance processes to monitor quality of inbound data and ensure the continued accuracy of data processing within the platform
• Develops and manages data processing jobs to assign customers to marketing segments in the Customer Data Platform using demographic data, behavioral data, and intent signals and works with data scientists to incorporate machine learning outcomes into the overall customer segmentation model
• Leads projects with marketing stakeholders, software vendors, media agencies, IT, and data owners to specify and execute new data feeds into the Customer Data Platform from internal repositories, digital marketing applications (web analytics, data warehouse, etc.), and advertising platforms

KNOWLEDGE AND SKILLS

• Strong technical knowledge of Hadoop and Spark ecosystem, including Hive, HBase, Cassandra, Sqoop, and Oozie 
• Strong knowledge of data modeling principles and best practices in building analytics repositories in SQL and NoSQL environments
• Strong coding skills in SQL, Spark, and Python
• Ability to diagnose and troubleshoot complex data quality issues
• Ability to translate marketing stakeholder requirements into technical specifications
• Experience building and managing data pipelines and repositories in cloud environments such as Microsoft Azure

Founded on a $100 loan in 1907, 2 teenage boys opened up a messenger service in a 6 by 17 foot office located just below the sidewalk on Second Avenue and Main Street in Seattle, WA. Messengers ran errands, carried notes, hand baggage, and delivered trays of food for customers. They also delivered packages, traveling by streetcars and bicycles for longer trips, and later using motorcycles.