Job description
Job Summary
This position is responsible for the continued development and optimization of the company’s Data Lake and Customer Data Platform (CDP) to support data driven decision making within Marketing. The incumbent leads the collection, cleaning, and transformation of data from multiple channels into the Data Lake and Customer Data Platform in support of the segmentation, analytics, reporting, and activation needs of marketers. This role will be responsible for cultivating new data sources and synthesizing them into the current data lake, enhancing the identity graph as they relate this data. This position is responsible for bringing the strategy/roadmap to life through data engineering and data activation processes, oversees the delivery of high-quality data to marketing stakeholders and data scientists. This role interacts regularly with IT on development of new Extract, Transform, and Load (ETL) jobs, maintenance, and troubleshooting. The incumbent also provides key input in support of the overall marketing data architecture. In addition, this position ensures that quality performance data is captured and tools are developed to support performance reporting and audience insights mining.
Responsibilities
- Designs and develops Extract, Transform, and Load (ETL) processes within Customer Data Platform (CDP) 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
- 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
- Plays a significant role as a contributor to projects involving marketing stakeholders, software vendors, IT, and data owners to specify/execute new data feeds into the Customer Data Platform and Data Lake from internal repositories and marketing applications (web analytics, data warehouse, etc.)
- Develops automated quality assurance processes to monitor quality of inbound data and ensure the continued accuracy of data processing within the platform
- Supports the Data Engineering Manager in creating reporting and data visualization dashboards
Preferences
- Possesses strong coding skills in SQL, Spark, R and Python
- Displays knowledge of data modeling principles and best practices in building analytics repositories in SQL and NoSQL environments
- Demonstrates ability to diagnose and troubleshoot complex data quality issues
- Displays ability to translate marketing stakeholder requirements into technical specifications
- Experience with cloud computing in the Azure environment with Databricks and Data Factory, or similar technologies
- Experience building data pipelines and analytics repositories on cloud platforms
UPS is an equal opportunity employer. UPS does not discriminate on the basis of race/color/religion/sex/national origin/veteran/disability/age/sexual orientation/gender identity or any other characteristic protected by law
